Setting the default authentication plug-in to mysql_native_password or Legacy Password Encryption method

When installing or upgrading to MySQL 8.0 using the package installer, select Use Legacy Authentication Method (Retain MySQL 5.x Compatibility) in the Authentication Method step.

For more information, see the following MySQL documentation:

https://dev.mysql.com/doc/mysql-windows-excerpt/8.0/en/mysql-installer-workflow-server.html#server-authentication-method

You can change the default user password authentication plug-in after you have installed MySQL 8.0.

1. Stop the MySQL server.

2. Open one of the my.ini options files, and add the following entry:

   [mysqld]
   mysql_native_password=ON

   For more information, see Using Option Files in the MySQL 8.0 Reference Manual.

3. Restart the MySQL server.

   Note:

   After you restart MySQL, mysql_native_password will be the default authentication plug-in. To verify which users are using the mysql_native_password authentication plug-in, execute the following query:

   SELECT user, Plugin FROM mysql.user;