MySQL force Authentication Type to use Standard

(Last Updated On: 2019-10-31)

As I am installing ITOP and WordPress I ran into a problem where the authentication did not work. Looking into the issue it seemed the user being created on MySQL needs to be with Authentication Type: Standard.

Well, that seems easy enough. Logged into MySQL workbench go to Users and Privileges and create the New User.

MySQL Workbench
Authentication Type: Standard

Click Apply and watch the Authentication Type change instead of keeping Standard

MySQL Workbench
Authentication Type: Standard

The Fix

After some reading up and trying to find how this can be fixed, I found that is very easy. On the MySQL Workbench, browse to Server and choose Options file

MySQL Workbench
Authentication Type: Standard

In the Option, File go to the Security Tab. Change the Default_Authentication_Plugin to mysql_native_password

MySQL Workbench
Authentication Type: Standard

Click apply and wait for the settings to update.

MySQL Workbench
Authentication Type: Standard

For the setting to Apply you need to restart the MySQL Service. Go to Server and choose Startup/Shutdown

MySQL Workbench
Authentication Type: Standard

On the new Screen Click Stop, give some time to go Down.

MySQL Workbench
Authentication Type: Standard

Then Click Start and Give some time to Come back up.

MySQL Workbench
Authentication Type: Standard

Recreate the use with Standard Authentication. Once you click apply the settings won’t change.

MySQL Workbench
Authentication Type: Standard

If you liked what you read Please Share.

I’d love it if you followed me on Twitter and Facebook.

Also, feel free to subscribe to my posts by email. Thanks for reading.

Spread the love

Leave a Reply

Your email address will not be published. Required fields are marked *