Skip to content

Instantly share code, notes, and snippets.

@marczhermo

marczhermo/mysql_reset.sql

Created May 2, 2021 12:33
Show Gist options
  • Save marczhermo/74ec27d17de0eb27ae349de0bcca1941 to your computer and use it in GitHub Desktop.
Save marczhermo/74ec27d17de0eb27ae349de0bcca1941 to your computer and use it in GitHub Desktop.
Download ZIP
Reset Root Password
Raw
mysql_reset.sql
use mysql;
update user set authentication_string=password(''), plugin='mysql_native_password' where user='root';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment