1、新建用户,查看用户
查看用户
mysql> select host, user, password from mysql.user; -- 5.7版本之前的
mysql> select host, user, authentication_string from mysql.user; -- 5.7版本之后的,包括5.7
新建用户和密码
create user "用户名"@"IP地址" identified by "密码";
2、给用户授权,查看用户权限
mysql> grant 权限类型 on 数据库名.表名 to '用户名'@'ip地址' identified by '用户密码' with grant option;
grant all privileges on 数据库名.* to 'XXX'@'%' identified by 'XXXX' ;
3、刷新权限
flush privileges;
show grants for "XXXX"@"%";