On Saturday 31 January 2009 13:47:35 Rodney Baker wrote:
On Saturday 31 January 2009 20:03:20 Bob Williams wrote:
I'm trying to get Amarok 1.4 to use the MySQL database, and I think I've messed things up. I'm using KDE 3.5.10 running on opensuse 11.1.
Under MySQL Configuration, I've got
Hostname: localhost Port: 3306 Database: amarok
Questions:
1. What is the correct Username? 2. What is the correct password?
Do I need to make any magic incantations to the MySQL god (or daemon)? I've setup mysqld to start at bootup.
I keep getting 'Access Denied' error messages, whatever I enter for 1 and 2 above.
Bob -- Registered Linux User #463880 FSFE Member #1300 GPG-FP: A6C1 457C 6DBA B13E 5524 F703 D12A FB79 926B 994E openSUSE 11.1, Kernel 2.6.27.7-9-default, KDE 3.5.10 Intel Core2 Quad Q9400 2.66GHz, 4GB DDR RAM, nVidia GeForce 9200GS
Bob,
Have you created the amarok database? You need to do the following (as root);
Set the root password for mysql Create the amarok database Create the amarok user and assign a password Give the user the appropriate grants to access the amarok database (critically important).
There are instructions on the page that Martin gave you the link to.
More detailed instructions and explanations are here:
Thanks. I've got there now :) Bob -- Registered Linux User #463880 FSFE Member #1300 GPG-FP: A6C1 457C 6DBA B13E 5524 F703 D12A FB79 926B 994E openSUSE 11.1, Kernel 2.6.27.7-9-default, KDE 3.5.10 Intel Core2 Quad Q9400 2.66GHz, 4GB DDR RAM, nVidia GeForce 9200GS -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org