1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

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