MySQL table type and storage engine version inconsistencies workaround

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

MySQL error ' Type=myisam '

Workaround:

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 have Fix it.

With modified table engine Sql:alter table Db.user engine =myisam;

Supplemental MySQL table type and storage engine view

See what storage engine your MySQL has now provided:
Mysql> show engines;

Look at your MySQL current default storage engine:
Mysql> Show variables like '%storage_engine% ';

You want to see what engine the table is using (in the results, the storage engine that the table is currently using is the one behind the parameter engine):
Mysql> Show create table table name;

CREATE TABLE Discuz.cdb_user engine = InnoDB;
This makes it possible to change the engine of the table Discuz.cdb_user to the InnoDB engine.

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

If you want to see the types of tables you can use:
Show table status form Discuz;
Represents a view of 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;
At the end of the output information you can see engine=*****, which is the storage engine used by the table

Original from: Reprint Annotated source http://www.111cn.net/database/mysql/64521.htm