1 查看mysql中的用户
SELECT host,user,authentication_string from mysql.user;
2 创建mysql用户
CREATE user '用户名称'@'%' IDENTIFIED BY '用户密码';
3 赋予mysql用户权限
3.1 赋予mysql用户所有权限
GRANT ALL PRIVILEGES ON *.* TO '用户名称'@'%' WITH GRANT OPTION;
3.2 赋予mysql用户指定数据库的读、删、更新权限
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE,ALTER,DROP ON 数据库名称.* TO '用户名称'@'%'
IDENTIFIED BY '用户密码';