why would mysql require -h 127.0.0.1??? - Marc Swanson - com.mysql.lists.mysql

7 messages in com.mysql.lists.mysqlwhy would mysql require -h 127.0.0.1???

From	Sent On	Attachments
Marc Swanson	17 Apr 2000 18:09
Jeremy Cole	17 Apr 2000 20:22
benjamin-weiss	17 Apr 2000 21:40
Jeremy Cole	17 Apr 2000 21:43
benjamin-weiss	17 Apr 2000 21:57
Derick Siddoway	17 Apr 2000 22:31
benjamin-weiss	18 Apr 2000 05:23

Subject:	why would mysql require -h 127.0.0.1???
From:	Marc Swanson (marc...@mediaone.net)
Date:	04/17/2000 06:09:45 PM
List:	com.mysql.lists.mysql

Helo,

A few days ago one of my clients had a strange problem where some of their perl DBI scripts were dying because the connection handle was failing. I investigated the problem and I knew something was up when the server which has mysql running on it would not connect to the server when firing up the command line interface with "mysql" with no arguments. I looked at the process table and mysqld appeared to be running so just for fun I tried specifying localhost by running "mysql -h 127.0.0.1" and it worked?!? They have never had to specify the localhost before...

Anyway I shutdown the mysql server and started it back up with "mysql start" from /etc/rc.d/init.d and all appeared as normal again... Any ideas on what would cause this? Server is version 3.23.10-alpha.

Thanks

-Marc-