How to find the file causing a mysql syntax error

Question

I'm a newbie. I just set up Ubuntu to run on my Chromebook (via Crouton) last week and am currently in the process of setting up several Wordpress sites on localhost. I successfully installed a new Wordpress site yesterday, and I'm able to access the frontend and backend of the site via localhost no problem.

Today I wanted to create another Wordpress site. But when I try to create a new database in mysql using Terminal, I get the following error:

mysql> CREATE DATABASE;
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 '' at line 1

How do I figure out which file is causing the syntax error? I checked php.ini, which I edited yesterday, but line 1 looks fine.

You have to name your new database, like create database MyDB;. And to answer your question: No file caused the error, you did it yourself, right at the terminal ;-) — PerlDuck
– PerlDuck, Commented Apr 6, 2016 at 21:01

Seva Kalashnikov · Accepted Answer · 2016-04-06 20:55:52Z

1

The right way to use Mysql CREATE DATABASE statement

CREATE DATABASE my_db;

answered Apr 6, 2016 at 20:55

Seva Kalashnikov

4,4322 gold badges26 silver badges36 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

amanda f. Over a year ago

Thank you! I don't know why I didn't think to check that I was writing the command completely wrong.

Ederico Rocha · Accepted Answer · 2016-04-06 20:56:32Z

1

To my belief, you are missing the database name:

mysql>CREATE DATABASE database_name;

answered Apr 6, 2016 at 20:56

Ederico Rocha

2504 silver badges10 bronze badges

Collectives™ on Stack Overflow

How to find the file causing a mysql syntax error

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related