Hi,
I wanted to play some music, so I started amarok this time instead of
banshee. I noticed that for the database it said it can use mysql instead
of a localdatabase, so I tried. I created the database as the instructions
on the help of the configuration window say:
> Telcontar:~ # mysql --password=******
> Welcome to the MySQL monitor. Commands end with ; or \g.
> Your MySQL connection id is 4
> Server version: 5.1.57-log SUSE MySQL RPM
>
> Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.
> This software comes with ABSOLUTELY NO WARRANTY. This is free software,
> and you are welcome to modify and redistribute it under the GPL v2 license
>
> Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
>
> mysql> CREATE DATABASE amarokdb;
> Query OK, 1 row affected (0.12 sec)
>
> mysql> GRANT ALL PRIVILEGES ON amarokdb.* TO 'amarokuser' IDENTIFIED BY 'hola2';
> Query OK, 0 rows affected (0.09 sec)
>
> mysql> FLUDH PRIVILEGES;
> ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FLUDH PRIVILEGES' at line 1
> mysql> FLUSH PRIVILEGES;
> Query OK, 0 rows affected (0.03 sec)
>
> mysql> exit
> Bye
Then I exited amarok, restarted it, and saw some process scanning the disk.
But I see no music in the database, and there are no new files in
“/var/lib/mysql/amarokdb/” except “db.opt” (61 bytes). So I tried:
> Telcontar:~ # mysql --user=amarokuser --password=hola2
> ERROR 1045 (28000): Access denied for user 'amarokuser'@'localhost' (using password: YES)
> Telcontar:~ #
It is not working. Perhaps the user “amarokuser” has to also exist as a
system user? Or should I use the same user as my normal user instead?
–
Cheers / Saludos,
Carlos E. R.
(from 11.4 x86_64 “Celadon” at Telcontar)