select user();

select database();

update mysql.user set password=password('新密码') where user='用户名';

flush privileges;

 # mysql -u root -p

 # 允许本地 IP 访问 localhost, 127.0.0.1

 # insert into mysql.user(Host,User,Password) values('localhost','zhouz',password(''));

 # 允许外网 IP 访问

 # insert into mysql.user(Host,User,Password) values('%','zhouz',password(''));

 # 刷新授权

 # flush privileges;

 # 创建数据库

 # create database zhouzdb DEFAULT CHARSET utf8 COLLATE utf8_general_ci;

 # 授予用户通过外网IP对于该数据库的全部权限

 # grant all privileges on `zhouzdb`.* to 'zhouz'@'%' identified by '';

 # 授予用户在本地服务器对该数据库的全部权限

 # grant all privileges on `zhouzdb`.* to 'zhouz'@'localhost' identified by '';

 # 刷新权限

 # flush privileges;

 # 退出 root 重新登录

 # \q

 # 已新帐号 zhouz 登录，由于使用的是 % 任意IP连接，所以需要指定外部访问IP

 # mysql -u zhouz -h 192.168.1.168 -p

 #  

grant usage on test.* to zhangsan@localhost identified by 'zhangsan1';

grant select on test.* to zhangsan@localhost;

revoke all privileges on test.* from zhangsan@localhost;