MySQL cannot execute select query

Scenario: MySQL cannot perform a select command query, and for existing databases, there are other databases such as Nova, Keystone, cinder, and so on, in addition to MySQL and INFORMATION_SCHEMA databases.

The following error is reported in the log:

Execute at this time:

>CREATE database db; >create table person (IDint., name varchar)> Usedb; >Select * from person ; >drop database db;

is not a problem.

View official website: http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting-datadict.html

The explanation is that this is due to the asymmetry of the InnoDB table with the. frm file information for each database. Go to Database view

>use Information_schema;

It can be found that the table does not have the corresponding information, so the error.

The problem has been found.

MySQL cannot execute select query