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