CODEWITHSUNDEEP
mysql
Vyacheslav Kovalchuk
Vyacheslav Kovalchuk

Reputation: 363

MySQL plugin Standard is not loaded

I was trying to reinstall MySQL server 8.0 in order to use legacy authentication method, but got the following error in log when installer was attempting to start the server:

MySQL error 0: Authentication to host 'localhost' for user 'root' using method 'mysql_native_password' failed with message: Plugin 'Standard' is not loaded

How can i fix it?

Upvotes: 0

Views: 376

Answers (1)

danblack
danblack

Reputation: 14701

caching_sha2_password is the default authentication mechanism in 8.0. So use a client that support this. Or using the mysql-8.0 client, create a new user using CREATE USER:

CREATE USER 'vyacheslav'@'localhost'
  IDENTIFIED WITH mysql_native_password BY 'password';

Upvotes: 2

Related Questions