Mike's Ubuntu Blog: How to: set up MySQL Database in Amarok

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;

In Amarok, go to settings> configure AmarokClick CollectionSelect 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!Originaly From: Mike's Ubuntu Blog: How to: set up MySQL Database in Amarok