Error adding user to database

Jo Travers

• November 30, 2016 06:25

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

  • November 30, 2016 20:22

  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!

  0
• 

  Sterlingz

  • December 24, 2016 17:46

  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.

  0
• 

  cPanelMichael

  • December 27, 2016 13:15

  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!

  0

Please sign in to leave a comment.