1
Hi
I am setting up an Intranet (not externally connected) on our server (called fct.local). I have MySQL installed and have checked it with WinMySQLAdmin and it gets the green light and looks OK. MySQL is installed in c:\mysql.
On the server I have IIS6 running as well. That is also configured correctly (as far as I can tell because it displays a phpinfo(); page from the root of fct.local.
When I run the XOOPS installation, it gets all the way through with green lights, but then near the end I get a red light and it says 'Could not Connect to Database Server'
In the database hostname field I put 'fct.local'
Database Username : 'administrator' (this is what I used when setting up WinMySQLAdmin. I've also tried 10.1.1.1 and localhost)
Database Password : the same one used when setting up WinMySQLAdmin
Database name : 'fct' (created from the MySQL prompt by typing 'create database fct;'
Table prefix : 'xoops'
Xoops Physical Path : d:\cms.fct (this is a folder on the D: area of the server that I place my XOOPS site)
Xoops Virtual Path :
http://fct.localI gte some more greens, and then when it comes to the database bit it says 'Could not Connect to Database Server' with a red light and I have to start all over again.
Does anyone have any clues? Could it be that when I created the fct database it has a different password? Could it be because the MySQL database is in the c:\mysql\data\fct folder, rather than in the same folder as XOOPS (d:\cms.fct)? If so, how do I move the MySQL database from c: to d:?
Any help will be really apppreciated.