Couple times mysql lost user added to database, HELP.

[hekri]

Hello

We have mysql 4.0 on Redhat enterprise 4.0 and couple times we see situation (on couple servers - couple cccounts) that mysql lost users that was added to the database and user site stoped working because cant connect to database.

Maybe someone have the same problems? (i see that mysql lost user information form mysql dase table db and users) Database is ok but user must i cPanel add the same user with passwd and add thise user to the db....


Please help


My my.cnf (maybe i have wrog my.cnf ??)
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
skip-locking
query_cache_limit=1M
query_cache_size=32M
query_cache_type=1
max_user_connections=30
max_connections=250
interactive_timeout=10
wait_timeout=10
connect_timeout=10
thread_cache_size=128
key_buffer=16M
join_buffer=1M
max_allowed_packet=16M
table_cache=1024
record_buffer=1M
sort_buffer_size=2M
read_buffer_size=2M
max_connect_errors=10
thread_concurrency=4
myisam_sort_buffer_size=64M
server-id=1
long_query_time = 20
log-slow-queries = /var/log/mysqld.log

[mysql.server]
user=mysql
basedir=/var/lib

[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/lib/mysql/mysql.pid
open_files_limit=8192

[mysqldump]
quick
max_allowed_packet=16M

[mysql]
no-auto-rehash

[isamchk]
key_buffer=64M
sort_buffer=64M
read_buffer=16M
write_buffer=16M

[myisamchk]
key_buffer=64M
sort_buffer=64M
read_buffer=16M
write_buffer=16M

[mysqlhotcopy]
interactive-timeout

 

[electric]

We've seen this happen a few times, too.

The database user is just "gone"... and the database stops working.

The account owner must then go into cpanel, recreate the database user, and then add the "new" database user to the database.

Then the database works again.

It is very annoying, but does not happen often and we have never been able to find out why it happens.

Just another cpanel bug, I guess.

 

[hekri]

On us servers database was not gone, only user added to database (one user for 1-2 weeks gone) and user must go to cPanel and add new user and add user do db.

I speak with couple firms that have hosting on cPanel and all of them have the same problem...