cpanel backups show There is no such grant defined for user

cpanel backups show There is no such grant defined for user

MySQL error in cpbackup:
Entering timeout safety mode
Determining mysql dbs…DBD::mysql::st execute failed: There is no such
grant defined for user ‘XXX’ on host ‘XXXX’ at
/usr/local/cpanel/Cpanel/Mysql.pm line 520.

This error is coming from ‘skip-name-resolv’ in /etc/my.cnf If you have remote mysql connections skip name resolve is faster because no dns lookup is done on the mysql connection, so we recommend leaving that on.

If you have no remote mysql connections then removing the skip name resolve will have no impact on connection speed. For additional security you want want skip-networking added so mysql does not listen on port 3306 and no remote connections are possible.

Source: From http://forums.cpanel.net/f5/pkgacct-no-such-grant-defined-user-cpanel-mysql-pm-line-515-a-247262.html

Regards,

John Quaglieri
InterServer Inc

Interserver
http://www.interserver.net

Have we provided you with the highest level of service? Like us on Facebook or write on our wall. www.facebook.com/interserver

Visit our new community forums at http://forum.interserver.net/forum/

  • 0

How to Block Bots using Robots.txt File?

How to Block Bots using Robots.txt File? The robots.txt file is a simple text file placed on...

PageSpeed on cPanel Server

PageSpeed on cPanel Server PageSpeed on cPanel Server PageSpeed (mod_pagespeed) is a module for...

How to change cPanel logout URL

How to change cPanel logout URL Do you know that it is possible to change cPanel logout URL any...

How to Change cPanel Style

How to Change cPanel Style How to Change cPanel Style cPanel is the most popular control panel...