CODEWITHSUNDEEP
mysqldatabaseshow
darrah001
darrah001

Reputation: 11

mysql: show databases doesn't show any databases

I am new to using MySQL on a Mac. I am trying to show all the default databases but nothing is showing up when I use the command "show databases".

I have tried uppercase and lowercase. As well as using a semicolon and without it.

-> show databases ->

SHOW DATABASES; 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 'SHOW DATABASES' at line 2

I am trying to see the default databases in MySQL before proceeding

Upvotes: 1

Views: 5117

Answers (3)

love kholiya
love kholiya

Reputation: 1

Here you can type SHOW DATABASES; SHOW & DATABASES both are case sensitive and do not forgot ; in last

Upvotes: -1

Naman kashyap
Naman kashyap

Reputation: 11

You have to add ';' before ending the line. -> show databases;

Best of Luck.

Upvotes: 0

lkd
lkd

Reputation: 21

I was logged in as root user but getting same error, finally trying some combination found that in "Show DATABASES;" command DATABASES part is case sensitive.

Upvotes: 2

Related Questions