Speed Up Amarok Collection

Whereas my last two posts were compiled from several different sources, this one was ripped off wholesale from this fellows' blog. I reproduce it here largely for my own convenience.

First, install MySQL:

sudo aptitude install mysql-server mysql-client

. Next, give yourself a MySQL password (replacing the capitalized work PASSWORD with a password of your own invention):

mysqladmin -u root password PASSWORD

Finally, create the database for Amarok (once again substituting the password you chose instead of PASSWORD).

mysql -p -u root

CREATE DATABASE amarok;

USE mysql;

GRANT ALL ON amarok.* TO amarok@localhost IDENTIFIED BY 'PASSWORD';

FLUSH PRIVILEGES;

quit

Fire up Amarok, choose settings, configure Amarok, Collection. Use the following settings:

Hostname: 127.0.0.1
Database: amarok
Port: 3306
Username: amarok
Password: Your Password

Now Amarok's collection should be much speedier.