【Mysql】Macos homebrew install mysql@8.0 up
2018-07-02 11:59 范仲淹三打白骨精 阅读(390) 评论(0) 编辑 收藏 举报mysql出了8.0的版本了,但安装之后Navicat连接不上,出现提示:
----------------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------------
在网上查找相关资料后,在知乎大神 @小菜鸟也想飞 那找到了解决方法:
----------------------------------------------------------------------------------------------------------
------------------------------------------------------------------------------------------------
在终端mysql里打出这两行代码,即可用navicat连接mysql:
UPDATE mysql.user SET plugin = 'mysql_native_password';
alter user '用户名'@localhost IDENTIFIED WITH mysql_native_password by '你的密码';