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

[GasMan320]

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:

Determining mysql dbs...DBD::mysql::st execute failed: There 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 failed: There 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 failed: There 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 failed: There 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 failed: There 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 failed: There 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 failed: There 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 failed: There 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 failed: There 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 failed: There 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 failed: There 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 failed: There 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 failed: There 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 failed: There 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 failed: There 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 failed: There is no such grant defined for user 'rsa550_wrdp1' on host 'web6.forumediainc.com' at /usr/local/cpanel/Cpanel/Mysql.pm line 537.

 

[cPanelMichael]

Hello

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

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.

 

[GasMan320]

Hi Michael,

Thanks for the response.

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

# 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.

 

[cPanelMichael]

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.