Sequel Pro 和 MySQL 连接失败

发布于07月05日

我刚刚在mac上用brew 软件安装了mysql

brew install mysql

mysql -V

mysql  Ver 8.0.11 for osx10.13 on x86_64 (Homebrew)

从终端它可以工作，我可以登录到mysql，但从Sequel Pro它说

无法连接到主机127.0.0.1，或请求超时.

确保地址正确，并且你有必要的

MySQL表示:身份验证插件"缓存\u sha2\u密码"不能被删除

不知道我错过了什么

mysql+brew

基本上，您必须手动执行一些操作，然而，您的数据库数据不会像下面的解决方案中那样被删除

go 我的办公室.cnf文件，并在第[mysqld]节中添加行:

default-authentication-plugin=mysql_native_password
从终端登录mysql服务器:运行mysql -u root -p，然后在shell内部执行以下命令(用实际密码替换[password]):

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '[password]';
用exit退出mysql shell，然后运行brew services restart mysql.

应该有用.

快速修复( destruct 性方法)

非brew 安装的快速修复:

Apple Logo > System Preferences > MySQL > Initialize Database，然后键入新密码并 Select "使用旧密码"

重新启动后，您应该能够连接.只在新安装时执行此操作，否则可能会丢失数据库表.

我的cnf

这是我的.cnf文件位于/etc/my.Unix/Linux上的cnf

Select

For those who is still struggling with Sequel Pro problems: Sequel Pro was a great product, but with tons of unresolved issues and last release being dated to 2016 perhaps it's a good idea to look for some alternatives. There is a fork of SequelPro called SequelAce that seems to be pretty stable and up-to-date, it keeps similar functionality, similar look and feel, yet at the same time it is devoid of old Sequel Pro problems