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 WorkbenchAuthentication Type: Standard

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

MySQL WorkbenchAuthentication 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 WorkbenchAuthentication Type: Standard

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

MySQL WorkbenchAuthentication Type: Standard

Click apply and wait for the settings to update.

MySQL WorkbenchAuthentication Type: Standard

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

MySQL WorkbenchAuthentication Type: Standard

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

MySQL WorkbenchAuthentication Type: Standard

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

MySQL WorkbenchAuthentication Type: Standard

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

MySQL WorkbenchAuthentication Type: Standard

********************************************************

If you liked what you read Please Share.
I’d love it if you followed me on YouTube and Facebook.

Also, feel free to subscribe to my posts by email.
Donations for the site can be made here.

Thanks for reading.
Spread the love

Leave a Reply

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