I write a tool where I want to list all available databases. I use libmysql 3.23 dll. and in code I set database to mysql and use "show databases" to display all databases.
I use EMS MySqlManager and in user rights there is a checkbox to enable/disable show databases. Independent of selection I always can use show databases and I don't know if it is a tool error or what.
So, my question is that the above mentioned method works in all cases? I mean with all users and with privilegs?