Fix - Collection Max error, Cannot Connect to Server

Problem Statement


Recently one of our customers was unable to connect to Collection Max and receiving an error Cannot Connect to Server.

Error Message

 

Error while starting mysql: Fatal error: Can't open and lock privilege tables: Table '.\mysql\user' is marked as crashed and should be repaired. MySQL server would no longer start, instead giving a Fatal error: Can't open and lock privilege tables: Can't find file: 'filename'


Solution


Upon investigation, we noticed that MySQL service could not get started and throws above error. This error was fixed by repairing the database table as follows.

  1. Login to the server where MySQL server is installed. Open the command prompt with administrator privileges.
  2. Start MySQL server in safe mode (skipping user privileges table) by issuing following command.

    mysqld_safe --skip-grant-tables &
    
  3. Select the database in question by running following command.

    use database_name;
  4. Repair the table name running following command.

    repair table table_name;
  5. Restart the MySQL service.

    /etc/init.d/mysqld stop
    
    /etc/init.d/mysqld start

    SSD Windows


Recommended plans for database driven application: SSD Linux VPS and SSD Windows VPS.


  • 0 Users Found This Useful

Was this answer helpful?

Related Articles

Fix :: ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found

Error Message ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no...

How to connect MySQL using PHP?

You can connect your MySQL with PHP using the below methods. Method 1 - PHP extension(mysqli)...

How to Allow Remote Connection to MySQL Server in Windows?

This article will assist you to enable remote access to MySQL server through Windows command...

How to Clone MySQL database using PhpMyAdmin?

Database clone is a process to create a separate copy of the database. You can also use it as...

How to Enable Relation View in phpMyAdmin?

The option Relation View is probably one of the best features available in phpMyadmin. Sometimes...