Difference between revisions of "mysql server root password recovery"

From thelinuxwiki
Jump to: navigation, search
(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...")

Revision as of 22:11, 24 May 2016

  1. Stop MySQL 
# sudo /etc/init.d/mysqld stop
  1. start mysql in Safe mode 


# mysqld_safe --skip-grant-tables &
  1. Login as root 
# mysql -uroot
  1. Reset Password 
# use mysql;
mysql> update user set password=PASSWORD("mynewpassword") where User='root';
mysql> flush privileges;
mysql> quit
  1. Restart 
# killall mysqld
# /etc/init.d/mysqld start
Retrieved from "http://www.thelinuxwiki.com/index.php?title=mysql_server_root_password_recovery&oldid=999"