[opensuse] Amarok and MySQL
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
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
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
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
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
On Sat, 31 Jan 2009 09:33:20 +0000 Bob Williams <linux@barrowhillfarm.org.uk> 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
On Saturday 31 January 2009 11:37:32 Martin /Nightowl/ Byttebier wrote:
On Sat, 31 Jan 2009 09:33:20 +0000
Bob Williams <linux@barrowhillfarm.org.uk> 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
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 ===================================================
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
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
participants (5)
-
Bob Williams -
Martin /Nightowl/ Byttebier -
Robert Smits -
Rodney Baker -
Verner Kjærsgaard