In mysql, the show databases; command doesn't list all of my databases

Question

I can access all of my databases with HeidiSQL, but if I go to the mysql.exe window and use show databases; only 2 of them show up out of 11. These are all databases on 127.0.0.1. Any ideas on why?

Answer 1

You're logging into HeidiSQL as root, so it's showing you all databases, but you're logging into mysql.exe as the current Windows user (since that's the default), so it's only showing you the databases that that user can see. If you run mysql.exe with --user=root --password=..., it will show you all databases.

Answer 2

in my case, SHOW DATABASES or SHOW DATABASES; didn't work.

what worked is:

show databases;