|
|
| (27 intermediate revisions by 9 users not shown) |
| Line 1: |
Line 1: |
| == Introduction ==
| | <languages /> |
| | <translate> |
|
| |
|
| Amarok allows you to store information like bookmarks, lyrics, playlists and statistics in an external database.
| | ==== Remote Collections ==== <!--T:1--> |
|
| |
|
| == Configure Server ==
| | <!--T:2--> |
| | Often it is very useful to share your media files across the network, especially if you want to use it on different computers. This can be done in different ways: |
| | * [[Special:myLanguage/Amarok/Manual/Organization/Collection/RemoteCollections/Ampache|Ampache]] |
| | * [[Special:myLanguage/Amarok/Manual/Organization/Collection/RemoteCollections/DAAP#Digital Audio Access Protocol (DAAP)|DAAP]] |
| | * [[Special:myLanguage/Amarok/Manual/Organization/Collection/RemoteCollections/Samba|Samba]] |
| | * [[Special:myLanguage/Amarok/Manual/Organization/Collection/RemoteCollections/UPnP#Universal Plug and Play (UPnP)|UPnP]] |
|
| |
|
| === Install MySQL-Server ===
| |
|
| |
|
| First you need to install an '''MySQL'''-Server, either on the local or another computer on the same network. On Debian-based distributions like Ubuntu you can use ''sudo apt-get install mysql-server'' to install it. You will be asked to specify a password for the root-account for the database.
| | <!--T:3--> |
| | {{Prevnext2 |
| | | prevpage=Special:myLanguage/Amarok/Manual/Organization/Collection/StatisticsSynchronization | nextpage=Special:myLanguage/Amarok/Manual/Organization/Collection/RemoteCollections/Ampache |
| | | prevtext=Statistics Synchronization Between Collections and with Last.fm | nexttext=Ampache |
| | | index= Special:myLanguage/Amarok/Manual | indextext=Back to Menu |
| | }} |
|
| |
|
| === Configure Database ===
| | <!--T:4--> |
| | | [[Category:Amarok2.8]] |
| Connect to the local database using ''mysql -u root -p mysql''. Then you will get the ''mysql>'' prompt. <br />
| | [[Category:Multimedia]] |
| Create a new user '''''amarokuser''''' with the password '''''amarokpass''''' using the ''CREATE USER '''<nowiki>'</nowiki>amarokuser<nowiki>'</nowiki>'''@'''<nowiki>'</nowiki>localhost<nowiki>'</nowiki>''' IDENTIFIED BY '''<nowiki>'</nowiki>amarokpass<nowiki>'</nowiki>''';'' command. Amarok needs its own database, which is created with ''CREATE DATABASE '''amarokdb''';''. Give the new user access to the database by entering the ''GRANT ALL ON '''amarokdb'''.* TO '''<nowiki>'</nowiki>amarokuser<nowiki>'</nowiki>'''@'''<nowiki>'</nowiki>%<nowiki>'</nowiki>''' IDENTIFIED BY '''<nowiki>'</nowiki>amarokpass<nowiki>'</nowiki>''';'' command, where ''%'' is a wildcard to allow all hosts to connect to the database. Now use the ''FLUSH PRIVILEGES;'' statement to reload various internal caches used by MySQL. Finally ''exit'' closes the MySQL-prompt.<br />
| | [[Category:Tutorials]] |
| By default the server can only be accessed by the local host. To change this you need to edit the file ''/etc/mysql/my.cnf'' and adjust the address near ''bind-address'' to the one your server listens on the network. '''0.0.0.0''' listens on all interfaces. After that you need to restart the server using ''sudo service mysql restart''.
| | </translate> |
| | |
| == Configure Client ==
| |
| | |
| Open the configuration dialog by clicking <menuchoice>Settings -> Configure Amarok... -> Database</menuchoice>. Enable the checkbox and enter the user data.<br />
| |
| [[File:remotecollections_client.png]]<br /> | |
| You need to restart Amarok so that the changes take effect.
| |
