How To: MySQL Error "Access denied for user..."

[lnxcode]

Are you getting ?

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

How do you fix the above?

From SSH, you will do the below commands:

• service chkservd stop
• service mysql stop
• vi /mysql.recover

• #add the following line to /mysql.recover and change MyNewPassword to the password that you want

• SET PASSWORD FOR 'root'@'localhost' = PASSWORD('MyNewPassword');
• chmod 777 /mysql.recover
• mysqld_safe --init-file=/mysql.recover &
• service mysql stop
• rm -fv /mysql.recover
• service mysql start
• service chkservd start
• the root pass is in /root/.my.cnf

You should be all set!

[baghdad4ever]

thanks denis

i counter this before one month

but HIC fix it to me

[jcarvin]

Originally Posted by lnxcode

Are you getting ?

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

How do you fix the above?

From SSH, you will do the below commands:

• service chkservd stop
• service mysql stop
• vi /mysql.recover

• #add the following line to /mysql.recover and change MyNewPassword to the password that you want

• SET PASSWORD FOR 'root'@'localhost' = PASSWORD('MyNewPassword');
• chmod 777 /mysql.recover
• mysqld_safe --init-file=/mysql.recover &
• service mysql stop
• rm -fv /mysql.recover
• service mysql start
• service chkservd start
• the root pass is in /root/.my.cnf

You should be all set!

I am not getting a ERROR 1045 (28000):
but I am getting Access denied for user 'root'@'localhost' (using password: YES)

I tried to set up a drupal site. I created the DB, uploaded the files for the site I had been working on from my local server, then imported my DB to the DB I created, through cPanel.

Unfortunately, I cannot remember my password. I thought I had it right. And I've tried a bunch of combinations to no avail. I suppose I could just delete the whole thing and recreate a db, but had this been a site that had been in use and then I had to upgrade drupal and I forgot my password, I would want to reset the password instead of deleting and reuploading the whole site and DB.

I'm not a geek. I don't understand what SSH is or how to access it, or whether that is how to solve my problem. Please help. I'm locked out!

[lnxcode]

Originally Posted by jcarvin

I am not getting a ERROR 1045 (28000):
but I am getting Access denied for user 'root'@'localhost' (using password: YES)

I tried to set up a drupal site. I created the DB, uploaded the files for the site I had been working on from my local server, then imported my DB to the DB I created, through cPanel.

Unfortunately, I cannot remember my password. I thought I had it right. And I've tried a bunch of combinations to no avail. I suppose I could just delete the whole thing and recreate a db, but had this been a site that had been in use and then I had to upgrade drupal and I forgot my password, I would want to reset the password instead of deleting and reuploading the whole site and DB.

I'm not a geek. I don't understand what SSH is or how to access it, or whether that is how to solve my problem. Please help. I'm locked out!

If you setup the database via cPanel - just remove the username that is assigned to the database and reset the password and username (by reapplying it).

You should be all set after that.