Difference between revisions of "mysql server root password recovery"
From thelinuxwiki
| Line 1: | Line 1: | ||
Stop MySQL | Stop MySQL | ||
| − | # sudo /etc/init.d/ | + | # sudo /etc/init.d/mysql stop |
start mysql in Safe mode | start mysql in Safe mode | ||
| Line 14: | Line 14: | ||
Reset Password | Reset Password | ||
| − | + | mysql> use mysql; | |
mysql> update user set password=PASSWORD("mynewpassword") where User='root'; | mysql> update user set password=PASSWORD("mynewpassword") where User='root'; | ||
mysql> flush privileges; | mysql> flush privileges; | ||
| Line 22: | Line 22: | ||
# killall mysqld | # killall mysqld | ||
| − | # /etc/init.d/ | + | # /etc/init.d/mysql start |
start and stop commands may vary depending on Linux distro | start and stop commands may vary depending on Linux distro | ||
[[category:mysql]] | [[category:mysql]] | ||
Latest revision as of 03:07, 12 July 2016
Stop MySQL
# sudo /etc/init.d/mysql stop
start mysql in Safe mode
# mysqld_safe --skip-grant-tables &
Login as root
# mysql -uroot
Reset Password
mysql> use mysql;
mysql> update user set password=PASSWORD("mynewpassword") where User='root';
mysql> flush privileges;
mysql> quit
Restart
# killall mysqld # /etc/init.d/mysql start
start and stop commands may vary depending on Linux distro
