distal-attribute
distal-attribute
distal-attribute
distal-attribute

Sometimes, heidi sql don't show all the databases

dvadim13 posted 1 year ago in General
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 posted 1 year ago
Probably you have a filter active in the upper left database/table filter boxes?
dvadim13 posted 1 year ago
There is no filter......

And also, when I execute the following query:

show databases;

it does not show all the databases.

ansgar posted 1 year ago
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.
dvadim13 posted 1 year ago
thanks for your reply. I connect as root.

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

Again, sometimes, I see those dbs.

ansgar posted 1 year ago
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.
dvadim13 posted 1 year ago
Can you tell me how to clean the cache ?
I reinstalled the mysql and I still see the old databases.
jfalch posted 1 year ago
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.
dvadim13 posted 1 year ago
Thanks a lot !!!

Please login to leave a reply, or register at first.