Manage Your Amarok Music Collection with MySQL
Amarok is a powerful music player for Linux, Unix and Windows OS with an intuitive interface. It makes playing the music you love and discovering new music easier than ever before – and it looks good doing it! It can be used to organize a library of music into folders according to genre, artist and album. It can edit tags attached to most music formats, associated album art, attach lyrics and automatically “score” music by keeping play count statistics.
Amarok uses an embedded MySQL database to manage music collections. If you don’t want to dump all your local hard drive with large volume of music files and wish to manage your music collections with an external database, then Amarok has a option for that too.
In this article, let us see how to manage music collections with external MySQL database. It will work on all platforms that supports MySQL. Here, I use Ubuntu 13.04 for this tutorial.
If you haven’t installed MySQL before, install it use the following command:
sk@sk:~$ sudo apt-get install mysql-server mysql-client
During installation, it will ask you to set the password for MySQL root user password. Enter the password twice and continue the installation.
Create MySQL database for Amarok
Let us create a database called amarokdb and database user amarokuser with password ubuntu. Change these values as per your requirement:
sk@sk:~$ mysql -u root -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 42 Server version: 5.5.31-0ubuntu0.13.04.1 (Ubuntu) Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> create database amarokdb; Query OK, 1 row affected (0.01 sec) mysql> GRANT ALL ON amarokdb.* TO amarokuser@localhost IDENTIFIED BY 'ubuntu'; Query OK, 0 rows affected (0.01 sec) mysql> flush privileges; Query OK, 0 rows affected (0.01 sec) mysql> exit Bye
Open Amarok. Go to Settings -> Configure Amarok -> Database. In the database section click on Use external MySQL database checkbox. Enter the MySQL server IP Address, user and database details and click the Apply button.
Like us on Facebook
This week Top Posts
- Top Things To Do After Installing Ubuntu 13.10 'Saucy Salamander' : Ubuntu 13.10 Saucy Salamander will be released on coming October 17th with many new salient featur...0 comments |
- How To Upgrade From Ubuntu 13.04 Raring To Ubuntu 13.10 Saucy Salamander : Ubuntu 13.10 Saucy will be released on October 17th. Hope it will come with lot of improvements and ...0 comments |
- How To Show Username On Panel In Ubuntu 13.04/13.10 : By default usernames are not displayed on panel in Ubuntu 13.04 and 13.10, In this simple tutorial w...0 comments |
- cowsay And fortune Combined Together : Hi linux geeks! In this article I will teach you a nice trick you can perform in the terminal with ...0 comments |
- Install lamp with 1 command in Ubuntu 12.10, 13.04 Raring Ringtail & LinuxMint13 : Updated: 10/09/2012 :LAMP (Linux, Apache, MySQL and PHP) is an open source Web development platform ...0 comments |
- Setup DNS Server On openSUSE 13.1 : What is DNS Server? As you might know, DNS, Domain Name System, is a system that resolves Domain ...0 comments |
- cowsay And fortune Combined Together
- How To Show Username On Panel In Ubuntu 13.04/13.10
- Setup DNS Server On openSUSE 13.1
- TeamViewer 9 Final Has Been Released!
- Twelve Vulnerabilities Have Been Fixed In Ubuntu 12.04, Time To Update
- OpenLDAP Installation and Configuration in Ubuntu 12.10/13.04/13.10 And Debian 6/7
- Configure Your Browser To Use Tor On Ubuntu/Debian/Linux Mint
- Setup A Full Featured ITIL Management System Using Integria IMS On CentOS 6
- Install LibreOffice 4.1.3 in Elementary OS ‘Luna’
- How To Install Simple Scan in Crunchbang ‘Waldorf’
This work by unixmen.com is licensed under a Creative Commons Attribution-NonCommercial-NoDerivs 3.0 Unported License.
Copyright © 2008-2013 Unixmen.com .