It sounds like you need to edit your hosts.allow file to allow from the IP you want to connect from.
add either mysqld : ###.###.###.### : allow or mysqld : all : allow I'm not a sysadmin though, so you might want to do a search on the proper way to do this. -----Original Message----- From: Kristopher Yates [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 17, 2002 9:08 AM To: [EMAIL PROTECTED] 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 <mysql-unsubscribe-##L=##[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
