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

May 16, 2013 1.6k 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 ?
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.
Have another answer? Share your knowledge.