Password Modification returns errors

sahostking

Well-Known Member
May 15, 2012
366
8
68
Cape Town, South Africa
cPanel Access Level
Root Administrator
Twitter
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.
 

sahostking

Well-Known Member
May 15, 2012
366
8
68
Cape Town, South Africa
cPanel Access Level
Root Administrator
Twitter
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

Administrator
Staff member
Apr 11, 2011
47,913
2,202
363
Hello :)

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

Code:
skip-name-resolve
Let us know if this helps.

Thank you.
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,913
2,202
363
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.