[SOLVED] Making a mysql databse in ssh

archey · 06-23-2009, 08:53 PM

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.

Tinkster · 06-23-2009, 09:33 PM

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

jhcaiced · 06-23-2009, 09:34 PM

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,

archey · 06-23-2009, 11:06 PM

Quote:

Originally Posted by Tinkster

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

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.

Tinkster · 06-24-2009, 02:26 AM

Quote:

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