mysql创建用户，并授权

CREATE USER ‘username‘@‘host‘ IDENTIFIED BY ‘password‘;

CREATE USER ‘zsg‘@‘%‘ IDENTIFIED BY ‘123456‘;

GRANT privileges ON databasename.tablename TO ‘username‘@‘host‘

CREATE USER ‘dfjrCase‘@‘%‘ IDENTIFIED BY ‘Dfjr1688‘;

GRANT ALL PRIVILEGES ON dfjr_case.* TO ‘dfjrCase‘@‘%‘ IDENTIFIED BY ‘Dfjr1688‘;

flush privileges;

mysql创建用户，并授权

原文：http://www.cnblogs.com/zsg88/p/7526924.html