Reset mysql database root password

1. stop mysql server

$ /etc/init.d/mysql stop

if it doesn’t work then kill the process

$ ps aux | grep mysql

now you got the mysql pid, then kill it

$ kill -9 <pid>


2. run mysql server safe mode with option –skip-grant-tables

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

3. login to your mysql server using user root

$ /usr/bin/mysql -u root

4. change the root password

mysql> UPDATE user SET Password=PASSWORD('YOUR_PASSWORD') WHERE Host='localhost' AND User='root';

5. restart mysql server

$ /etc/init.d/mysql restart

Advertisement