Sequel Pro and MySQL connection failed

大佬教程收集整理的这篇文章主要介绍了Sequel Pro and MySQL connection failed，大佬教程大佬觉得挺不错的，现在分享给大家，也给大家做个参考。

如何解决Sequel Pro and MySQL connection failed？

This is because Sequel Pro is not ready yet for a new kind of user login, as the error states: there is no driver. Quick fix for non-homebrew installs:

Apple logo > System Preferences > MysqL > Initialize Database, then type your new password and SELEct ‘Use legacy password’

After restart you should be able to connect. Do it only on fresh installs, because you may lost your db tables otherwise.

Basically you will have to perform some actions manually, however- your database data won’t be deleted like in solution above

• Go to [my.cnf][1] file and in section [MysqLd] add line:

default-authentication-plugin=MysqL_native_password

• Login to MysqL server from terminal: run @H_132_5@mysqL -u root -p, then insIDe sHell execute this command (replacing [password] with your actual password):

ALTER USER 'root'@'localhost' IDENTIFIED WITH MysqL_native_password BY '[password]';

• exit from MysqL sHell with exit and run brew services restart MysqL.

Should work.

The my.cnf file is located in /etc/my.cnf on Unix/linux

解决方法

brew install mysql

mysql -V

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

大佬总结

以上是大佬教程为你收集整理的Sequel Pro and MySQL connection failed全部内容，希望文章能够帮你解决Sequel Pro and MySQL connection failed所遇到的程序开发问题。

如果觉得大佬教程网站内容还不错，欢迎将大佬教程推荐给程序员好友。

本图文内容来源于网友网络收集整理提供，作为学习参考使用，版权属于原作者。
如您有任何意见或建议可联系处理。小编QQ：384754419，请注明来意。