MySQL desktop PC setup problem

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic

   I've set up a forum with a MySQL 5.0 backend on a website on my dedicated remote server running Windows 2003 Web Edition.
It is working perfectly OK on this server.

So that I can work locally on the forum I am now trying to do the same thing on my local machine but can't seem to get anywhere.

I'm using the same settings except I am replacing the dedicated server IP address with "localhost" in the "database_connection.asp" file. (I've also used 127.0.0.1 but it makes no difference)

Very briefly this is what I have done:

I am using dreamweaver, so I have the forum files located in the 2 folders:
c:\inetpub\govern\forum
and
c:\inetpub\wwwroot\govern\forum

In MySQL I've created a schemata called governforum02 with UserName and PassWord.

in the forum "database_connection.asp" file I have entered:
       strSQLServerName = "localhost" 
       strSQLDBUserName = "UserName" 
       strSQLDBPassword = "PassWord" 
       strSQLDBName = "governforum02" 

I then run the "msSQL_server_setup.asp" file in my browser and enter the followiing:
    SQL Server Username - UserName
    SQL Server Password -  PassWord
    SQL Server Username for creating tables - governforum02

I then get the standard error message:
*******************************************************
Error Connecting to database on MySQLServer
Check the following is set up and correct:- 
MySQL Server User Name
MySQL Server Password
Name of the MySQL Server
Database name set up by you on the server
Empty Database set up by you on the MySQL Server
Check also that you have entered the correct details in the file 'database_connection.asp' found in the 'database' directory. 
********************************************************
As far as I can work out, I have entered everything correctly.

Could this be something to do with trying to run it locally?

Many thanks.
Brian