LinuxQuestions.org
Help answer threads with 0 replies.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie
User Name
Password
Linux - Newbie This Linux forum is for members that are new to Linux.
Just starting out and have a question? If it is not in the man pages or the how-to's this is the place!

Notices


Reply
  Search this Thread
Old 06-23-2009, 09:53 PM   #1
archey
LQ Newbie
 
Registered: Jun 2009
Posts: 27

Rep: Reputation: 15
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.

Last edited by archey; 06-23-2009 at 09:54 PM.
 
Old 06-23-2009, 10:33 PM   #2
Tinkster
Moderator
 
Registered: Apr 2002
Location: in a fallen world
Distribution: slackware by choice, others too :} ... android.
Posts: 23,067
Blog Entries: 11

Rep: Reputation: 910Reputation: 910Reputation: 910Reputation: 910Reputation: 910Reputation: 910Reputation: 910Reputation: 910
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
 
Old 06-23-2009, 10:34 PM   #3
jhcaiced
Member
 
Registered: Mar 2009
Distribution: CentOS - Ubuntu - Debian
Posts: 83

Rep: Reputation: 27
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,
 
Old 06-24-2009, 12:06 AM   #4
archey
LQ Newbie
 
Registered: Jun 2009
Posts: 27

Original Poster
Rep: Reputation: 15
Quote:
Originally Posted by Tinkster View Post
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.
 
Old 06-24-2009, 03:26 AM   #5
Tinkster
Moderator
 
Registered: Apr 2002
Location: in a fallen world
Distribution: slackware by choice, others too :} ... android.
Posts: 23,067
Blog Entries: 11

Rep: Reputation: 910Reputation: 910Reputation: 910Reputation: 910Reputation: 910Reputation: 910Reputation: 910Reputation: 910
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
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
Can MySQL log on via SSH/bash? mysql:x:27:101:MySQL Server:/var/lib/mysql:/bin/bash Ujjain Linux - Newbie 2 04-24-2009 03:21 PM
What is basic databse information for mysql payjoe Linux - Newbie 2 10-10-2007 01:49 PM
Looking for a resume' databse application rickenbacherus Linux - Software 1 01-27-2007 04:28 PM
MySQL:: backup entire databse but with selected tables structure only using mysqldump Swakoo Linux - General 1 11-07-2006 03:38 PM
Databse connection in VC++ LinuxTiro Programming 4 05-27-2004 06:32 AM

LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie

All times are GMT -5. The time now is 03:41 AM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration