Apache/PHP/MySQL help - something silly I'm sure

jacksonpt

About a month ago, I installed Apache 2, PHP4, and MySQL on a W2K box to be used as a temporary test environment. I got everything working well, and now it's time to setup a "production" server. It's the exact same setup (W2K/Apache2/PHP4/MySQL). I downloaded the files for Apache2, PHP4, and MySQL, installed everything, updated httpd.conf and moved php4ts.dll. Then I copied the MySQL data directory that stored the 2 DBs I wanted to move into production, along with the corresponding web files in the appropriate Apache directories.

When I load up the pages, I get the following error messages:

Warning: mysql_connect(): Can't connect to MySQL server on 'localhost' (10061) in C:\Apache\Apache2\htdocs\4ROC-NY\members.php on line 29

Warning: mysql_select_db(): supplied argument is not a valid MySQL-Link resource in C:\Apache\Apache2\htdocs\4ROC-NY\members.php on line 30

Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in C:\Apache\Apache2\htdocs\4ROC-NY\members.php on line 31

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in C:\Apache\Apache2\htdocs\4ROC-NY\members.php on line 32

No records were found!

I'm sure I'm overlooking something very basic, but I can't figure out why it won't connect. What am I missing?

jacksonpt

Not sure if you need the code or not, but here's the call:

$db = mysql_connect("localhost", "root");
mysql_select_db("4rocmembers",$db);
$result = mysql_query("SELECT * FROM members",$db);

nilesh

a basic check.

Are you able to connect to your MySQL server from the Production Webserver using mysql client. (Assuming both of them are on seperate machines). Please try this.

Even if both are on same machines try to connect to the MySQL server from the command line on the web production server.

If not you may have to change the grants privileges for the user that is trying to connect. If you had the grants privileges as user@'%' then that user should be able to connect.

Check the 2 above steps.

Regards,
Nilesh.