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>
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