Web Wiz Support and Community Forums : MySQL desktop PC setup problem https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Thu, 09 Apr 2026 03:05:21 +0000 Sun, 03 Sep 2006 11:20:40 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=21201 <![CDATA[Web Wiz Support and Community Forums]]> https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ <![CDATA[MySQL desktop PC setup problem : I can&#039;t see any reason why...]]> https://forums.webwiz.net/mysql-desktop-pc-setup-problem_topic21201_post113528.html#113528 Author: WebWiz-Bruce
Subject: 21201
Posted: 03 September 2006 at 11:20am

I can't see any reason why it wouldn't work as I used mySQL 5 as a localhost database server on my laptop when I developed the mySQL version and it worked fine.

I would check your mySQL 5 is working correctly and allows TCP/IP connections.

Also, if you are running your own dedicated windows 2003 web edition I would use the free SQL Server 2005 Express instead as in tests I found you get improved performance over mySQL 5. This site currently uses the Express version on the same platform.
]]> Sun, 03 Sep 2006 11:20:40 +0000 https://forums.webwiz.net/mysql-desktop-pc-setup-problem_topic21201_post113528.html#113528 <![CDATA[MySQL desktop PC setup problem : I&#039;ve set up a forum with...]]> https://forums.webwiz.net/mysql-desktop-pc-setup-problem_topic21201_post113493.html#113493 Author: webwiz2000
Subject: 21201
Posted: 02 September 2006 at 4:41pm

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
]]> Sat, 02 Sep 2006 16:41:09 +0000 https://forums.webwiz.net/mysql-desktop-pc-setup-problem_topic21201_post113493.html#113493