How Make Mysqld Listen To Only 2 IPs
I have an development/test server on a windows 2000 box running. AFAIK mysql needs 127.0.0.1 to connect to the localhost, if I use it on the db-server's machine. Usually I'd connect via LAN so I need mysqld listen on 2 IPs.
1) 127.0.0.1
2) 192.168.1.42 <-- LAN-IP
This box has a second LAN-Interface and a third which connects to ADSL.
Those 2 are to be considered realm of evel.
I just rather have mysql listening on localhost and one of the
LAN-interfaces. Is this possible at all ?
There is this parameter for mysqld : bind-address
It only works with 1 aeddress. Even when I put 2 such lines in my.cnf it
just takes the second value.
Do I have to let it listen on 0.0.0.0 and let mysqld sort the access
attemts with the grant tables ?
View Replies !
Set MySQL To Listen From Other Computers
I have a problem connecting to MySQL server! The server is working on the other computer than my scrpit(my web page). The IP of MYSQL computer is 10.0.0.2. and port 3306! When i try to connect like this :
$link=mysql_connect("10.0.0.2.", "user", "password");
$db ="database_name";
... I get the folowing massage:
Warning: mysql_connect() [function.mysql-connect]: Can't connect to MySQL server on '10.0.0.2' (10061) in D:InetpubwwwROOT.......
The ip, username, password and database name are all correct! It is said, that it's possible, that the MySQL is set to work on localhost! If this is the problem, where to configure mySQL, to be able to connect from other computer?
View Replies !
TRACKER
