Getting Sequel Pro to read MySQL on MacOS
As a follow-up to the previous post (Installing MySQL on MacOS with Homebrew), to get Sequel Pro working you need to do the following:
Open my.cnf (usually at /usr/local/etc) and add the following line and save:
[mysqld]
default-authentication-plugin=mysql_native_password
Sign into mysql with mysql -u root -p
Set the root user password with:
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '[PASSWORD]';
where [PASSWORD] is a password of your choosing.
Delete my.cnf (MySQL will regenerate it):
sudo rm -rf /usr/local/etc/my.cnf
Restart mysql:
brew services restart mysql
Now Sequel Pro should be able to log into MySQL.
Reference:
Sequel Pro and MySQL connection failed
Cannot find MySQL.sock
No trackbacks yet.