MYSQL创建用户+授权 命令

create user wwj@'%' identified by '123456'; 创建用户

 

grant all on *.* to wwj@'%';   授权

 

select user ,host,authentication_string from mysql.user; 查询用户以及权限