mysqldump: Got error: 1045: Access denied for user

[Nirjonadda]

Please let me know that how to fix mysqldump: Got error: 1045: Access denied for user?

[30-Aug-2017 02:02:00] WARNING: [pool mysite_com] child 13234 said into stderr: "mysqldump: Got error: 1045: Access denied for user 'user'@'localhost' (using password: YES) when trying to connect"

 

[Eminds]

you must be logged in with the root user to the server in order to create mysqldump. while backing up the data use -u root -p mysql password root password and then check.

 

[Nirjonadda]

you must be logged in with the root user to the server in order to create mysqldump. while backing up the data use -u root -p mysql password root password and then check.

I am using one addon for xenforo ForumBackup. It appears the user connecting to my xenforo database doesn'f have authority to use the mysqldump command? mysql password is root password have set up in“.my.cnf” in home directory. Please let me know that how we can fix this problem?

 

[cPanelMichael]

Hello,

Are you able to verify the correct database username and database name is utilized by your script's plugin when attempting to backup the database? Also, try accessing SSH as the account username and running the following command to verify it works as expected:

mysqldump -u username -p database_name > /home/$username/db_backup.sql

Thank you.

 

[Nirjonadda]

Hello,

Are you able to verify the correct database username and database name is utilized by your script's plugin when attempting to backup the database? Also, try accessing SSH as the account username and running the following command to verify it works as expected:

mysqldump -u username -p database_name > /home/$username/db_backup.sql

Thank you.

No, plugin does not have any option to enter database username and database name. Its just work from Xenforo Database. This issue happened from new server. Yes following command are working but with this command where the database files are save?

 

[cPanelMichael]

Yes following command are working but with this command where the database files are save?

The backup files are located at "/home/$username/db_backup.sql" in this example. As far as the plugin, could you report the issue to the plugin developer to see how the MySQL backup is generated in the code?

Thank you.

 

[Nirjonadda]

The backup files are located at "/home/$username/db_backup.sql" in this example. As far as the plugin, could you report the issue to the plugin developer to see how the MySQL backup is generated in the code?

Thank you.

I think Its happened from after using php-fpm.

 

[cPanelMichael]

I think Its happened from after using php-fpm.

Do you notice any specific output in /opt/cpanel/ea-php$$/root/usr/var/log/php-fpm/error.log when this happens? Replace "ea-php$$" with the version of PHP associated with the account (e.g. ea-php56).

Thank you.

 

[Nirjonadda]

Do you notice any specific output in /opt/cpanel/ea-php$$/root/usr/var/log/php-fpm/error.log when this happens? Replace "ea-php$$" with the version of PHP associated with the account (e.g. ea-php56).

Thank you.

/opt/cpanel/ea-php71/root/usr/var/log/php-fpm/error.log

[07-Sep-2017 02:01:06] WARNING: [pool mysite_com] child 23116 said into stderr: "mysqldump: Got error: 1045: Access denied for user 'nadda'@'localhost' (using password: YES) when trying to connect"

 

[cPanelMichael]

Hello,

Can you verify that no additional entries appear in that log file before or after that error message near the same time stamp?

Thank you.

 

[Nirjonadda]

Hello,

Can you verify that no additional entries appear in that log file before or after that error message near the same time stamp?

Thank you.

Before or After, No error logged in same time.

 

[cPanelMichael]

Feel free to open a support ticket using the link in my signature if you'd like us to take a closer look.

Thank you.

 

[Nirjonadda]

Feel free to open a support ticket using the link in my signature if you'd like us to take a closer look.

Thank you.

Support Request ID is: 8852133

 

[cPanelMichael]

Hello,

To update, it looks like this stemmed from the use of a my.cnf file in the account's home directory with a password that did not match the cPanel account's password.

Thank you.