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

A

Alain Leonard

Member
Nov 30, 2004
8
0
151
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
 
Last edited:
You must log in or register to reply here.
Thread starter Similar threads Forum Replies Date
N Table is crashed and last repair failed"' for './mysql/global_priv' Databases 3
keat63 table corrupted Databases 3
H [ERROR] mysqldump: Error 2013: Lost connection to server during query when dumping table Databases 4
N csv cronjob to import in mysql database table Databases 5
spaceman Is a mixture of both MyISAM and InnoDB table types on the same MariaDB 10.3 database 'bad'? Databases 2
Similar threads
Table is crashed and last repair failed"' for './mysql/global_priv'
table corrupted
[ERROR] mysqldump: Error 2013: Lost connection to server during query when dumping table
csv cronjob to import in mysql database table
Is a mixture of both MyISAM and InnoDB table types on the same MariaDB 10.3 database 'bad'?
Top Bottom