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 2000/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
Sheldon