Home > MySQL > Create mysql user

mysql -u root -p

CREATE DATABASE db001

CREATE USER 'alan'@'localhost' IDENTIFIED BY 'password';

GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP,ALTER,INDEX,DROP,LOCK TABLES
ON db001.*
TO 'alan'@'localhost';

reference: http://dev.mysql.com/doc/refman/5.5/en/adding-users.html



Flag Counter