Making a mysql databse in ssh
 

Okay so i used the command:

create database test; and i get this error:

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 'databse test
create database test' at line 1

I have mysql installed, i am logged in. latest mysql.

Edit: Sorry if this is in the wrong place, i am new.

Hi, welcome to LQ!

Now I'm not an expert on MySQL by any stretch of the imagination,
but did you try that w/o the semicolon?


Cheers,
Tink

Hi,
From what i see, it appears that you press del/backspace or something
like that at the mysql command line, the message is clear, the mysql
client log your query as:
'databse test create database test'

Best regards,

As stated in SSH when you log into Mysql all commands must end with ; or \g

But it turns out the database was already created, hence why i was getting this error, thanks though.

Sorry, I don't follow ... what has the connection method got
to do with language semantics?

Never mind...



Cheers,
Tink