刷新权限,用户 flush privileges;
创建用户 create user 'fanjiarong'@'%' identified by 'fjr';
链接:mysql -u root -p
切换数据库:use mysql;
查询用户:select user,host from user;
授权:grant all on *.* to fanjiarong@192.168.10.204;
取消授权: revoke all on *.* from fanjiarong@192.168.10.204;
查看授权: show grants for fanjiarong@192.168.10.204;
退出:exit
修改用户密码:UPDATE user SET password=PASSWORD("new password") WHERE user='username';
转载于:https://my.oschina.net/fjr/blog/735676