CREATE DATABASE db_name;
GRANT ALL PRIVILEGES ON db_name.* TO 'db_user'@'localhost' 
IDENTIFIED BY 'password' WITH GRANT OPTION;

GRANT OPTION - możliwość nadawania uprawnień

DROP USER user@host;
USE mysql;
UPDATE USER SET password=PASSWORD('ElevenBenevolentElephants') WHERE user='root';
FLUSH PRIVILEGES;
mysqladmin -u root password 'ElevenBenevolentElephants'