Hi,

I am trying to create tables in Mysql version 3.23.58
this is what I typed in the terminal:

mysql> create table MyVChanels(
-> Alerts varchar(50),
-> TypeID int not null primary key,
->
-> index(TypeID),
->
-> )type=innodb;
ERROR 1064: You have an error in your SQL syntax near ')type=innodb' at line 3

No matter what kind tables i am creating I get the same error with or
without primary key. To make it simple i even tried to create a table with one field but no help the same error pops up.
However, created tables in Window XP Mysql and works perfectly.

So I guess if there is some kind of configuration that I need to do?
Please help..

thank you

Since you're running mysql 3.23.58 which by default does not support innodb tables, you have to change the default mysqld daemon to mysqld-max and make some changes to my.cnf. Take a look here for details.

Regards