Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

mysqldump: Got error: 1045: Access denied for user

Discussion in 'EasyApache' started by Nirjonadda, Aug 30, 2017.

  1. Nirjonadda

    Nirjonadda Well-Known Member

    Joined:
    May 8, 2013
    Messages:
    599
    Likes Received:
    15
    Trophy Points:
    68
    cPanel Access Level:
    Root Administrator
    Please let me know that how to fix mysqldump: Got error: 1045: Access denied for user?

    Code:
    [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"
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #1 Nirjonadda, Aug 30, 2017
  2. Eminds

    Eminds Well-Known Member

    Joined:
    Nov 10, 2016
    Messages:
    267
    Likes Received:
    20
    Trophy Points:
    18
    Location:
    India
    cPanel Access Level:
    Root Administrator
    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.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #2 Eminds, Aug 30, 2017
  3. Nirjonadda

    Nirjonadda Well-Known Member

    Joined:
    May 8, 2013
    Messages:
    599
    Likes Received:
    15
    Trophy Points:
    68
    cPanel Access Level:
    Root Administrator
    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?
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #3 Nirjonadda, Aug 30, 2017
  4. cPanelMichael

    cPanelMichael Technical Support Community Manager
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    44,749
    Likes Received:
    1,884
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    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:

    Code:
    mysqldump -u username -p database_name > /home/$username/db_backup.sql
    Thank you.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #4 cPanelMichael, Aug 31, 2017
  5. Nirjonadda

    Nirjonadda Well-Known Member

    Joined:
    May 8, 2013
    Messages:
    599
    Likes Received:
    15
    Trophy Points:
    68
    cPanel Access Level:
    Root Administrator
    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?
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #5 Nirjonadda, Aug 31, 2017
  6. cPanelMichael

    cPanelMichael Technical Support Community Manager
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    44,749
    Likes Received:
    1,884
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    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.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #6 cPanelMichael, Sep 5, 2017
  7. Nirjonadda

    Nirjonadda Well-Known Member

    Joined:
    May 8, 2013
    Messages:
    599
    Likes Received:
    15
    Trophy Points:
    68
    cPanel Access Level:
    Root Administrator
    I think Its happened from after using php-fpm.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #7 Nirjonadda, Sep 6, 2017
  8. cPanelMichael

    cPanelMichael Technical Support Community Manager
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    44,749
    Likes Received:
    1,884
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    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.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #8 cPanelMichael, Sep 7, 2017
  9. Nirjonadda

    Nirjonadda Well-Known Member

    Joined:
    May 8, 2013
    Messages:
    599
    Likes Received:
    15
    Trophy Points:
    68
    cPanel Access Level:
    Root Administrator
    /opt/cpanel/ea-php71/root/usr/var/log/php-fpm/error.log

    Code:
    [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"
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #9 Nirjonadda, Sep 7, 2017
  10. cPanelMichael

    cPanelMichael Technical Support Community Manager
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    44,749
    Likes Received:
    1,884
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    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.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #10 cPanelMichael, Sep 7, 2017
  11. Nirjonadda

    Nirjonadda Well-Known Member

    Joined:
    May 8, 2013
    Messages:
    599
    Likes Received:
    15
    Trophy Points:
    68
    cPanel Access Level:
    Root Administrator
    Before or After, No error logged in same time.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #11 Nirjonadda, Sep 7, 2017
  12. cPanelMichael

    cPanelMichael Technical Support Community Manager
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    44,749
    Likes Received:
    1,884
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    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.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #12 cPanelMichael, Sep 7, 2017
  13. Nirjonadda

    Nirjonadda Well-Known Member

    Joined:
    May 8, 2013
    Messages:
    599
    Likes Received:
    15
    Trophy Points:
    68
    cPanel Access Level:
    Root Administrator
    Support Request ID is: 8852133
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #13 Nirjonadda, Sep 8, 2017
  14. cPanelMichael

    cPanelMichael Technical Support Community Manager
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    44,749
    Likes Received:
    1,884
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    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.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #14 cPanelMichael, Sep 11, 2017
(You must log in or sign up to post here.)
Loading...
Similar Threads - mysqldump error 1045
  1. LaLi

    mysqldump: [ERROR] unknown option '--skip-name-resolve'

    LaLi, Jul 28, 2018, in forum: Database Discussion
    Replies:
    2
    Views:
    135
    cPanelLauren
    Jul 30, 2018
  2. Bashy

    mysqldump: Got error: 130: Incorrect file format

    Bashy, Feb 27, 2018, in forum: General Discussion
    Replies:
    1
    Views:
    461
    cPanelMichael
    Feb 28, 2018
  3. Bdzzld

    Mysqldump failure during automatic backups (max_allowed_packet)

    Bdzzld, Sep 18, 2018 at 1:58 AM, in forum: Database Discussion
    Replies:
    3
    Views:
    33
    cPanelLauren
    Sep 18, 2018 at 1:34 PM
  4. janipewter

    Mysqldump failure on automatic backups

    janipewter, Sep 13, 2018, in forum: Database Discussion
    Replies:
    15
    Views:
    134
    cPanelLauren
    Sep 20, 2018 at 2:49 PM
  5. hamidkh

    How to change cPanel backup to use mysqldump -f instead?

    hamidkh, Feb 20, 2018, in forum: Database Discussion
    Replies:
    1
    Views:
    299
    cPanelMichael
    Feb 20, 2018

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Accept Learn More...
    Dismiss Notice