Authentication plugin error when connecting to mySQL

Question

I am learning PHP and just installed Sequel Pro. I am trying to make a connection but it is giving a long error but last line says

MySQL said: Authentication plugin 'caching_sha2_password' cannot be loaded: dlopen(/usr/local/lib/plugin/caching_sha2_password.so, 2): image not found

Before this, I was getting

MySQL said: Can't connect to MySQL server on '127.0.0.1' (61)

and I found mysql.server start on another SO thread but now it is Authentication plugin error.

I am using MacOS Big Sur on M1 chipset. Not sure why I am getting the error or how to fix it

Answer 1

You may try using the ALTER command to change the password instead which would help prevent the authentication plugin caching_sha2_password:

ALTER USER 'username'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password';