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
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
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