PHP can't connect to MySQL

ranam

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 = mysql_connect($SESS_DBHOST, $SESS_DBUSER,$SESS_DBPASS) or die("Could not connect");

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

Anyone has any suggestion??

dstockto

If you are literally typing the same command in as you show above, and you don't have variables called $SESS_DBHOST, $SESS_DBUSER, and $SESS_DBPASS, then you will not get a connection. PHPMyAdmin gets values from a config file, so just copying their code without having any values in the variables will most likely never work.

Dave

ireader

Hi,
I also struggled with this on xp home edition,
I have a post-nuke rogue running fine on my localhost(pc running xp home,apache,php,mysql)
try using

dbhost= localhost
dbuser= (the same name you use to log in to xp)
dbpass= (the same password you use to log in to xp)
if you get myphpadmin working you may then change the permission settings to allow you to edit tables etc,

I am a complete novice, but may just be able to help a little,
Maybe you could help me by checking out my site and giving support/feedback?
regards
Ian
http://www.readergroup.co.uk

Russell Anam wrote:

ranam

David, I'm not dumb. I did say all my code worked before. They variables are defined in a include file. And the site works when uploaded. On my WinXP development it won't work. I am ofcourse suing the username "root" and password "" as always on windows machine.

gardner1

just a seemingly dumb question here, but since i have almost the same setup (php4.1.1, apache1.3.22, mysql on winxp) ...

I now i had many "arrrggg's" that would not pass either.

this is how i got it to work.

else {

// connect to mysql

$mysql = mysql_connect('localhost', 'booker', 'abc123');
if(!$mysql)
{
	echo 'cannot connect to db';
	exit;
}
$mysql = mysql_select_db('auth');
if(!$mysql)
	{
			echo 'cannot Select db';
			exit;
}

but, the kicker was that when establising in the "auth" database the users grants, i had to do this.

mysql>use auth;
mysql>grant all (or whatever privledges) on auth.* to booker@localhost identified by 'abc123';

if i did not add the @, then it would not work, even though you would think that the engine would append the @ for you, at least that's what i thought..."of course im @...grrr"

dunno, you might already have dont this too... /shrug

GL.

ranam

Unfortunately your procedure did not work for me. It's still the same.........

gardner1

ack...sorry.

perhaps something in the way the include is passing/not passing the variables to be input?

can you try w/ out the include first to test, and just fill in a localhost/user@localhost/pass combo to see if at least the connection 'can' be made?

If my forehead had anymore room for more bumps and knots Ive self-inflicted from my desk due to this madness they call PHP/MySql on win...., I know at least I can usually dummy up the script w/ the least amount of complexity first, to at least get the core functionality to work, ...then add the complexity step by step w/ echo "break"; 's in there... just a suggestion though you probably have gone that route also

how'z ur forehead doing? hehe jk! GL