Sponsorship

40% off your First Order with GoDaddy.com!

Dec 30, 2009

MySQL: MySQL Password Reset


Problem

Are you looking at this page because you cannot access the mysql server installed on your pc/server when you were trying to see if it works well? Or do you receive error messages like the following?
ERROR 1045: Access denied for user: 'root@localhost' (Using password: YES)

To resolve this problem ,a fast and always working way is the "Password Resetting".

Solution

Following this procedure, you will disable access control on the MySQL server. All connexions will have a root access. It is a good thing to unplug your server from the network or at least disable remote access.

To reset your mysqld password just follow these instructions :

Stop the mysql demon process using this command:
sudo /etc/init.d/mysql stop

Start the mysqld demon process using the --skip-grant-tables option with this command:
sudo /usr/sbin/mysqld --skip-grant-tables --skip-networking &

start the mysql client process using this command:
mysql -u root

from the mysql prompt execute this command to reset/update your password:
SET PASSWORD FOR root@'localhost' = PASSWORD('password');

No comments:

Post a Comment