Forums » General Discussion

Thread: Connecting to an ISP database?

This question is not answered. Helpful answers available: 2. Answered answers available: 1.

Reply to this Thread Reply to this Thread Search Forum Search Forum Back to Thread List Back to Thread List Point your RSS reader here for a feed of the latest messages in all forums

Permlink Replies: 0 - Pages: 1 Threads: [ Previous | Next ]
dbatesx

Posts: 1
Registered: 6/18/10
Connecting to an ISP database?
Posted: Jun 18, 2010 11:42 AM 		 
  Click to reply to this thread Reply

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?

Thanks


Pages: 1
Back to Thread List Back to Thread List
Threads: [ Previous | Next ]
Legend
Guru: 2001 + pts
Expert: 751 - 2000 pts
Enthusiast: 31 - 750 pts
Novice: 0 - 30 pts
Moderators
Helpful answer (5 pts)
Answered (10 pts)

Point your RSS reader here for a feed of the latest messages in all forums