Saturday, May 31, 2008

Amarok setup

On Susanne's PC:

Installed MySQL client from repos

Edit /etc/mysql/my.cnf, adding this line to stanzas [client] and [mysqld]:
default-character-set = utf8

sudo /etc/init.d/mysql restart

installed mysql server
had to enter password

susanne@arwen:~$ mysql -p -u root
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 4
Server version: 5.0.45-Debian_1ubuntu3.3-log Debian etch distribution

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

set password for root@localhost = password('xxxxxxx');

mysql> CREATE DATABASE amarok;
Query OK, 1 row affected (0.02 sec)

mysql> USE amarok;
Database changed
mysql> GRANT ALL ON amarok.* TO amarok@localhost IDENTIFIED BY 'PASSWORD'
-> ;
Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

mysql> Aborted

No comments: