navicat连接远程MySQL崩溃
Tofloor
poster avatar
bg2it
deepin
2019-08-04 23:03
Author
navicat连接远程阿里云服务器上的MySQL 出现崩溃,连接我虚拟机上的MySQL是没问题的,有人遇到过这种问题吗?怎么解决?
Reply Favorite View the author
All Replies
avatar
bg2it
deepin
2019-08-04 23:08
#1
Reply View the author
avatar
文刀
deepin
2019-08-04 23:26
#2
使用DBeaver试试,感觉Navicat毕竟不是原生Linux
Reply View the author
avatar
bg2it
deepin
2019-08-05 01:20
#3
https://bbs.deepin.org/post/181587
使用DBeaver试试,感觉Navicat毕竟不是原生Linux

谢谢
刚刚解决了
应该是不支持caching-sha2-password导致的
修改了数据库密码认证插件就搞定了
ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY 'password';
Reply View the author