MySQL Forums
Forum List  »  Docs

Re: bind-address
Posted by: Stefan Hinz
Date: March 17, 2009 02:23AM

You can bind only to network interfaces available on the machine where MySQL is running. There's no way for PC A to access the network interface on PC B, so consequently the MySQL server refuses to start.

Assume your PC has 3 network interfaces:
- 127.0.0.1 (local host or local loop)
- 192.168.0.50 (network card/cable)
- 192.168.0.70 (network card/wireless)

Normally, the MySQL server will listen on all three interfaces. This is the default, but if it makes you happy :-) you could set it explicitly, with --bind-address='0.0.0.0'.

If you want MySQL to listen only on the cable interface you would set --bind-address='192.168.0.50'.

See http://dev.mysql.com/doc/refman/5.0/en/server-options.html for more information on bind-address.

Stefan Hinz, MySQL Documentation, Berlin, Germany

Options: ReplyQuote


Subject
Views
Written By
Posted
65741
February 25, 2009 02:44AM
Re: bind-address
68301
March 17, 2009 02:23AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.