EN
Sequel Pro - MySQL said: Authentication plugin 'caching_sha2_password' cannot be loaded: dlopen(/usr/local/lib/plugin/caching_sha2_password.so, 2): image not found under MacOS
1
answers
3
points
When I try to connect to MySQL with Sequel Pro, I get the following error:
MySQL said: Authentication plugin 'caching_sha2_password' cannot be loaded: dlopen(/usr/local/lib/plugin/caching_sha2_password.so, 2): image not found
Screenshots:
1 answer
3
points
I have found the solution. The MySQL 8.0 that I use, requires some additional configurations.
Steps:
1. I have logged as root user into MySQL console using the MacOS terminal:
/usr/local/mysql-8.0.27-macos11-x86_64/bin/mysql -u root -p
2. I have added permissions by executing (optional step):
GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost';
3. I have updated the password by executing:
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'root_password_here';
4. to exit MySQL console:
exit
0 comments
Add comment