Password Modification returns errors

[sahostking]

When using Password Modification in WHM I get the following errors returned. Any ideas?

Password Modification

The password for website has been changed.
Password for “website” has been changed.
Updating ftp passwords for website
Ftp password files updated.
Ftp vhost passwords synced
Error from MySQL query: DBD::mysql::db do failed: Can't find any matching row in the user table at /usr/local/cpanel/Cpanel/Mysql.pm line 1195.
Error from MySQL query: DBD::mysql::db do failed: Can't find any matching row in the user table at /usr/local/cpanel/Cpanel/Mysql.pm line 1195.
Error from MySQL query: DBD::mysql::db do failed: Can't find any matching row in the user table at /usr/local/cpanel/Cpanel/Mysql.pm line 1195.

 

[Sys Admin]

Have you tried to update cPanel by running /scripts/upcp --force ?

 

[sahostking]

Yes I have tried that before. I notice the only thing we changed was the my.cnf file. Can't see how that could cause it. Here it is below:
---------------------------------------------------------------------
[mysqld]
default-storage-engine=MyISAM
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
local-infile=0

skip-name-resolve
myisam_use_mmap=1

max_connections=100
max_user_connections = 30

log-error = /var/log/mysqld.log
log-slow-queries=/var/log/mysql-slow.log
#long_query_time = 0.1

query_cache_type = 1
query_cache_size = 75M
query_cache_limit = 2M

join_buffer_size=1M
read_rnd_buffer_size=1M
max_allowed_packet = 32M

tmp_table_size=25M
max_heap_table_size=25M

table_open_cache = 7500
thread_cache_size = 25

open_files_limit=30000

key_buffer_size = 500M
myisam_sort_buffer_size = 256M

userstat = 1
---------------------------------------------------------------------

any ideas?

 

[cPanelMichael]

Hello

Please remove the following entry from /etc/my.cnf and then restart MySQL:

skip-name-resolve

Let us know if this helps.

Thank you.

 

[sahostking]

Tried and it seems to have worked. Thanks

 

[cPanelPeter]

Hello,

Glad to hear it, thank you for updating this thread with the outcome.

 

[DennisAng]

hi!
iam also having this problem mysql version is 5.5.4
but my config only has these.

[mysqld]
innodb_file_per_table=1
local-infile=0

open_files_limit=50000
innodb_buffer_pool_size=134217728
max_allowed_packet=268435456

 

[cPanelMichael]

hi!
iam also having this problem mysql version is 5.5.4

Feel free to open a support ticket using the link in my signature so we can take a closer look. You can post the ticket number here so we can update this thread with the outcome.

Thank you.