mysql运行 grant all privileges on username.* to 'database' @'%' identified by 'password';
username用户名,database数据库名称, password密码
如果要删除某个用户test的权限的话
DELETE FROM mysql.user WHERE User='test';
DELETE FROM mysql.db WHERE User='test';
DELETE FROM mysql.tables_priv WHERE User='test';
DELETE FROM mysql.columns_priv WHERE User='test';
DELETE FROM mysql.procs_priv WHERE User='test';
flush privileges;
刷新mysql,让权限设置立刻生肖