Translations:Amarok/Manual/Organization/Collection/ExternalDatabase/16/en

Create a new user amarokuser with the password amarokpass using the

CREATE USER ''''amarokuser''''@''''localhost'''' IDENTIFIED BY ''''amarokpass'''';

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 ''''amarokuser''''@''''%'''' IDENTIFIED BY ''''amarokpass'''';

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.