Reset MySQL root pwd

Resetting MySQL Root Password: Red Hat and CentOS

If you’ve forgotten your MySQL root password (or are involved with some nefarious activity), here is how you can reset that password on a Red Hat (RHEL) system or a CentOS system:

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(“YourNewPassW0RD”) 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>
0 views0 comments

Recent Posts

See All

Use mysqladmin command to change root password

If you have never set a root password for MySQL server, the server does not require a password at all for connecting as root. To setup root password for first time, use mysqladmin command at shell pro

Common MySQL Commands

Common Useful MySQL Commands Applicable to Centos Versions: Centos 5.x Centos 6.x Requirements Explanation of requirements. MySQL and MySQL-server installed on a Centos 5.x system DBA access rights to

Common MySQL Commands

Common Useful MySQL Commands Applicable to Centos Versions: Centos 5.x Centos 6.x Requirements Explanation of requirements. MySQL and MySQL-server installed on a Centos 5.x system DBA access rights to