Recover MYSQL Password
Recover MYSQL Password
Q: My root password lost?; can’t manage existing database can anyone help me?
A: Solution is simple just follow the steps below:
Recover MYSQL Password
#/etc/init.d/mysql stop
Please wait until MySQL shuts down completely. Then run
#/usr/bin/mysqld_safe –skip-grant-tables –skip-networking &
then you will be able to login as root with no password.
#mysql -uroot mysql
In MySQL command line prompt issue the following command:
mysql>UPDATE user SET password=PASSWORD(”letmein”) WHERE user=”root”; FLUSH PRIVILEGES;
mysql>exit
kill all the mysql processes
#/etc/init.d/mysql stop
Start MySQL again
#/etc/init.d/mysql start
At this time your root password is reset to “letmein” and MySQL will now
know the privileges and you’ll be able to login with your new password:
mysql -uroot -pletmein mysql
Congratulations you have sucessfully changed your new password
A: Solution is simple just follow the steps below:
Recover MYSQL Password
#/etc/init.d/mysql stop
Please wait until MySQL shuts down completely. Then run
#/usr/bin/mysqld_safe –skip-grant-tables –skip-networking &
then you will be able to login as root with no password.
#mysql -uroot mysql
In MySQL command line prompt issue the following command:
mysql>UPDATE user SET password=PASSWORD(”letmein”) WHERE user=”root”; FLUSH PRIVILEGES;
mysql>exit
kill all the mysql processes
#/etc/init.d/mysql stop
Start MySQL again
#/etc/init.d/mysql start
At this time your root password is reset to “letmein” and MySQL will now
know the privileges and you’ll be able to login with your new password:
mysql -uroot -pletmein mysql
Congratulations you have sucessfully changed your new password
Bala- Admin
- Number of posts: 22
Registration date: 2007-12-17

Permissions of this forum:
You cannot reply to topics in this forum











» Squid http_port 8080
» rm and tar commands are slow
» Problems in sending and receiving of email....
» unable to login Yahoo Messenger
» How to monitor RSH commands
» windows system32 config system is corrupt in Windows Server
» how to grant a normal user the root right?
» Training Materials