mySQL: bind-address = in my.cnf
OK, I just installed MySQL5 on Debian Lenny on my home network. The linux box is configured with fixed ip. This is my first go round with mySQL on linux
As a first step, I try to connect remotely from Windows XP using MySQL Administartor, and I get MySQL error 2003, which as I understand is a connection error as opposed to an authentication error.
The obvious choice was the bind-address = 127.0.0.1 in /etc/mysql/my.cnf. By changing this to the network ip address I got a connection, and also a mySQL 1130 error. There's a lot of info on the net on that one, I can probably deal with it.
My question is, it seemed a little odd about that default bind-address. the mySQL website warns against that setting, but I didn't see any information about having two bind addresses, or actually changing this setting. presumably you would need to keep the 127.0.0.1 bind address for cases where the connection request was coming from any application running on the same server?
I suppose I could just go ahead and try it, but I thought I'd maybe hear from somone who had been down that road. It's a little unclear whether that setting should be changed.