解决MySQL新增用户无法登陆问题

1. 新增用户

grant all on *.* to '库名'@'%' identified by '库名';


2. 刷新授权表
flush privileges;

3. 删除空用户

use mysql;
delete from user where user='';
flush privileges;

posted @ 2017-05-16 15:35  煜叔  阅读(421)  评论(0)    收藏  举报