Mysql 授权命令

授权命令：
grant all privileges on dbname.* to username@'%' identified by 'password';

flush privileges;

ps:在授权时想对某个用户赋权限里要先创建数据库的　create database dbname;
dbname: 授权的数据库名
username:你的用户名
password: 你的密码

查看权限
select user,db,host,select_priv,insert_priv,update_priv,delete_priv from mysql.db where user='username';

授予最高权限
grant all privileges on *.* to username@'%' identified by 'password';