Re: PHP can't connect to MySQL in WinXP - Md. Ashraful Anam - com.mysql.lists.win32

9 messages in com.mysql.lists.win32Re: PHP can't connect to MySQL in WinXP

From	Sent On	Attachments
Md. Ashraful Anam	01 Feb 2002 11:14
Dave Watkinson	01 Feb 2002 11:36
Md. Ashraful Anam	01 Feb 2002 12:15
Russell Anam	02 Feb 2002 21:50
Dave Watkinson	03 Feb 2002 06:51
Martin Lindhe	04 Feb 2002 05:09
Md. Ashraful Anam	05 Feb 2002 09:27
Dave Watkinson	05 Feb 2002 13:23
Glenn F. Henriksen	05 Feb 2002 14:10

Subject:	Re: PHP can't connect to MySQL in WinXP
From:	Md. Ashraful Anam (russ...@bangla.net)
Date:	02/05/2002 09:27:57 AM
List:	com.mysql.lists.win32

Sorry Dude,

But I have tried almost every conventional method. I have tried mysql_error on every query from selecting the db to querying the table. MySQL does not return any error, not does it return any rows. I am connecting as root. I can connect in console so MySQL is running alright. SO's PHP and it has all the proper entensions installed. Same configuration works perfectly on Win98. There must be some bug on maybe mysql, apache or php. I'm sure it's a small one as not evrybody is affected but there's many as I have seen discussions on this on a lot of discussion board (all with no solutions).

Thanks Anyway.

-Russell.

----- Original Message ----- From: "Dave Watkinson" <d.wa...@mightymatch.com> To: "Md. Ashraful Anam" <russ...@bangla.net>; <win...@lists.mysql.com> Sent: Sunday, February 03, 2002 8:51 PM Subject: RE: PHP can't connect to MySQL in WinXP

well sorry for trying to help.

"i've tried everything" doesn't give anybody the first clue as to exactly what you've tried.

if you were a little more explicit and told us what you've tried then we'd be in a better position to offer some more appropriate help.

we're not mind readers, you know.

-----Original Message----- From: Md. Ashraful Anam [mailto:russ...@bangla.net] Sent: 01 February 2002 20:16 To: win...@lists.mysql.com Subject: Re: PHP can't connect to MySQL in WinXP

Very elementary Mr. Dave,

I think I made is perfectly clear that I tried everything and MySQL does not give any errors. And ofcourse MySQL is enabled in PHP.

Thanks anyway.

-Russell.

hey man, take it easy, it's Friday :-)

Have you tried an info page? like

<? phpinfo(); ?>

it will tell you if PHP *thinks* it is mysql enabled. If it is then try listing the host username and password explicitly in your connect, like

$c =3D mysql_connect("host","user","password") or die (mysql_error());

hope this helps!

-----Original Message----- From: Md. Ashraful Anam [mailto:russ...@bangla.net] Sent: 01 February 2002 19:15 To: win...@lists.mysql.com Subject: PHP can't connect to MySQL in WinXP

PHP can't connect to MySQL!! I have spend the last 6 hours trying to figure out why my scripts wont connect to MySQL. I upgraded to WinXP pro. Installed the old apache, php and mysql I was using. Everything worked but simple PHP WONT connect to mysql. I have tried editing every tiny configuration file and setting. PHP simply wont connect and read from the DB. Neither will it give any error that it can't connect. It will return a blank as if now row was there. Accessing from the dos prompt works fine. So I upgraded all my installations Apache 1.3.23, PHP 4.1.1 and MySQL 3.23.47-nt. Still no change. This is absoletely outrageous! I can't work!! And any long page keeps refreshing until I get the error page. I could not connect to the DB using PHP in any way (all of which ofcourse worked before and works on the hosting server)! Even phpMyAdmin won't work. But THE MOST funny thing is that when I downloaded the latest version of phpMyAdmin (phpMyAdmin 2.2.3) it connect to the DB without problem! I am using the same method to connect to the DB as they are:

$db =3D mysql_connect($SESS_DBHOST, $SESS_DBUSER,$SESS_DBPASS) or die("Could not connect");

(which is mysql_connect with the variable defined in a different include file).

but mine won't work! I also tried only $db =3D mysql_connect(); and any other combination. It just won't work!

Anyone has any suggestion??