PowerDns on a 'LAMP on Ubuntu' droplet throws SQL Error

Posted May 16, 2013 2.5k views
I've just created a LAMP droplet I'm installing PowerDNS, but when doing this, it must do something into mysql database. At a precise time, it tell me this: "mysql said: ERROR 1064 (42000) at line 1: You have an error in your SQL ? ? syntax; check the manual that corresponds to your MySQL server version ? ? for the right syntax to use near 'type=InnoDB' at line 10 " What can I do ?

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

Submit an Answer
2 answers
What did you type into the MySQL shell?
Can you post your my.cnf file - or at least check to see if it contains the line: 'skip-innodb'. If it does, then remove it.