Help using MySql on windows server 2003

Hi,
I have MySql installed on windows server 2003 and put all the required db information in my php configuration file. When I attempt to login on one particular web page It is suppose to hit the database and pass my username and password to wherever then move to the next page being logged in.

Instead I get this error:
Can't open MySQL! Please make sure you have your MySQL Login, Database and Host information set correctly in the "config.cgi" file before running this script! If you are not sure of your MySQL information contact your webhost to obtain it. You CANNOT use any of these safelist scripts unless you have MySQL running correctly on your site and know your MySQL login information.

I think that either php or MySql may be configured wrong on the server. Can someone help me on getting it set up the right way?

I do not have a config.cgi file but I do have a config.php file.


Thank-you,
Eric

config.php is right - its basically saying that you have entered the wrong information - database name etc, so, if there is no install screen with whatever it is you are trying to install, you need to go to config.php and enter the information directly

__________________
My Recipe forum...don't click here

Can you post the contents of your config.php file for us? (Obviously remove any passwords.)

Basically a config.php should look something like this.

Code: Select all

<?php
$foo_db = 'db_name'
$foo_user = 'user_ID';
$foo_password = 'password';
$foo_host = 'db_host';
?>

__________________
The internet is just a fad.
http://www.mevans76.com

# MySQL (Database) Information
$sql_db_name = "";
$sql_user = "";
$sql_pass = "";
$sql_hostname ="localhost";
$sql_port ="3306";

thats what it looks like...

And in the real copy, the db_name, user and password variables are set? You've only cleared them because you were posting them up here right?

thats exactly right.

I think config.cgi is a component of MySQL itself. I have only run MySQL on Linux and under Mac OS X so I am not entirely sure under windows.

Not sure what version of MySQL you have but maybe this will help you.

http://dev.mysql.com/doc/refman/5.1/en/windows-troubleshooting.html

__________________
The internet is just a fad.
http://www.mevans76.com