- select host,user,plugin from user;
查看user=root对应的host是否是%; - 若不是,update user set host=’%’ where user =‘root’;
- ALTER USER ‘root’@’%’ IDENTIFIED WITH mysql_native_password BY ‘123456’;
%和localhost对应的是select host,user from user where user=‘root’;中的host。
可视化工具连接mysql报2058
最新推荐文章于 2024-02-27 13:06:09 发布