MySQL Database Creation - Error 1064
Linode
Linode Staff
Hi Support,
I was wondering if you might be able to help and point me in the right direction.
In mysql >> CREATE DATABASE mydatabase_mjlfn then press enter. I presume at this point I have created an empty db mydatabase_mjlf?? To see if in fact I have done this I have been running cmds 'showdatabases;'.
I have in the past run pretty much the same thing and created what I needed. Just seem to be having continued issues.
All I get from this is ERROR 1064 or nothing shows any help or support at this point would great thanks.
1 Reply
The error you listed is a general MySQL error pointing to a syntax error. I noticed that in your command 'showdatabases;' that you are missing a space.
If it was a typo in your post and you entered it correctly at the command prompt, I would encourage you to log in to your MySQL with the following:
mysql -u root -p -v
This will provide verbose output for all of your commands. Then enter the following to get more information about the output, including the location of the syntax error if it occurs again:
SHOW DATABASES;
Then you can provide the full error message you're getting, if any, for additional help.