Re: How make mysqld listen to only 2 IPs

2003-07-26 Thread Andreas
Hello Nils, thanks for your answer. :) First for the localhost entry. You will define a grant command like [...] Then for the remote connection you use [...] Right, that is somewhere in the online docu in the area of "adding a user" I prefer just to have the needed ports open rather than to fi

Re: How make mysqld listen to only 2 IPs

2003-07-26 Thread Nils Valentin
Hi Andreas, Good question. I saw this topic discussed many times in books. Please allow me to add my $0.02. First for the localhost entry. You will define a grant command like GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY PASSWORD 'mypassword' WITH GRANT OPTION Then for the

How make mysqld listen to only 2 IPs

2003-07-26 Thread Andreas
Hello :) 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 secon