Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

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.

MySQL config error

Discussion in 'Database Discussions' started by Rodrigo Gomes, Aug 16, 2016.

Tags:
  1. Rodrigo Gomes

    Rodrigo Gomes Well-Known Member

    Joined:
    Apr 6, 2016
    Messages:
    88
    Likes Received:
    21
    Trophy Points:
    8
    Location:
    Brazil
    cPanel Access Level:
    Root Administrator
    Code:
    Error from MySQL query: (XID nbn6sk) Database Error: Can't find any matching row in the user table
    The system could not execute the instructions “GRANT” of user "test123" due to an error: (XID nbn6sk) Database Error: Can't find any matching row in the user table
    This error occurs in several different locations in the cpanel and makes impossible to restore full backups.

    Some places when this error occurs:
    Website Software
    Backup Wizard (during restoration)

    This error disappears when I remove my custom settings in my.cnf:

    Code:
    [mysqld]
    performance-schema=0
    default-storage-engine=MyISAM
    innodb_file_per_table=1
    max_allowed_packet=268435456
    #open_files_limit=10000
    local-infile=0
    
    #
    # CUSTOM
    #
    
    max_connections=250
    wait_timeout=28800
    interactive_timeout=28800
    
    skip-name-resolve
    myisam_use_mmap=1
    
    query_cache_type = 1
    query_cache_size=512M
    query_cache_limit=8M
    
    join_buffer_size=32M
    read_rnd_buffer_size=6M
    max_allowed_packet = 10M
    
    tmp_table_size=256M
    max_heap_table_size=256M
    
    table_open_cache = 9000
    thread_cache_size = 70
    
    open_files_limit=50000
    
    key_buffer_size = 2G
    myisam_sort_buffer_size = 256M
    
    innodb_file_per_table=1
    innodb_buffer_pool_size = 3G
    innodb_log_file_size = 124M
    innodb_log_buffer_size = 9M
    innodb_buffer_pool_instances = 3
    
    # Debug
    #slow_query_log=1
    #slow_query_log_file="/var/log/mysql.slow-queries.log"
    
    But this setting is important for caching the database and relieve the CPU:

    mysql_queries-week.png

    Does anyone have a suggestion on how I can fix this?
     
  2. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    38,165
    Likes Received:
    1,370
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Hello,

    Could you check to see if the issue persists after removing "skip-name-resolve" from your /etc/my.cnf file and restarting MySQL?

    Thank you.
     
  3. Rodrigo Gomes

    Rodrigo Gomes Well-Known Member

    Joined:
    Apr 6, 2016
    Messages:
    88
    Likes Received:
    21
    Trophy Points:
    8
    Location:
    Brazil
    cPanel Access Level:
    Root Administrator
    This solved my problem!
    Thank you!
     
    axita shah likes this.
  4. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    38,165
    Likes Received:
    1,370
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    I'm happy to see the issue is now resolved. Note that cPanel isn't designed or tested with the skip-name-resolve option in the /etc/my.cnf file, so enabling this option might break certain functionality.

    Thank you.
     
    Rodrigo Gomes likes this.
  5. ferdeenand

    ferdeenand Registered

    Joined:
    Jul 28, 2017
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    mexico
    cPanel Access Level:
    Website Owner

    Where can I find this? I'm the owner of the site with no webmaster so I have to solve this by my own. I get the same error when trying to connect a user to a database.
     
  6. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    38,165
    Likes Received:
    1,370
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Hello,

    You will need to report this issue to your web hosting provider so they can check for that setting. It's not possible to view that file without root access to the server. The following document is helpful if you need to identify your web hosting provider:

    How to Identify Your Hosting Provider - cPanel Knowledge Base - cPanel Documentation

    Thank you.
     
  7. Rodrigo Gomes

    Rodrigo Gomes Well-Known Member

    Joined:
    Apr 6, 2016
    Messages:
    88
    Likes Received:
    21
    Trophy Points:
    8
    Location:
    Brazil
    cPanel Access Level:
    Root Administrator
    This change must be done with root access. You need to contact your hosting provider.
     
  8. ferdeenand

    ferdeenand Registered

    Joined:
    Jul 28, 2017
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    mexico
    cPanel Access Level:
    Website Owner
    Can you help me with a tutorial please? I need to do so, too. But I'm new in this thing.
     
  9. Rodrigo Gomes

    Rodrigo Gomes Well-Known Member

    Joined:
    Apr 6, 2016
    Messages:
    88
    Likes Received:
    21
    Trophy Points:
    8
    Location:
    Brazil
    cPanel Access Level:
    Root Administrator
    Even if there is a tutorial, if you do not have root access from the server, you will not be able to make this change.
     
    cPanelMichael likes this.
  10. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    38,165
    Likes Received:
    1,370
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    You will need to contact your web hosting provider for help making this change, as it's not possible to access that file via SSH without root access to the server.

    Thank you.
     
  11. ferdeenand

    ferdeenand Registered

    Joined:
    Jul 28, 2017
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    mexico
    cPanel Access Level:
    Website Owner

    It looks like i have ssh access, then, can you help me please?
     
  12. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    38,165
    Likes Received:
    1,370
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Do you have "root" access to the system? For instance, are you able to access WHM and SSH with the "root" username?

    Thank you.
     
Loading...

Share This Page