Skip to content

Instantly share code, notes, and snippets.

Last active May 12, 2020
What would you like to do?
Change MySQL 5.7 Password and Server authentication plugin for root user
SELECT user,authentication_string,plugin,host FROM mysql.user;
UPDATE mysql.user SET plugin = 'mysql_native_password', authentication_string = PASSWORD('mypassword') WHERE User = 'root';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment