Privilege Tables error

Discussion in 'MySQL' started by NikosK, Dec 22, 2013.

  1. #1
    Hey. I'am having a problem with my mysql-server, it did stop working a couple days ago.
    I was getting two error messages, the one was about innodb (which is fixed now.) and the one I can't find the root of the problem.

    131222 16:45:23 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
    131222 16:45:23  InnoDB: Initializing buffer pool, size = 8.0M
    131222 16:45:23  InnoDB: Completed initialization of buffer pool
    InnoDB: Log scan progressed past the checkpoint lsn 0 37356
    131222 16:45:23  InnoDB: Database was not shut down normally!
    InnoDB: Starting crash recovery.
    InnoDB: Reading tablespace information from the .ibd files...
    InnoDB: Restoring possible half-written data pages from the doublewrite
    InnoDB: buffer...
    InnoDB: Doing recovery: scanned up to log sequence number 0 44233
    131222 16:45:23  InnoDB: Starting an apply batch of log records to the database...
    InnoDB: Progress in percents: 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87$
    InnoDB: Apply batch completed
    131222 16:45:24  InnoDB: Started; log sequence number 0 44233
    131222 16:45:24 [ERROR] Fatal error: Can't open and lock privilege tables: Can't find file: 'user' (errno: 2)
    131222 16:45:24 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
    
    Code (markup):
     
    Solved! View solution.
    NikosK, Dec 22, 2013 IP
  2. #2
    The mysql user-table is corrupt. Easy fix: backup the database, reinstall mysql
     
    PoPSiCLe, Dec 22, 2013 IP