Your problem is the quotes you are using for the default of NAME
.
Here is your original create table from the question
CREATE TABLE `fish` (
`ID` int(11) NOT NULL auto_increment,
`NAME` varchar(30) NOT NULL default ‘’, <<--- LOOK HERE
`PRICE` decimal(5,2) NOT NULL default ‘0.00’,
PRIMARY KEY (`ID`)
) ENGINE=MyISAM AUTO_INCREMENT=27 DEFAULT CHARSET=latin1;
You gave default ‘’
and the mysql client does not understand it.
You need to express it with standard single quotes like this : default ''
I just noticed that a_horse_with_no_name's comment already says this.
Don't change anything else. Leave all other quotes as is.
Give it a Try !!!
This is on purpose and has nothing to do with the performance schema. MySQL Workbench is designed for MySQL and is only guaranteed (and tested) to work with MySQL servers (and checks this explicitly in certain places). And even then there are sometimes problems, caused by features not available in older versions. Let alone derivative work like MariaDB.
Best Answer
mysql_upgrade — Check and Upgrade MySQL Tables