Monday 12 May 2014

Resetting MySQL Root Password: Red Hat and CentOS

If u have forgot mysql password in centos or redhat , how to change password steps given below..

Stop MySQL:
root#  service mysqld stop

Start MySQL in safe mode:
root#  mysqld_safe  --skip-grant-tables &

Log into MySQL as root:
root#  mysql -u root

Reset the password:
mysql>  update mysql.user set password=PASSWORD("your new password") where User='root';

mysql>  flush privileges; exit;

Log out of MySQL and stop the Safe Mode:
root#  service mysqld stop

Start MySQL in the normal mode:
root#  service mysqld start

Log into MySQL with your new password:
root#  mysql -u root -p
Enter password:
mysql>

No comments:

Post a Comment