OK, heres the situation.
I have an XP system which runs my web server (192.168.0.1). I currently have IIS 5.0 installed on it and there is no problem loading the pages (i.e. it loads 192.168.0.1/index.htm with out any problems).
I have also managed to install PHP on to it, again without too much hassle and it works successfully.
But, when trying to install MySQL onto it, I come across some major problems. I downloaded version 3.23.56 for Windows and I followed this guide to installing it :- http://www.sitepoint.com/article.php/525. I thought I had done everything right. I installed it to C:\MySQL. Changed the necessary options in My.ini using WinmySQLadmin. I installed mysqld-nt.exe into my system, and by Pressing CTRL + ALT & DELETE, you can see this running in the processes. Everything is fine so far.
I then downloaded a program called MySQL Control Center onto my computer. I tried to access MySQL using the following information.
Hostname: localhost
username: root
password:
Everything workes fine. Then I downloaded a made-MySQL script. When I try and install this script (I edit the file that contains the hostname, username and password and use the same values as the ones that I used to connect using the MySQL Control Panel), it says it cannot connect to database.
I find this odd, seeming as I managed to connect it using MySQL Control Panel, but not with the script that I am running, despite having the same information.
What is going wrong?