Follow the below steps to recover MYSQL's roots password in Linux
Type the following commands at linux prompt
1. Type /etc/init.d/mysql stop
2. /usr/bin/killall mysqld
3. mysqld --skip-grant-tables -u root &
4. mysql
5. mysql> use mysql;
6. mysql> UPDATE user
7. -> SET password=password("putyourpasswordhere")
8. -> WHERE user="root";
9. mysql> flush privileges;
10. mysql> exit
11. /etc/init.d/mysql start
No comments:
Post a Comment