MySQL Connect funktioniert nicht mit SequelPro

  • Configuration liegt unter/usr/local/etc/my.cnf
  • Go to my.cnf 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.

 

Quelle