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

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

mysql + homebrew

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

  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.

my.cnf

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