Wednesday, February 20, 2008
Forgot mySQL root Password?
LAMP
,
Linux
,
mySQL
,
Password
No comments
:
I request you all to please Click Here to help the poor people.Keyword: MySQL, Password, Forgot mySQL Password, Root Password
Just chill. Not in a bad situation, You're in right place to solve your problem.
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, Forgot mySQL Password, Root Password
I request you all to please Click Here to help the poor people.
I request you all to please Click Here to help the poor people.
Subscribe to:
Post Comments
(
Atom
)
No comments :
Post a Comment