tajidyakub/mysql-alter-authentication.md

Created April 26, 2020 10:50

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/tajidyakub/63b2c60b7a42479f9b357f731f758ac5.js"></script>
Save tajidyakub/63b2c60b7a42479f9b357f731f758ac5 to your computer and use it in GitHub Desktop.

Alter mysql 8 user authentication to native.

Raw

Mysql version 8 shipped with the latest version of major Linux distros could made some php application stop working, namely WordPress - need to research furthermore on the why.

Creating a user designated to be used by WordPress with using mysql_native_password authentication seems to solve this issue.

mysql> CREATE USER 'dbuser'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password';

Or alter the existing user.

mysql> ALTER

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment