Skip to content

Instantly share code, notes, and snippets.

@rummik

rummik/clear-root-password.sql

Created November 9, 2016 16:23
Show Gist options
  • Save rummik/edfc7491648f51a4166ecf9ab1a0835e to your computer and use it in GitHub Desktop.
Save rummik/edfc7491648f51a4166ecf9ab1a0835e to your computer and use it in GitHub Desktop.
Download ZIP
Enable empty password login for non-root system users for MySQL root user
Raw
clear-root-password.sql
use mysql;
update user set authentication_string=password(''), plugin='mysql_native_password' where user='root';
flush privileges;
exit;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment