CREATE USER test IDENTIFIED BY 'test'; 建立用户
use mysql
SELECT * FROM USER WHERE USER='test' ;
SHOW GRANTS FOR test; 查看权限
GRANT EXECUTE,INSERT,SELECT,UPDATE ON *.* TO 'test'@'%'; //授权
FLUSH PRIVILEGES; 提交
CREATE USER test IDENTIFIED BY 'test'; 建立用户
use mysql
SELECT * FROM USER WHERE USER='test' ;
SHOW GRANTS FOR test; 查看权限
GRANT EXECUTE,INSERT,SELECT,UPDATE ON *.* TO 'test'@'%'; //授权
FLUSH PRIVILEGES; 提交