MySQL config error
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 tableThis 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:
[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: 39781 Does anyone have a suggestion on how I can fix this?
-
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. 0 -
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.
This solved my problem! Thank you!0 -
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. 0 -
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.
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.0 -
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.
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.0 -
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.
This change must be done with root access. You need to contact your hosting provider.0 -
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.
Can you help me with a tutorial please? I need to do so, too. But I'm new in this thing.0 -
Can you help me with a tutorial please? I need to do so, too. But I'm new in this thing.
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.0 -
Can you help me with a tutorial please? I need to do so, too. But I'm new in this thing.
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.0 -
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.
It looks like i have ssh access, then, can you help me please?0 -
It looks like i have ssh access, then, can you help me please?
Do you have "root" access to the system? For instance, are you able to access WHM and SSH with the "root" username? Thank you.0
Please sign in to leave a comment.
Comments
11 comments