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

• 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