I found myself complaining about the slow speed of Amarok. Everything would lag, from playing a song to adding a song to the playlist. Then i remembered when I was setting up Amarok that it let me chose a database, and said the faster ones required extra set up. Of course, I chose the no set up required but slow speed option (SQLlite).
Now, I wanted to switch. And boy am i glad. Everything works as fast as it should.
sudo apt-get install mysql-server mysql-client
now this (replace PASSWORD with your password)
mysqladmin -u root password PASSWORD
then this
mysql -p -u root
CREATE DATABASE amarok;
USE mysql;
GRANT ALL ON amarok.* TO amarok@localhost IDENTIFIED BY ‘PASSWORD_CHANGE_ME’;
FLUSH PRIVILEGES;
quit
In Amarok, go to settings> configure Amarok
Click Collection
Select MySQL.
Use the following settings:
Hostname: 127.0.0.1
Database: amarok
Port: 3306
Username: amarok
Password: Your Password
You’re done! Enjoy the speediness!
Problems? check out the official wiki:
http://amarok.kde.org/wiki/MySQL_HowTo
Thank you.
Thx a million
I needed to reinstall MySQl database as I went from Amarok 2 back to Amarok 14
Hint I needed to add sudo to the MYSQL commands otherwise I reveice a weird error
sudo MYSQL -p root
dude
just wanted to thank you for your blog
i've been here often for advice and it's always spot on
keep up the good work
cheers
chi from Greatfeet Productions
[...] case you have a need for expeditious velocity, then you can follow the instruction from this excellent post, in order to have Amarok use MySQL as a [...]
MySQL reported the following error:
Access denied for user 'amarok'@'localhost' (using password: YES)
You can configure MySQL in the Collection section under Settings->Configure Amarok
can any1 help?
thk you,
to sizzla :
GRANT ALL ON amarok.* TO amarok@localhost IDENTIFIED BY ‘PASSWORD_CHANGE_ME’;
you have to change 'PASSWORD_CHANGE_ME' with ur password !!
I have to also say, this was another winner!! Only for me, the line GRANT ALL ON amarok.* TO amarok@localhost IDENTIFIED BY ‘PASSWORD_CHANGE_ME’; , I had to use ” in stead of ‘ for the password section.
Cheers Mike, well done!! I now finally have stable working amarok.
(running Kubuntu 12.10 quantal 64 bit Linux 3.5.0-27 KDE SC4.10.2)