MYSQL 创建用户
#创建数据库zry
create database zry;
#创建用户zry,密码为zryhappy
create user 'zry'@'%' identified by 'zryhappy';
#将数据库zry的所有权限赋给用户zry
grant all privileges on zry.* to 'zry'@'%' identified by 'zryhappy';
#让zry用户可以将自己本身所拥有权限赋给其他用户
grant grant option on *.* to 'zry'@'%';
------------------------------------------------------------------------------------------------------------
#其他赋予权限的sql语句:
grant all on *.* to 'zry'@'%';
grant select,insert,update,delete,create,drop,reload,shutdown,process,file,references,index,alter,show databases,super,create temporary tables,lock tables,execute,replication slave, replication client,create view,show view,create routine,alter routine,create user,event,trigger on *.* to 'zry'@'%';
---------------------------------------------------------
#查询当前用户
select user();
------------------------------------------------------------------
#查询所有用户
select user,host,password from mysql.user;
-----------------------------------------------------------------
#允许root用户在其他主机登陆
use mysql;
update user set host='%' where user='root';
-----------------------------------------------------------------