Recovering MySQL root Password
You can recover MySQL database server password with following steps:
1. Stop the MySQL server process /etc/init.d/mysqld stop
2. Start the MySQL (mysqld) server/daemon process with the –skip-grant-tables option so that it will not prompt for password mysqld_safe –skip-grant-tables &
3. Connect to mysql server as the root user mysql -u root
4. Setup new mysql root account password i.e. reset mysql password
mysql> use mysql;
mysql> update user set password=PASSWORD(“XXXXXX”) where User=’root’;
mysql> flush privileges;
mysql> quit
5. Exit and restart the MySQL server /etc/init.d/mysqld restart
Leave a Reply