|
From: Tim B. <tim...@ph...> - 2004-07-21 06:27:58
|
Hi Glenn- thanks for the reply :) I should have added that the machine is set up so that I can only make an ssh connection- the same is true if I want to make a vanilla MySQL client connection to the same machine. I've cc'd this to the list as well, hope that's ok? Thanks, Tim On 20/7/04 9:57 pm, "gwg" <gw...@co...> wrote: > Hi Tim, > > If MySQL is set up in the default manner, it should be listening on port > 3306. Unless your machine is set up in an unusual way, you should be > able to access the remote DB directly without using ssh. I don't have a > Squirrel instance available to check this right now, but something like: > > jdbc:mysql://the.mysql.server.node:3306/database_name > > may work for you. > > Glenn > > Tim Barrass wrote: >> Hi all, >> >> Is it possible to ssh tunnel a connection to a MySQL database using >> Squirrel? >> >> On a remote machine I can do the following >> >> >>> ssh -C -L 3307:the.mysql.server.node:3306 user@ the.mysql.server.node >>> mysql -h localhost -P 3307 -u user -p database_name >> >> >> - this connects fine. However, if I set up the ssh tunnel and try a Squirrel >> alias with the contact string >> >> jdbc:mysql://localhost:3307/database_name >> >> It tells me >> >> Unexpected Error occured attempting to open an SQL connection. Any advice >> very welcome... I'm using the 1.1final1 Squirrel on Mac OS X 10.3.4... >> >> Tim >> >> >> >> >> >> ------------------------------------------------------- >> This SF.Net email is sponsored by BEA Weblogic Workshop >> FREE Java Enterprise J2EE developer tools! >> Get your free copy of BEA WebLogic Workshop 8.1 today. >> http://ads.osdn.com/?ad_id=4721&alloc_id=10040&op=click >> _______________________________________________ >> Squirrel-sql-users mailing list >> Squ...@li... >> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users >> > > > --- > [This E-mail scanned for viruses by Declude Virus for the IOP] > |
