1. 新增用户
grant all on *.* to '库名'@'%' identified by '库名';
2. 刷新授权表
flush privileges;
3. 删除空用户
use mysql;
delete from user where user='';
flush privileges;
1. 新增用户
grant all on *.* to '库名'@'%' identified by '库名';
2. 刷新授权表
flush privileges;
3. 删除空用户
use mysql;
delete from user where user='';
flush privileges;