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,<[EMAIL PROTECTED]>
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
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
