[opensuse] Amarok and MySQL - openSUSE Users - openSUSE Mailing Lists

newer
[opensuse] MSA 500 and OpenSuSE 11

[opensuse] Amarok and MySQL

older
[opensuse] Re: Who is using Gnome?

Bob Williams

31 Jan 2009 31 Jan '09

09:33

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 -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org

Reply

Sign in to reply online Use email software

Show replies by date

Verner Kjærsgaard

31 Jan 31 Jan

09:37

Bob Williams skrev:

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

Hi install webmin. Use it to create the amarak user (if it's not root). Use it to handle users and passwords in MySQL. -- ------------------------------ Med venlig hilsen/Best regards Verner Kjærsgaard Open Source Academy +45 56964223 Novell Certified Linux Professional 10035701 ------------------------------ -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org

Reply

Sign in to reply online Use email software

Bob Williams

11:10

On Saturday 31 January 2009 09:37:56 Verner Kjærsgaard wrote:

Bob Williams skrev:

...
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

Hi

install webmin. Use it to create the amarak user (if it's not root). Use it to handle users and passwords in MySQL.

Thank you. Which repository would I find it in? #zypper in webmin Retrieving repository 'RPM' metadata [done] Loading repository data... Reading installed packages... 'webmin' not found. Resolving package dependencies... Nothing to do. :( 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

Reply

Sign in to reply online Use email software

Verner Kjærsgaard

15:55

Bob Williams skrev:

On Saturday 31 January 2009 09:37:56 Verner Kjærsgaard wrote:

...
Bob Williams skrev:

...
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 Hi

install webmin. Use it to create the amarak user (if it's not root). Use it to handle users and passwords in MySQL.

Thank you. Which repository would I find it in?

#zypper in webmin Retrieving repository 'RPM' metadata [done] Loading repository data... Reading installed packages... 'webmin' not found. Resolving package dependencies... Nothing to do.

:(

Bob

To the best of my knowledge it's not in any repo. Just surf to www.webmin.com and fetch the RPM. Install, as root, with #rpm -Uvh webmin... Then fire up your browser, goto http://localhost:10000 :-) -- ------------------------------ Med venlig hilsen/Best regards Verner Kjærsgaard Open Source Academy +45 56964223 Novell Certified Linux Professional 10035701 ------------------------------ -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org

Reply

Sign in to reply online Use email software

Bob Williams

16:33

On Saturday 31 January 2009 15:55:37 Verner Kjærsgaard wrote:

Bob Williams skrev:

...
On Saturday 31 January 2009 09:37:56 Verner Kjærsgaard wrote:

...
Bob Williams skrev:

...
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

Hi

install webmin. Use it to create the amarak user (if it's not root). Use it to handle users and passwords in MySQL.

Thank you. Which repository would I find it in?

#zypper in webmin Retrieving repository 'RPM' metadata [done] Loading repository data... Reading installed packages... 'webmin' not found. Resolving package dependencies... Nothing to do.

:(

Bob

To the best of my knowledge it's not in any repo. Just surf to www.webmin.com and fetch the RPM. Install, as root, with #rpm -Uvh webmin...

Then fire up your browser, goto http://localhost:10000

:-)

Well, that's really good app. I shall enjoy playing with it. Thanks Verner. 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

Reply

Sign in to reply online Use email software

Martin /Nightowl/ Byttebier

11:37

On Sat, 31 Jan 2009 09:33:20 +0000 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.

URL:http://opensuse-community.org/Amarok Maybe this will help you. TTFN, Martin -- UTSI: http://users.telenet.be/tos4ever/utsi.htm Atari FTP-site: ftp://kurobox.serveftp.net:3021 Running openSuse 11.1 / KDE 3.5.10 -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org

Reply

Sign in to reply online Use email software

Bob Williams

16:34

On Saturday 31 January 2009 11:37:32 Martin /Nightowl/ Byttebier wrote:

On Sat, 31 Jan 2009 09:33:20 +0000

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.

URL:http://opensuse-community.org/Amarok

Maybe this will help you.

TTFN, Martin

Great. That's just what I needed. Thank you. 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

Reply

Sign in to reply online Use email software

Rodney Baker

13:47

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@iinet.net.au ===================================================

Reply

Sign in to reply online Use email software

Bob Williams

16:35

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:

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

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

Reply

Sign in to reply online Use email software

Robert Smits

3 Feb 3 Feb

18:31

On January 31, 2009 01:33:20 am 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.

Bob, there's a set of instructions at http://opensuse-community.org/Amarok#Getting_Amarok_to_work_with_MySQL that works just fine for getting Amarok 1.4 to work with Mysql. I use Amarok 1.4 on OpenSuse 11.0 with KDE 3.5.10, and it works fine. Use Yast. Install Mysql. Enable it to run on start. Add the database name and password. Run Amarok and switch to mysql - note this needs the packman version of amarok, not the original suse version. All this is detailed in the notes at the url above. Bob. -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org

Reply

Sign in to reply online Use email software

5569

Age (days ago)

5572

Last active (days ago)

Download

9 comments

5 participants

tags

participants (5)

Bob Williams
Martin /Nightowl/ Byttebier
Robert Smits
Rodney Baker
Verner Kjærsgaard