The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

[Case 73085] There is no such grant defined for user 'example' on host 'example'

Discussion in 'Database Discussions' started by GasMan320, Aug 3, 2013.

  1. GasMan320

    GasMan320 Member

    Joined:
    Oct 2, 2012
    Messages:
    7
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    Hi everyone,

    I recently made a full cPanel backup from a shared hosting account I had at Hostgator and moved it over to my friend's dedicated server. I did a cPanel restore via WHM and everything seems to be working ok but when I do a full cPanel backup on the new box, I get a long line of errors referencing hosts at the old Hostgator box as well as hosts at the hosting that I had before Hostgator (Eleven2 Hosting). There is also a couple of the errors at the very bottom referencing the now currently hosted location.

    Any idea on how I can fix this?

    Here are some of the errors:

    PHP:
    Determining mysql dbs...DBD::mysql::st execute failedThere is no such grant defined for user 'rsa550' on host 'gator170.hostgator.com' at /usr/local/cpanel/Cpanel/Mysql.pm line 537.
    DBD
    ::mysql::st execute failedThere is no such grant defined for user 'rsa550_dev' on host 'gator170.hostgator.com' at /usr/local/cpanel/Cpanel/Mysql.pm line 537.
    DBD
    ::mysql::st execute failedThere is no such grant defined for user 'rsa550_rsa5501' on host 'gator170.hostgator.com' at /usr/local/cpanel/Cpanel/Mysql.pm line 537.
    DBD
    ::mysql::st execute failedThere is no such grant defined for user 'rsa550_wrdp1' on host 'gator170.hostgator.com' at /usr/local/cpanel/Cpanel/Mysql.pm line 537.
    DBD
    ::mysql::st execute failedThere is no such grant defined for user 'rsa550' on host 'gator3167.hostgator.com' at /usr/local/cpanel/Cpanel/Mysql.pm line 537.
    DBD
    ::mysql::st execute failedThere is no such grant defined for user 'rsa550_dev' on host 'gator3167.hostgator.com' at /usr/local/cpanel/Cpanel/Mysql.pm line 537.
    DBD
    ::mysql::st execute failedThere is no such grant defined for user 'rsa550_rsa5501' on host 'gator3167.hostgator.com' at /usr/local/cpanel/Cpanel/Mysql.pm line 537.
    DBD
    ::mysql::st execute failedThere is no such grant defined for user 'rsa550_wrdp1' on host 'gator3167.hostgator.com' at /usr/local/cpanel/Cpanel/Mysql.pm line 537.
    DBD
    ::mysql::st execute failedThere is no such grant defined for user 'rsa550' on host 'lima.unisonpaltform.com' at /usr/local/cpanel/Cpanel/Mysql.pm line 537.
    DBD
    ::mysql::st execute failedThere is no such grant defined for user 'rsa550_dev' on host 'lima.unisonpaltform.com' at /usr/local/cpanel/Cpanel/Mysql.pm line 537.
    DBD
    ::mysql::st execute failedThere is no such grant defined for user 'rsa550_rsa5501' on host 'lima.unisonpaltform.com' at /usr/local/cpanel/Cpanel/Mysql.pm line 537.
    DBD
    ::mysql::st execute failedThere is no such grant defined for user 'rsa550_wrdp1' on host 'lima.unisonpaltform.com' at /usr/local/cpanel/Cpanel/Mysql.pm line 537.
    DBD
    ::mysql::st execute failedThere is no such grant defined for user 'rsa550' on host 'web6.forumediainc.com' at /usr/local/cpanel/Cpanel/Mysql.pm line 537.
    DBD
    ::mysql::st execute failedThere is no such grant defined for user 'rsa550_dev' on host 'web6.forumediainc.com' at /usr/local/cpanel/Cpanel/Mysql.pm line 537.
    DBD
    ::mysql::st execute failedThere is no such grant defined for user 'rsa550_rsa5501' on host 'web6.forumediainc.com' at /usr/local/cpanel/Cpanel/Mysql.pm line 537.
    DBD
    ::mysql::st execute failedThere is no such grant defined for user 'rsa550_wrdp1' on host 'web6.forumediainc.com' at /usr/local/cpanel/Cpanel/Mysql.pm line 537.
     
  2. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,854
    Likes Received:
    676
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    Hello :)

    Please look for the following line in the /etc/my.cnf file on the destination server:

    Code:
    skip-name-resolve
    This entry has been known to cause the warning messages you have posted when restoring databases. Could you let us know if this line is active?

    Thank you.
     
  3. GasMan320

    GasMan320 Member

    Joined:
    Oct 2, 2012
    Messages:
    7
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    Hi Michael,

    Thanks for the response.

    I searched for that in my /etc/my.cnf file and did find it as shown below:

    PHP:
    # SAFETY #
    max_allowed_packet             16M
    max_connect_errors             
    1000000
    skip_name_resolve
    innodb                         
    FORCE
    Should I remove this line from the config file? Also, do I need to manually edit out my old hosting companies servers out of somewhere? Why are they even showing up?

    Thank you.
     
  4. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,854
    Likes Received:
    676
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    The warning messages you see can appear when "skip-name-resolve" is configured in the /etc/my.cnf file. The backup system attempts lookups that cannot be complete, generating noise in the log. There is an internal case open to address this issue. For reference, the case number is 73085. You should be able to safely ignore these warnings without negative consequences until a resolution is pushed out.

    Thank you.
     
Loading...

Share This Page