Mysql make user and password

First of all make database

mysql> create database DBName;

See all database list

mysql> show databases

mysql> use mysql

Making general user

mysql> grant usage on *.* to amarokuser@localhost identified by 'amarokpasswd'; Query OK, 0 rows affected (0.00 sec)

Making the user having all authorities

mysql> grant all privileges on amarokdb.* to amarokuser@localhost ; Query OK, 0 rows affected (0.00 sec)

commit all changes

mysql> FLUSH PRIVILEGES;

see allowed ip adresses

SELECT Host FROM mysql.user WHERE user='root';