Skip to content

Instantly share code, notes, and snippets.

@iolloyd

iolloyd/reset_mysql_root_password.md

Created June 21, 2016 14:00
Show Gist options
  • Save iolloyd/151065ec0a5bb37e1ce98c60c0185f44 to your computer and use it in GitHub Desktop.
Save iolloyd/151065ec0a5bb37e1ce98c60c0185f44 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
reset_mysql_root_password.md 
sudo /usr/local/mysql/support-files/mysql.server stop

sudo mysqld_safe --skip-grant-tables

mysql -u root

UPDATE mysql.user SET Password=PASSWORD('password') WHERE User='root';

FLUSH PRIVILEGES;

sudo /usr/local/mysql/support-files/mysql.server start
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment