I used to access mysql through command from terminal using

mysql -u root -p

And after that I also put the password of mysql. Now I want to show my databases using the command given below.

mysql> SHOW DATABASES -> 

But it shows nothing. So please help me with this problem.

1 Answer

Nothing wrong - everything works as supposed to do.

You typed an incomplete command and because this you see

mysql> SHOW DATABASES -> 

The mysql CLI waits for the completion of the command SHOW DATABASES. type ; followed by a Return

The correct syntax is

show databases;

The commands are not case sensitive.

Your Answer

Sign up or log in

Sign up using Google Sign up using Facebook Sign up using Email and Password Submit

Post as a guest

Post Your Answer Discard

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy