Bug 386004 - no connection with mariadb (Debian Stretch)
Summary: no connection with mariadb (Debian Stretch)
Status: REPORTED
Alias: None
Product: amarok
Classification: Applications
Component: Collections/Local (show other bugs)
Version: 2.8.0
Platform: Debian stable Linux
: NOR major
Target Milestone: 2.9
Assignee: Amarok Developers
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2017-10-20 21:01 UTC by Jaap van Wingerde
Modified: 2019-04-28 20:49 UTC (History)
3 users (show)

See Also:
Latest Commit:
Version Fixed In:
Sentry Crash Report:

Attachments
Add an attachment

Note You need to log in before you can comment on or make changes to this bug.
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"...