Error adding user to database

Jo Travers

Registered
Nov 30, 2016
1
0
1
Preston
cPanel Access Level
Root Administrator
When try to add a user to a mysql database I get the following error:

There was a problem adding the user: (XID gczus2) Database Error: Can't find any matching row in the user table

Any ideas?
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,884
2,243
463
Hello @Jo Travers,

Check to see if skip-name-resolve is enabled in your /etc/my.cnf file on this system. If so, disable or remove the entry, and then restart MySQL via the "/scripts/restartsrv_mysql" command. cPanel isn't designed or tested with the skip-name-resolve option in the /etc/my.cnf , and it can break certain functionality.

Thanks!
 
  • Like
Reactions: rakeshyeole

Sterlingz

Registered
Dec 24, 2016
1
0
1
Canada
cPanel Access Level
Root Administrator
Hello @Jo Travers,

Check to see if skip-name-resolve is enabled in your /etc/my.cnf file on this system. If so, disable or remove the entry, and then restart MySQL via the "/scripts/restartsrv_mysql" command. cPanel isn't designed or tested with the skip-name-resolve option in the /etc/my.cnf , and it can break certain functionality.

Thanks!
OP did you try this?

Having the same problem.

And there's no my.cnf file in that folder for me.

I'm a total noob mind you.
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,884
2,243
463
And there's no my.cnf file in that folder for me.
Hello,

Check to ensure you are logged in as "root" via SSH. It's the root /etc directory, as opposed to /home/$username/etc.

Thanks!