Database not visible

[expired user #10791]'s profile image [expired user #10791] posted 7 years ago in General Permalink

The other day I created a database in my MySQL Server with phpMyAdmin. All works fine: I can populate the databse etc.. One thing: I DO NOT see this database in HeidiSQL (I can see other previously created databases). How can I resolve this? all answers will be much appreciated, gabriël

kalvaro's profile image kalvaro posted 7 years ago Permalink

You don't need to do anything special to see new databases. Have you done something to hide it within HeidiSQL, like using a database filter or connecting with a restricted user?

[expired user #10791]'s profile image [expired user #10791] posted 7 years ago Permalink

I have a suspicion that not HeidiSQL is the culprit but that for one reason or the other the database is not visible from another computer: the database is mounted on a MySQL Server on a Raspberry Pi and HeidiSQL runs on my Win10 PC on the same LAN. the other database I can see is also mounted on the same MySQL Server; Could it be a question of rights on that particular database? gabriël

rsterenb's profile image rsterenb posted 7 years ago Permalink

Yes. Permissions are given to user@host/ip. So if the permissions are not set correctly, you won't see the database running HeidiSQL from another host. For "any" host, you can use "%" as hostname.

[expired user #10791]'s profile image [expired user #10791] posted 7 years ago Permalink

Thank you very much for your answer. I am, as you might have guessed, a novice when it comes to SQL databases and rights. I'll try to set permissions as you wrote in your answer. much appreciated, gabriël

[expired user #10791]'s profile image [expired user #10791] posted 7 years ago Permalink

Setting the rights on the database "any" host did the trick. Thanks for all the help. gabriël

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