|
From: Colin B. <Col...@as...> - 2002-02-27 02:13:04
|
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/> -----Original Message----- From: Marion Hakanson [mailto:hak...@cs...] Sent: Wednesday, 27 February 2002 11:52 To: squ...@li... Subject: [Squirrel-sql-users] browse databases available on a server? Folks, I'm trying out squirrel-sql-1.1beta1 on SPARC/Solaris-8, java 1.4.0-beta3-b81, using JDB driver mm-mysql-2.0.11 to connect to our mysql-3.22.26a databases. As background, I'm looking for a more general replacement for the kmysql gui browser that I've been using for awhile. One feature I miss from kmysql is the ability to see/select from all databases available from a single connection to a mysql server. I'm able to do this with "sqlclient" (http://www.trustice.com/java/sqlclient/), using the same mm.mysql JDBC driver, so it must be do-able. Perhaps there's already a way to do this in squirrel-sql, and I'm just missing it. I'm not heavily into SQL nor Java, so please go easy on me (:-). Thanks and regards, -- Marion Hakanson <hak...@cs...> CSE Computing Facilities _______________________________________________ Squirrel-sql-users mailing list Squ...@li... https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users |
