Быстро можно так:
CREATE USER 'user'@'localhost' IDENTIFIED BY 'pass';
CREATE DATABASE dbname CHARACTER SET utf8 COLLATE utf8_general_ci;
GRANT ALL PRIVILEGES ON dbname.* TO 'user'@'localhost';
FLUSH PRIVILEGES;
Быстро можно так:
CREATE USER 'user'@'localhost' IDENTIFIED BY 'pass';
CREATE DATABASE dbname CHARACTER SET utf8 COLLATE utf8_general_ci;
GRANT ALL PRIVILEGES ON dbname.* TO 'user'@'localhost';
FLUSH PRIVILEGES;