mysql 新建用户
create user ‘username’@‘%’ IDENTIFIED BY ‘password’; % 代表可以从任何地方连接
create user ‘username’@‘localhost’ IDENTIFIED BY ‘password’; 代表可以只能从mysql安装的服务器连接
赋权
GRANT ALL PRIVILEGES ON . ‘username’@‘%’
查看权限
show grants for ‘username’@‘%’
flash PRIVILEGES