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

Sometimes, heidi sql don't show all the databases

User, date Message
Written by dvadim13
1 year ago
Category: General
5 posts since Tue, 21 May 13
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.
Written by ansgar
1 year ago
4940 posts since Fri, 07 Apr 06
Probably you have a filter active in the upper left database/table filter boxes?
Written by dvadim13
1 year ago
5 posts since Tue, 21 May 13
There is no filter......

And also, when I execute the following query:

show databases;

it does not show all the databases.

Written by ansgar
1 year ago
4940 posts since Fri, 07 Apr 06
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.
Written by dvadim13
1 year ago
5 posts since Tue, 21 May 13
thanks for your reply. I connect as root.

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

Again, sometimes, I see those dbs.
Written by ansgar
1 year ago
4940 posts since Fri, 07 Apr 06
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.
Written by dvadim13
1 year ago
5 posts since Tue, 21 May 13
Can you tell me how to clean the cache ?
I reinstalled the mysql and I still see the old databases.
Written by jfalchMoney, Euro
1 year ago
382 posts since Sat, 17 Oct 09
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.
Written by dvadim13
1 year ago
5 posts since Tue, 21 May 13
Thanks a lot !!!
 

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