Sometimes, heidi sql don't show all the databases

[expired user #6958]'s profile image [expired user #6958] posted 11 years ago in General Permalink
Hello.

Suddenly, when I connect to my server with heidi sql, it does not show all the databases.

Version 8.0.0.4396

What can be the problem ?

Thanks,
Vadim.
ansgar's profile image ansgar posted 11 years ago Permalink
Probably you have a filter active in the upper left database/table filter boxes?
[expired user #6958]'s profile image [expired user #6958] posted 11 years ago Permalink
There is no filter......

And also, when I execute the following query:

show databases;

it does not show all the databases.

ansgar's profile image ansgar posted 11 years ago Permalink
Then, this is the cause why HeidiSQL doesn't show all of them either. Probably you don't have privileges on all databases. You can check that with HeidiSQL > Tools > User manager.
[expired user #6958]'s profile image [expired user #6958] posted 11 years ago Permalink
thanks for your reply. I connect as root.

So, I supposed to see all the tables, right ?

Again, sometimes, I see those dbs.
ansgar's profile image ansgar posted 11 years ago Permalink
Not necessarily. Check out what privileges "root" user has. To be honest, I also guess that's not the problem here, but I have no clue what it could be.
[expired user #6958]'s profile image [expired user #6958] posted 11 years ago Permalink
Can you tell me how to clean the cache ?
I reinstalled the mysql and I still see the old databases.
jfalch's profile image jfalch posted 11 years ago Permalink
RESET QUERY CACHE will do it.

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.
[expired user #6958]'s profile image [expired user #6958] posted 11 years ago Permalink
Thanks a lot !!!
JAB Creations's profile image JAB Creations posted 6 years ago Permalink

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.