Re: mysql323-server -- can't connect remotely
Okay, I figured it out. It had absolutely nothing to do with user permissions. It was, amazingly, tcpwrappers that was causing the problem. I discovered a ton of log entries like the following in my Security Output email: Mar 7 00:22:11 lilbuddy inetd[968]: refused connection from 192.168.1.1, service auth (tcp) I edited /etc/hosts.allow and uncommented ALL : ALL : allow from the top of it. Sure enough, mysql connections with a -h specified started working! Now, I couldn't quite figure out why connections where being stopped. The log entries seem to indicate it has something to do with auth, but here's the auth line from my /etc/hosts.allow: auth : ALL : allow I decided to add the following to /etc/hosts.allow: mysqld: ALL : allow That did it. It works fine now. Apparently this is normal, as I've now found some websites that mention needing to tweak /etc/hosts.allow for mysqld. I'm amazed that this isn't in the mysql manual though. Ridiculous. Perhaps this is fairly new? On Friday, March 7, 2003, at 03:18 PM, [EMAIL PROTECTED] wrote: http://www.mysql.com/doc/en/Adding_users.html I have /usr/ports/databases/mysql323-server installed, and it is up and running. If I do: mysql -h localhost Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 to server version: 3.23.55 Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql It works fine. However, if I do: mysql -h lilbuddy.antsclimbtree.com ERROR 2013: Lost connection to MySQL server during query Do you have an entry for 'lilbuddy.antsclimbtree.com' in the user and db tables in your mysql database? That's what I get. lilbuddy.antsclimbtree.com is the hostname of the server machine, and I'm doing this from that machine. Any idea what's wrong? Thanks! -- Mark Edwards San Francisco, CA To Unsubscribe: send mail to [EMAIL PROTECTED] with unsubscribe freebsd-questions in the body of the message -- Mark Edwards San Francisco, CA To Unsubscribe: send mail to [EMAIL PROTECTED] with unsubscribe freebsd-questions in the body of the message
mysql323-server -- can't connect remotely
I have /usr/ports/databases/mysql323-server installed, and it is up and running. If I do: mysql -h localhost Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 to server version: 3.23.55 Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql It works fine. However, if I do: mysql -h lilbuddy.antsclimbtree.com ERROR 2013: Lost connection to MySQL server during query That's what I get. lilbuddy.antsclimbtree.com is the hostname of the server machine, and I'm doing this from that machine. Any idea what's wrong? Thanks! -- Mark Edwards San Francisco, CA To Unsubscribe: send mail to [EMAIL PROTECTED] with unsubscribe freebsd-questions in the body of the message
Re: mysql323-server -- can't connect remotely
I have /usr/ports/databases/mysql323-server installed, and it is up and running. If I do: mysql -h localhost Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 to server version: 3.23.55 Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql It works fine. However, if I do: mysql -h lilbuddy.antsclimbtree.com ERROR 2013: Lost connection to MySQL server during query Do you have an entry for 'lilbuddy.antsclimbtree.com' in the user and db tables in your mysql database? That's what I get. lilbuddy.antsclimbtree.com is the hostname of the server machine, and I'm doing this from that machine. Any idea what's wrong? Thanks! -- Mark Edwards San Francisco, CA To Unsubscribe: send mail to [EMAIL PROTECTED] with unsubscribe freebsd-questions in the body of the message
Re: mysql323-server -- can't connect remotely
http://www.mysql.com/doc/en/Adding_users.html I have /usr/ports/databases/mysql323-server installed, and it is up and running. If I do: mysql -h localhost Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 to server version: 3.23.55 Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql It works fine. However, if I do: mysql -h lilbuddy.antsclimbtree.com ERROR 2013: Lost connection to MySQL server during query Do you have an entry for 'lilbuddy.antsclimbtree.com' in the user and db tables in your mysql database? That's what I get. lilbuddy.antsclimbtree.com is the hostname of the server machine, and I'm doing this from that machine. Any idea what's wrong? Thanks! -- Mark Edwards San Francisco, CA To Unsubscribe: send mail to [EMAIL PROTECTED] with unsubscribe freebsd-questions in the body of the message To Unsubscribe: send mail to [EMAIL PROTECTED] with unsubscribe freebsd-questions in the body of the message
Re: mysql323-server -- can't connect remotely
On Friday, March 7, 2003, at 02:34 PM, Kjell wrote: I have /usr/ports/databases/mysql323-server installed, and it is up and running. If I do: mysql -h localhost Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 to server version: 3.23.55 Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql It works fine. However, if I do: mysql -h lilbuddy.antsclimbtree.com ERROR 2013: Lost connection to MySQL server during query Do you have an entry for 'lilbuddy.antsclimbtree.com' in the user and db tables in your mysql database? Yes, the test database and the anonymous user are accessible from any host. In any case, I believe the error would be ERROR 1130: Host 'lilbuddy.antsclimbtree.com' is not allowed to connect to this MySQL server if that was the problem. -- Mark Edwards Engineer Mr. Toad's San Francisco, CA To Unsubscribe: send mail to [EMAIL PROTECTED] with unsubscribe freebsd-questions in the body of the message
Re: mysql323-server -- can't connect remotely
I issued the necessary GRANT statements to add a new user, as described on that page, and I get: mysql -u marktest -p -h antsclimbtree.com Enter password: ERROR 2013: Lost connection to MySQL server during query Same thing. Again, shouldn't the error message be different if this is a permissions problem? On Friday, March 7, 2003, at 03:18 PM, [EMAIL PROTECTED] wrote: http://www.mysql.com/doc/en/Adding_users.html I have /usr/ports/databases/mysql323-server installed, and it is up and running. If I do: mysql -h localhost Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 to server version: 3.23.55 Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql It works fine. However, if I do: mysql -h lilbuddy.antsclimbtree.com ERROR 2013: Lost connection to MySQL server during query Do you have an entry for 'lilbuddy.antsclimbtree.com' in the user and db tables in your mysql database? That's what I get. lilbuddy.antsclimbtree.com is the hostname of the server machine, and I'm doing this from that machine. Any idea what's wrong? Thanks! -- Mark Edwards San Francisco, CA To Unsubscribe: send mail to [EMAIL PROTECTED] with unsubscribe freebsd-questions in the body of the message -- Mark Edwards Engineer Mr. Toad's San Francisco, CA To Unsubscribe: send mail to [EMAIL PROTECTED] with unsubscribe freebsd-questions in the body of the message