The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

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

Discussion in 'General Discussion' started by Alain Leonard, Jun 24, 2006.

  1. Alain Leonard

    Alain Leonard Member

    Joined:
    Nov 30, 2004
    Messages:
    8
    Likes Received:
    0
    Trophy Points:
    1
    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
     
    #1 Alain Leonard, Jun 24, 2006
    Last edited: Jun 24, 2006
  2. Alain Leonard

    Alain Leonard Member

    Joined:
    Nov 30, 2004
    Messages:
    8
    Likes Received:
    0
    Trophy Points:
    1
    Hi,

    I solved the problem by :

    WHM > SQL Services > Repair a Database > mysql
     
Loading...

Share This Page