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