1.創(chuàng)建用戶
GRANT USAGE ON *.* TO 'cms'@'%' IDENTIFIED BY '!zk2016' WITH GRANT OPTION;
2.為用戶授權(quán)
GRANT all privileges ON *.* TO 'cms'@'%' IDENTIFIED BY '!zk2016';
3.生效授權(quán)树绩，創(chuàng)建完畢
FLUSH PRIVILEGES;
參考網(wǎng)址：
http://blog.csdn.net/fly0744/article/details/8889586
http://www.cnblogs.com/wanghetao/p/3806888.html
