MySQL changing authentication type from standard to caching_sha2_password

Question

I've setup a new MySQL instance on a computer and every time I add a user it sets the Authentication Type to caching_sha2_password.

This happens even if I set the Authentication Type to "Standard", it then changes it when I save the user. I've also changed the default authentication plug in to "mysql_native_password", but it still keeps doing it.

With it using the caching_sha2_password I can't connect to the database from .net core as I get an error stating:

MySqlException: Authentication method 'caching_sha2_password' not supported by any of the available plugins

How do I get it to save users with the Standard authentication type?

Answer 1

I had the same problem today. The only way I found to fix it was:

1. executing the install file
2. select "Reconfigure" over the mysql server
3. In Authentication Method tab, select "Use Legacy Authentication Method"

It should fix your problem.

Answer 2

Run

mysql> CREATE USER ‘username’@‘localhost’ IDENTIFIED WITH mysql_native_password BY ‘password’;