Summary of the solution to the table is read only in MySQL

If you are using a database that suddenly appears to be a class problem

Under Linux to execute the following command on it, of course you have to find your MySQL directory

In Linux

The code is as follows	Copy Code
/usr/local/mysql/bin/mysqladmin-u root-p Flush-tables

In Windows

Can execute lush-tables in cmd

can also be modified in phpMyAdmin direct use of the repair table

If you are importing restore data

, so the database folder under all the table files chmod into 777,chown into "_mysql", but this problem is more serious, drupal inside the reality table crached. No way, immediately Google, found that the solution is quite easy.

First, find the location of the mysqladmin, usually under Mysql/bin, and then run the command:

The code is as follows	Copy Code
./mysqladmin-u Root-p Flush-tables

Then enter the password of the root account, immediately, without any hint, re-open Drupal, everything is OK.

Through this, also found the correct permissions of the database file settings: Data under the database Folder 700, table file 660, all files should be owned by MySQL.