So many passwords to remember that i sometimes tend to forgot my mysql database password. this simple steps will guide you on how you can recover your mysql root password.

Stop MySQl server:

• /etc/init.d/mysql stop

Then type the following in the terminal

• mysqld_safe –skip-grant-tables &
• mysql -u root mysql

You will be prompted with the standard mysql environment. and type this command to reset your mysql root password.

• update user set password=password(’123456′) where user=’root’;
• flush privileges;

Now your all set with your new mysql root password…

Related Post

• May 10, 2009 -- The future of MySQL (2)
• October 4, 2008 -- How-To: Optimize MySQL Database (0)
• August 19, 2008 -- How to export MySQL files to Excel file (0)
• August 17, 2008 -- Convert sql file to csv. (0)
• May 29, 2008 -- Securing the connection between MySQL and MySQL Administrator using an SSH tunnel (0)
• May 17, 2008 -- How To: Check and Repair MySQL Tables (0)