Do you have a question? Post it now! No Registration Necessary. Now with pictures!
- Posted on
- Archie Ball
April 7, 2005, 2:36 am
rate this thread
A comment was made something to the effect
that such a line in /etc/mysql/my.cnf could be
used to restrict network connections to mysql
to a specified IP address. I'm not quoting exactly,
but the idea is that if it is desired to connect to
mysql tables via say an ODBC connection, a line
like bind-address = 192.168.1.175 would allow
connections from a client pc with that ip addr.
What if I wanted to allow 2 PC's on the LAN to
connect to the mysql server on the linux box?
I couldn't find help on mysql.com for this objective.
Re: Searching mysql.com for "bind-address" yielded only 3 hits. I was hoping to find more info about it.
Archie Ball wrote:
I also searched for bind-address at Mysql.com but found the coverage not
very informative. Try google for other discussion of bind-address.
I'm pretty sure I read a web page (but I'm sorry I can't find it now) on
which a user said with some confidence that it works only to specify a
single IP address.
If you need something more flexible than that, you could configure MySQL
to accept any connections, while using your Linux server's firewall
(e.g. ipchains) to limit incoming traffic on port 3306 to the two IP
addresses in question.
- » Americanas.com SALDO de TVs Com at 80% de Desconto (29798)
- — Newest thread in » MySQL Database Forum