Created
October 15, 2016 16:27
-
-
Save rifki/d7df31ac0474c798f9b9fda50d67e05b to your computer and use it in GitHub Desktop.
how to reset root password mysql server > 5.7.6
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
1. Stop mysql: | |
$ sudo service mysql stop | |
2. Step 2: Kill all running mysqld | |
$ sudo killall -9 mysqld | |
3. Step 3: Starting mysqld in Safe mode. | |
$ sudo mysqld_safe --skip-grant-tables --skip-networking & | |
4. Login as root | |
$ mysql -u root | |
5. Update the root user password with these mysql commands | |
mysql> UPDATE mysql.user SET authentication_string = PASSWORD('MyNewPassword') WHERE User = 'root' AND Host = 'localhost'; | |
mysql> FLUSH PRIVILEGES; | |
mysql> quit | |
6. Make sure!: Kill all running mysqld | |
$ sudo killall -9 mysqld | |
7. Start mysql normally: | |
sudo service mysql start | |
Try to login using your new password: | |
8. mysql -u root -p |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment