Report this

What is the reason for this report?

You have an error in your SQL syntax; Neeed Help

Posted on December 4, 2013

When installing wordpress I get this error when adding a semi colon at the end CREATE DATABASE WP1;

ERROR 1064 (42000): 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 ':

Is there any faster or less complicated way to install WP. I am used to cpanel 1-click install



This textbox defaults to using Markdown to format your answer.

You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!

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.

With “faster or less complicated” you end up sacrificing performance. If that’s what you want, check out <a href=“https://www.digitalocean.com/community/articles/one-click-install-wordpress-on-ubuntu-12-10-with-digitalocean”>One-Click Install WordPress on Ubuntu 12.10 with DigitalOcean</a>. <br> <br>If performance matters to you, check out a href=“https://www.digitalocean.com/community/articles/how-to-install-wordpress-nginx-php-and-varnish-on-ubuntu-12-04”>How To Install Wordpress, Nginx, PHP, and Varnish on Ubuntu 12.04</a>. <br> <br>You may also be interested in <a href=“https://www.digitalocean.com/community/articles/how-to-use-filezilla-to-transfer-and-manage-files-securely-on-your-vps”>How To Use Filezilla to Transfer and Manage Files Securely on your VPS</a>.

What command are you trying to run exactly?

The developer cloud

Scale up as you grow — whether you're running one virtual machine or ten thousand.

Get started for free

Sign up and get $200 in credit for your first 60 days with DigitalOcean.*

*This promotional offer applies to new accounts only.