sebasjimenez10/reset_mysql_root_pwd.md

Last active October 14, 2016 14:27

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/sebasjimenez10/0a7e770db7a7b78343332a63d83e7056.js"></script>
Save sebasjimenez10/0a7e770db7a7b78343332a63d83e7056 to your computer and use it in GitHub Desktop.

Download ZIP

Resting MySQL Root Password

Raw

reset_mysql_root_pwd.md

Resetting MySQL root user password on Mac ( OSX El Capitan 10.11.x )

System Preferences > MySQL > Stop MySQL Server
From a terminal: sudo /usr/local/mysql/bin/mysqld_safe --skip-grant-tables
From a new terminal: sudo /usr/local/mysql/bin/mysql -u root
From mysql> FLUSH PRIVILEGES;
From mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'NEWPASSOWORD';
From mysql> \q
Stop server
Start server
Test connection with new password: mysql -u root -p
Type new password
Bingo!

Alternatives to some steps

and 7. sudo /usr/local/mysql/support-files/mysql.server stop
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