Table 'mysql.users' doesn't exist please help me

[Alain Leonard]

Hi,

I have a problem :


In WHM , i made :

Reset Local MySQL Root Password, and mysql restart but :

/usr/bin/mysqladmin: connect to server at 'localhost' failed error: 'Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)' Check that mysqld is running and that the socket: '/var/lib/mysql/mysql.sock' exists! mysql has failed, please contact the sysadmin (result was "Warning, no valid mysql.sock file found.mysql has failed").

In error log file :

060624 21:01:27 mysqld started
060624 21:01:27 InnoDB: Started; log sequence number 0 22920435
060624 21:01:27 [ERROR] /usr/sbin/mysqld: Can't open file: 'user.MYI' (errno: 145)
060624 21:01:27 [ERROR] /usr/sbin/mysqld: Can't open file: 'user.MYI' (errno: 145)
060624 21:01:27 [ERROR] Fatal error: Can't open and lock privilege tables: Can't open file: 'user.MYI' (errno: 145)
060624 21:01:27 mysqld ended


I trying

mysql mysql -e "update users set password=PASSWORD('my_password') where user='root';"

but i have

ERROR 1146 (42S02) at line 1: Table 'mysql.users' doesn't exist


Anyone help me please

Thank you

[Alain Leonard]

Hi,

I solved the problem by :

WHM > SQL Services > Repair a Database > mysql