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.
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.
What did you type into the MySQL shell?