Re: [Squirrel-sql-users] browse databases available on a server?

[Marion H. <hak...@cs...>]

Colin,

Thanks for being so gentle (:-).

I think I wasn't clear enough, so will try again.  Suppose I connect to
the mysql port on "dbserver" host, and I can't remember what databases
are there.  How do I get (or browse/select-from) a list?

In kmysql, it puts up a tree display (like squirrel-sql does for
the tables in a particular database) listing all databases on
the server, and I can "open" a database to see what tables it has,
and so on.

Sorry to seem like I'm harping on kmysql, it just happens to be one
I'm familiar with.

Regards,

Marion



> Hi Marion,
> 
> If I understand you correctly this should be working. In my case I have 2
> databases, test and rupert. I can log into rupert and issue the command
> 
> select * from test.cb01
> 
> and retrieve the results from the test database.
> 
> or I can issue the following commands successfully:
> 
> use test;
> select * from cb01
> 
> I'm using a slightly older version of the driver (2.0.7) but a slightly more
> uptodate version of MySQL (3.23.35a).
> 
> If its not working one possibility is permissions on the profiles that you
> use to log in with. I don't have security setup on my test databases.
> 
> Hope this helps
> 
> Col
> 
> PS I hope I wasn't too hard on you <grin/>