为mysql创建和授权用户
2017-05-22 本文已影响10人
玄月府的小妖在debug
1.创建用户
GRANT USAGE ON *.* TO 'cms'@'%' IDENTIFIED BY '!zk2016' WITH GRANT OPTION;
2.为用户授权
GRANT all privileges ON *.* TO 'cms'@'%' IDENTIFIED BY '!zk2016';
3.生效授权，创建完毕
FLUSH PRIVILEGES;
参考网址：
http://blog.csdn.net/fly0744/article/details/8889586
http://www.cnblogs.com/wanghetao/p/3806888.html
