Bug 386004

Summary: no connection with mariadb (Debian Stretch)
Product: [Applications] amarok Reporter: Jaap van Wingerde <kde>
Component: Collections/LocalAssignee: Amarok Bugs <amarok-bugs-null>
Status: RESOLVED FIXED    
Severity: major CC: cancellettopugno, matej, ralf-engels
Priority: NOR    
Version First Reported In: 2.8.0   
Target Milestone: 2.9   
Platform: Debian stable   
OS: Linux   
Latest Commit: https://invent.kde.org/multimedia/amarok/-/commit/076ec26aa79956c5e18f7cd3f015ba2092ed51ce Version Fixed/Implemented In:
Sentry Crash Report:

Description Jaap van Wingerde 2017-10-20 21:01:38 UTC 
~/.kde/share/config/amarokrc:
...
[MySQL]
Host=10.0.0.159
Password=secret
UseServer=true
...


jaap@jaap:/$ amarok --debug --nofork
...
amarok:             connection to mysql failed 
amarok:             [ERROR__] Could not connect to mysql! 
amarok:             [ERROR__] [MySqlStorage] "GREPME MySQL-server query failed! (1045) Access denied for user 'amarokuser'@'jaap.custard.shrl.nl' (using password: YES) on na" 
...


jaap.custard.shrl.nl is the local machine (10.0.0.150) without database server
10.0.0.159 is the database server (Debian Jessie)
Comment 1 Francesco Talamona 2019-04-28 20:48:17 UTC 
I discovered that with MariaDb the suggested command is not sufficient.

Instead of:
GRANT ALL PRIVILEGES ON amarokdb.* TO amarokuser IDENTIFIED BY 'secret'; 

it should be:
GRANT ALL PRIVILEGES ON amarokdb.* TO amarokuser@localhost IDENTIFIED BY 'secret';
Comment 2 Francesco Talamona 2019-04-28 20:49:14 UTC 
In your case "@10.0.0.159"...
Comment 3 Tuomas Nurmi 2025-07-09 17:27:04 UTC 
Git commit 076ec26aa79956c5e18f7cd3f015ba2092ed51ce by Tuomas Nurmi.
Committed on 09/07/2025 at 17:18.
Pushed by nurmi into branch 'master'.

Fix example permission grant command in database settings

MariaDB requires a domain (at least if there are anonymous users in db).
Adding domain 'localhost' makes everything work even if there are those
left. If not, wildcard '%' works. Not possible to know from which address
the user connects to the db, so assume that remote connectors have those
anonymous users disabled.

M  +1    -0    ChangeLog
M  +5    -2    src/configdialog/dialogs/DatabaseConfig.cpp

https://invent.kde.org/multimedia/amarok/-/commit/076ec26aa79956c5e18f7cd3f015ba2092ed51ce