Hi,
I have a mysql setting problem that is driving me mad. Hopefully someone can give some advice:
On the local network I have windows 2002/iis5 machine running our intranet site, with php and mysql working ok. Anonymous access is disabled, and root has been assigned a password and given full access to all tables from all hosts (i reliase this isn't secure but its only temporary for testing)
The local intranet site which uses php/mysql works fine accross the company network, and i can use mysql administrator software sucessfully on any pc without problems. In short, everying great working fine.
We also have an internet webserver. Same setup, windows 2003/iis6, same php and mysql versions, in fact everything is indecital even the mysql user setup. only difference between two servers is physical location, ip address and some ntfs permissions. I can connect to the server fine from anywhere using mysql administrator, and the php site runs fine but nothing using mysql works either when running the site on the server itself using //localhost/index.php or accessing it remotly over the internet using ip.add.re.ss/index.php. Other stuff works fine on the intenet webserver, its just accessing mysql through php.
The only difference i can see is the ntfs permissions, but I have made changes to them without success and other stuff on the sever does work fine.
Any advice/suggestions would be greatly appreciated.
Cheers
Dila
