Change mysql root password

We can change the mysql root password from the WHM by using the steps provided at WHM DOCS but if server is not having control panel or not having WHM access then refer to the following steps to reset the mysql root password.

First make sure that mysql service is stop

/etc/init.d/mysql stop

Now run the following command from the shell.

 /usr/bin/safe_mysqld –skip-grant-tables

If the above command runs successfully then refer to the following command.

/usr/bin/mysqld_safe –skip-grant-tables &

mysql -u rootmysql> use mysql;

mysql> update user set Password = PASSWORD(‘supp0rt123′) where User=’root’;
mysql> exit

Now restart the mysql service

 /etc/init.d/mysqld stop 
/etc/init.d/mysqld start

 

Senior technical writer

Be Sociable, Share!
About Anant 364 Articles
Senior technical writer

1 Trackbacks & Pingbacks

  1. log in to MySql server without password – KTCHost

Comments are closed.