Mysql Table is read only error solution, mysqltable

Mysql Table is read only error solution, mysqltable

Today, I copied the database data to linux and run the program "Table is read only in mysql" to query the information.

Run the following command in linux:

# Mysqladmin-u root-p flush-tables

There is also a directory permission issue.

Due to the large amount of data, the export-> import process is slow. I directly compress the data, download the data, decompress the data, and change the user and group of the database directory to mysql considering the directory permission problem.

Code

Chown-R mysql: mysql (www.111cn.net)/usr/local/mysql/var

Write Permission

Chmod-R 0777/var/lib/mysql/taoniu2007/

Now, the problem is solved.

In windows

First, locate the location of mysqladmin, which is generally under mysql/bin, and then run the following command:

./Mysqladmin-u root-p flush-tables

Then, enter the password of the root account. It will be ready immediately. If there is no prompt, re-open drupal. Everything works.
From: http://www.111cn.net/database/mysql/66652.htm

Mysql, Table 'user' is read only. How can this problem be solved?

Modify permissions
GRANT privileges (columns) ON what TO user identified by "password" WITH GRANT OPTION

Privileges grants permissions to users. The following table lists the permission specifiers that can be used for GRANT statements:
Operation permitted by the permission specified character
Alter table and Index
Create Database and table Creation
Delete existing records in the table
Drop discard (delete) databases and tables
Create or discard an INDEX
Insert a new row into the table
REFERENCE unused
Select to retrieve records in a table
Update modify existing table records
FILE: reads or writes files on the server.
PROCESS: View information about the thread executed on the server or kill the thread.
RELOAD: RELOAD the authorization table or clear logs, host caches, or table caches.
SHUTDOWN the server
ALL; all privileges Synonyms

The system server2003 mysql cannot change the database table prompt 1036-table 'deston _ ad' is read only after logging on with the root user

This error occurs because the destoon_ad table can only be read but cannot be modified. Therefore, you must set this table to read and write modes.