Posted by & filed under amarok, linux, music, mysql, ubuntu.

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