MySQL table type and storage engine version inconsistency resolution

Using the old version of the MySQL client navicate 8, the MySQL server with the mysql5.6 version, in the revision of the engine version of the version is not correct;

MySQL error ' Type=myisam '

Solution:

Replace

Type=myisam

With

Engine=myisam

The problem was "Type=myisam" which should is "Engine=myisam" as per MySQL version updates–a simple Search/replace has Fix it.

Attached modify table Engine Sql:alter table Db.user engine =myisam;

Supplementary MySQL table type and storage engine view

Look at your MySQL now what storage engine is available:
Mysql> show engines;

Look at your MySQL. Current default storage Engine:
Mysql> Show variables like '%storage_engine% ';

You want to see what engine a table is using (after the parameter engine in the display result indicates the storage engine that the table is currently using):
Mysql> Show create table name;

CREATE TABLE Discuz.cdb_user engine = InnoDB;
This allows the Discuz.cdb_user engine of the table to be changed to the InnoDB engine.

You can also change the following statement after you create the table:
ALTER TABLE Discuz.cdb_user engine =INNODB;

If you want to view the type of a table, you can use:
Show table status form Discuz;
Represents information for viewing all tables in the database Discuz, where engine: the corresponding column is the storage engine used by the table

If you want to view information for a single table, you can use:
Show CREATE TABLE Discuz.cdb_user;
You can see engine=***** at the end of the output information, which is where the storage engine used for the table