gobinathm/mysql_password_retrival.md

Created March 9, 2017 00:48

Star (0) You must be signed in to star a gist
Fork (0) You must be signed in to fork a gist

Select an option

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/gobinathm/75be9cdcf775eed562f3f75355508ab4.js"></script>
Save gobinathm/75be9cdcf775eed562f3f75355508ab4 to your computer and use it in GitHub Desktop.

Download ZIP

Retrive Lost MySql Root Password in Mac / Linux

Raw

mysql_password_retrival.md

Stop MySQL:

sudo /usr/local/mysql/support-files/mysql.server stop

Next Step would be to start it in safe mode:

sudo mysqld_safe --skip-grant-tables

Execute the following commands in order

mysql -u root
FLUSH PRIVILEGES;
ALTER USER 'root'@'localhost' IDENTIFIED BY 'MyNewPass';. Please ensure you change MyNewPass to what ever you want.
Now exit mysql prompt

Start MySQL

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment