yea, me too. but being second just isnt as good... but did you grant the user permissions on the database they want to connect too? can you connect to anything listening on 3306? htttp?
when i connect from remote over tcp its >mysql -h "hostIP" -p -u "someuser" somedatabase the firewall accepts the connect and NAT's it to the right machine inside Jim -----Original Message----- From: Kristopher Yates [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 17, 2002 10:04 AM To: comcast.net; [EMAIL PROTECTED] Subject: Re: remote tcp connection failure i shoved it up my ass and things are now running great. Thanks for your invaluable assistance. Now if anyone on this list can be more helpful, I might just have an orgasm, as well as a fix to my 'problem'. Where is Paul DuBois when you need him? MY friend Jason says to look for him on here. For those SERIOUS about helping others, see below for my initial message that prompted the "shove it up your ass" solution. Kris comcast.net wrote: >yea i have an idea shove it up your >ass >----- Original Message ----- >From: "Kristopher Yates" <[EMAIL PROTECTED]> >To: <[EMAIL PROTECTED]> >Sent: Tuesday, December 17, 2002 9:07 AM >Subject: remote tcp connection failure > > > > >>Hello list, >> >>I have been running MySQL 3.23.51 on a 4.6 FreeBSD box for some time >>with no problem. >> >>Recently, a client requested the ability to connect from remote. Until >>now, I only allow connections from localhost and no TCP port open. >> >>I have been going through the docs trying to figure out how to get tcp >>working, and/or ssh. I can ssh into the box no problem and use my ssh >>client to create a socket local:3306 to remote:3306. I also restarted >>MySQLd to allow tcp: >> >>./mysql-server.sh start >> >>20503 p0 I 0:00.01 /bin/sh /usr/local/bin/safe_mysqld >>--user=mysql --port=3306 >>20521 p0 S 0:00.03 /usr/local/libexec/mysqld --basedir=/usr/local >>--datadir=/var/db/mysql --user=mysq (screen chops off) >> >>mysql client from command line of server connects fine at localhost. >>php applications use mysql server fine via user/pass at localhost. >> >>still cant connect to server from remote using same user/pass. the user >>has perms >>to allow connects from my remote ip (host). >> >>Connection Failed: 2013 lost connection to MySQL server during query. >> >>This problem is when I try the tunnell AND ALSO when I try to connect >>directly to the box from a remote ip via TCP. My username/pass has >>permissions to allow tcp connect from my remote host IP. For now, if I >>could just get tcp to accept connections from a remote ip without ssh >>would be a nice start. Can anyone help? I have read the docs and still >>cant get it to work. Any ideas? >> >>Thanks >> >>kris >> >> >> >>--------------------------------------------------------------------- >>Before posting, please check: >> http://www.mysql.com/manual.php (the manual) >> http://lists.mysql.com/ (the list archive) >> >>To request this thread, e-mail <[EMAIL PROTECTED]> >>To unsubscribe, e-mail >> >> ><[EMAIL PROTECTED]> > > >>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php >> >> >> > > >. > > > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
