how to connect to mysql server using command prompt : error

Question

I am connecting to database mysql using command prompt using below command

mysql -h localhost -u test -ptest test;

But i am getting following 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 'mysql
 -h localhost -u test -ptest test' at line 1

I have done a lot of googling but could not find the reason behind this problem. Any help?

That error looks like you're already in mysql. Just type a query like SHOW DATABSES. — Halcyon
– Halcyon, Commented Mar 31, 2014 at 12:50
you need to select db first with this command use something_db — iamsleepy
– iamsleepy, Commented Mar 31, 2014 at 12:51
Hey can you accept one answer if you found any of this correct. — Lasitha Benaragama
– Lasitha Benaragama, Commented Apr 17, 2014 at 4:26

Ravinder Reddy · Accepted Answer · 2014-03-31 12:50:31Z

4

It seems you are executing the statement at mysql command line console but not at system shell prompt.

The statement

mysql -h localhost -u test -ptest test;

is for system shell prompt.

And while running at command prompt, you don't need to terminate the command by a semi colon.
And for suppressing use of password at command line,

change

-ptest

to

-p

It then prompts you to input your password.

answered Mar 31, 2014 at 12:50

Ravinder Reddy

24.1k6 gold badges54 silver badges86 bronze badges

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

Comments

Quentin · Accepted Answer · 2014-03-31 12:50:20Z

3

You need to run that command (which starts the mysql shell) from the command prompt.

You are trying to run it inside the mysql shell.

answered Mar 31, 2014 at 12:50

Quentin

949k136 gold badges1.3k silver badges1.4k bronze badges

Comments

Lasitha Benaragama · Accepted Answer · 2014-03-31 13:04:23Z

3

First make sure your command line doesnt show

mysql>

prefix. if it shows you are already in the mysql console. you have to type the command outside the mysql console.

mysql -h localhost -u test -ptest

That will fix you issue. Refer Mysql documentation for more information

http://dev.mysql.com/doc/refman/5.0/en/connecting.html

Thanks.

answered Mar 31, 2014 at 13:04

Lasitha Benaragama

2,2092 gold badges28 silver badges43 bronze badges

Comments

Harsh Chunara · Accepted Answer · 2014-03-31 12:51:11Z

-2

mysql -u root -p -h localhost

then command would ask for password, input it and you can logged into mysql server

answered Mar 31, 2014 at 12:51

Harsh Chunara

5853 silver badges10 bronze badges

Collectives™ on Stack Overflow

how to connect to mysql server using command prompt : error

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related