Mailinglist Archive: opensuse (3618 mails)

< Previous Next >
Re: [opensuse] Amarok and MySQL
  • From: Rodney Baker <rodney.baker@xxxxxxxxxxxx>
  • Date: Sun, 1 Feb 2009 00:17:35 +1030
  • Message-id: <200902010017.44064.rodney.baker@xxxxxxxxxxxx>
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:

http://amarok.kde.org/wiki/MySQL_HowTo

Regards,
Rodney.

--
===================================================
Rodney Baker VK5ZTV
rodney.baker@xxxxxxxxxxxx
===================================================


< Previous Next >
Follow Ups
References