MySQL server not responding to "show databases" or some other commands

Question

I can't figure out what I'm doing wrong. I open command prompt, move to my wamp/bin/mysql/bin directory and type

mysql -u root

since there is no password it logs in correctly, but when I type in

show databases

all I get is

->
->
->

until I click control+C

Here's a picture

Have you tried show databases;? I think that you need the last character ; . — ganchito55
– ganchito55, Commented May 16, 2016 at 22:08

Joel Coehoorn · Accepted Answer · 2016-05-16 21:26:11Z

4

You need a trailing semi-colon (;):

show databases;

It's waiting at the prompt because it thinks you haven't completed the statement yet. You could put a ; on a line by itself at this point and the full command would execute.

answered May 16, 2016 at 21:26

Joel Coehoorn

418k114 gold badges582 silver badges820 bronze badges

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

2 Comments

Zvone Over a year ago

oh my. Thank you disconnects in shame

Akito Over a year ago

In my case, having a semi-colon attached produces the same result.

Collectives™ on Stack Overflow

MySQL server not responding to "show databases" or some other commands

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related