An Entrepreneur, Coach, IT Consultant, Strategic Adviser, and a Traveler craving to explore and contribute to forming a better society.

Tuesday, December 23, 2008

Reset MySQL Password

No comments :
Keyword: MySQL, Password, MySQL Password, Reset mySQL Password, Root Password, Forgot MySQL Password, MySQL Administration Password Reset

Forgot mySQL root Password? 

Just chill. Not in a bad situation, You're in right place to solve your problem. Let us see how to reset your mysql administration password.

I know the big question now is, "how to reset mysql password?"

Once I lost my MySQL root password, but was able to recover it in the following way.

1. Stop the mysqld daemon process. 
# service mysqld stop 
or  
# /etc/init.d/mysqld stop 
or 
# chkconfig mysqld off

2. Start the mysqld daemon process with the --skip-grant-tables option.
# mysqld --skip-grant-tables

3. Start the mysql client with the -u root option.
# mysql -u root

4. Execute the following SQL command to set a new password.
mysql> UPDATE mysql.user SET Password=PASSWORD('password') WHERE User='root';

5. Execute the following SQL command to refresh mySQL engine server.
# FLUSH PRIVILEGES;

Enjoy mySQL-ing.

Keyword: MySQL, Password, MySQL Password, Reset mySQL Password, Root Password, Forgot MySQL Password, MySQL Administration Password Reset

Featured Blog Topics:

No comments :