How to Make Amarok Work with MySQL

I promised earlier to show you how to make amarok work with MySQL. So here’s how.

  1. Install Amarok: This step is pretty simple. Just “sudo apt-get install amarok“. If you are using GNOME, then kde libraries will also be installed automatically. So it may take a bit longer.
  2. Install MySQL Server: This is easy too: “sudo apt-get install msyql-server“. During the installation, you will be asked for a “root password”. This is different from from your Ubuntu’s “root” account: this is a mysql user called root.
  3. Create a amarok user in Mysql:
    • Log into mysql as root: Type one the terminal “mysql -u root -p“. The “-u root” tells mysql that you want to log in as root, and “-p” says that you have a password that you want to supply. So you will be prompted with a password. Enter the one you supplied during mysql installation.
    • Create an amarok database: Once you have logged into mysql, you will have a mysql prompt (“mysql >”). To create the database, simply type “create database amarok;“. Yes, you need to terminate the command with a semi-colon. This creates a database named “amarok” (No prizes for guessing that).
    • Create amarok user: Now to create the user, type “grant all privileges to ‘amarok-user’@’localhost’ on amarok.* identified by ‘amarok-password’ with grant option;” This command will create a user in mysql with username “amarok-user” and password “amarok-password”.
  4. Tell Amarok how to talk to mysql: You can do this at two places –
    • In the First-Run wizard: Here, you will be asked to select the directories to include in “The Collection”, and how to store the collection. In the How, select “MySQL”. Fill out the “host” as ‘localhost’, port as ‘3306’ (this should be correct in 99.99% cases). Fill in database = amarok, username = amarok-user, and password = amarok-password. Note that these paramaters are the ones that you supplied in step 3.
    • Later on: Go to Settings > Configure Amarok > Collection tab. Set the folder(s) you want to monitor first. Then select the “database” as “MySQL”. In the configuration, enter host = localhost, port = 3306, database = amarok, username = amarok-user and password = amarok-password.

Ta-da! Its done!! Now Amarok will take some time to build your collection, and then you’ll be ready to rock and roll!

One thought on “How to Make Amarok Work with MySQL

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s