Find the answer to your Linux question:
Results 1 to 2 of 2
Enjoy an ad free experience by logging in. Not a member yet? Register.
  1. #1

    MySQL wont start


    when I try to start MySQL it fails with the following log file entries ...

    091002 00:35:35 mysqld started
    091002 0:35:37 InnoDB: Started; log sequence number 0 8740736
    091002 0:35:37 [ERROR] Fatal error: Can't open and lock privilege tables: Table '' doesn't exist
    091002 00:35:37 mysqld ended

    My my.cnf is

    set-variable = max_connections=300

    and is found in /usr/local/cpanel/whostmgr/my.cnf. MySQL was installed as part of Cpanel but Ive broken it somehow (we dont use it but wish to add a site that does) ...



  2. #2
    Hi ,
    It seems that on your server you are providing INNODB support too. I have seen in many cases that this will cause this issue. It won't start untill or unless you upload the fresh or backup of INNODB tables. You can skip innodb database. There is a way to do force recovery but I will not suggest you to do it, since it may break some more innodb database. The best way to fix this issue to find out which innodb table is causing the issue and upload the backup of that table. But this will be a hard task to do.
    You can try starting mysql with the skip-innodb option and see the result and do let me know if it fix your problem also update the error message.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts