I'm trying to connect to a MySQL DB on my ISP. I don't have SHOW DATABASES privilege on the server, and so don't see my own database in the tree (just a "MySQL Database Error: Access Denied; You need the SHOW DATABASES privilege for this operation" leaf under the "Databases" node in Object Explorer), and therefore cannot get a list of my db objects.
I believe I have the connection credentials correct; I do get values under the Sessions, Variables and Status nodes. It's the Databases, Users, and Hosts nodes that I have "no privilege" errors.
Is there a way to get Toad to allow me to manage my remote database without requiring a list of all databases on the server?