Mayur's BLOG

Hello,

1. Log on to your dedicated server via SSH with your root username

2. Stop the MySQL process with the following command:


/etc/init.d/mysqld stop


3. Restart it without the user information:


/usr/bin/safe_mysqld --skip-grant-tables &


Now you should be able to log in without the root password:


4. mysql -u root


5. While you are at the mysql> prompt enter:


UPDATE mysql.user SET Password=PASSWORD('newpwd') WHERE User='admin'; (remember to include the ';' and that newpwd should be the admin password)

and then

6. FLUSH PRIVILEGES;