为mysql创建和授权用户

1.创建用户

GRANT USAGE ON *.* TO 'cms'@'%' IDENTIFIED BY '!zk2016' WITH GRANT OPTION;

2.为用户授权
GRANT all privileges ON *.*TO 'cms'@'%' IDENTIFIED BY '!zk2016';

【为mysql创建和授权用户】3.生效授权,创建完毕
FLUSH PRIVILEGES;

参考网址:
http://blog.csdn.net/fly0744/article/details/8889586
http://www.cnblogs.com/wanghetao/p/3806888.html

    推荐阅读