~/.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)
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';
In your case "@10.0.0.159"...
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