Sometimes, heidi sql don't show all the databases
Suddenly, when I connect to my server with heidi sql, it does not show all the databases.
What can be the problem ?
And also, when I execute the following query:
it does not show all the databases.
So, I supposed to see all the tables, right ?
Again, sometimes, I see those dbs.
I reinstalled the mysql and I still see the old databases.
find your mysql server .exe (mysqld.exe). Uusually it´s somewhere (eg C:\Programs\MySQL\) in a sub directory called bin\ ; one directory level up should be the mysql server configuration file, my.cnf or my.ini. Look into it with a text editor; in the [mysqld] section, find datadir= . The directory listed in this line is your where your mysqld databases are stored physically (ie as files on disk); the directories in the datadir are the real databases that you should also see when you do SHOE DATABASES.
ansgar, I have a temporary work-around that should be an easy bug-fix for you.
I was having trouble viewing newly created databases with HeidiSQL. What I realized was that when I hit F5 with the focus on the right panel (primary tab: Host: localhost, secondary tab: Databases(#)) it would not fetch the databases however when I hit F5 on the left panel it would run the
SHOW DATABASES; query.
Perhaps either implementing an OS-level error beep when executing a command should the user not have focus on the correct panel or implement refresh/F5 support for the right panel. Thankfully I burned only an hour on this issue myself.
Please login to leave a reply, or register at first.