# mysql -u root -p
mysql> CREATE DATABASE `dbname`;
mysql> CREATE USER 'username'@'localhost' IDENTIFIED BY 'password';
mysql> GRANT ALL PRIVILEGES ON `dbname`.* TO 'username'@'localhost';
mysql> FLUSH PRIVILEGES;
Вариант назначения прав суперпользователя
mysql> GRANT ALL PRIVILEGES ON *.* TO 'username'@'localhost' WITH GRANT OPTION;
mysql> FLUSH PRIVILEGES