can't get mysql to work in PHP5

basic_mind

Please can somebody help.

OS: XP
PHP: 5.0.3
MySQL: 4.1.7
Apache: 2.0.52

Okay I have just installed php5 and apache2 onto my system with no bother. I am trying to get mysql working. I have my extension folder set correctly though I still think that its looking for them in the windows directory (so I put the extension files there too). I have added the exra dll that goes with mysql "libmysql.dll". also I have the php.ini looking for the file in the extensions.

Okay so when I boot up Apache it tells me everything is hunky dory. Even phpinfo() tells my that MySQL happy. but when I try to run any php script that contains mysql commands nothing works. I can access mysql through the command prompt no bother. but no through PHP itself. this proves to be a problem for me.

any help would be appritated.

mattotto77

Try doing some debugging

amend the script below and this should help provide some info.

<?php
$hostName = "localhost";
$userName = "name";
$password = "pass";
$dbName = "db";

// make connection to database
mysql_connect($hostName, $userName, $password) or die( "Unable to connect to host $hostName");

mysql_select_db($dbName) or die( "Unable to select database $dbName");
?>

basic_mind

says it cant connect to localhost :glare:

it is still in my phpinfo() but I can't access it know thought the command prompt. :mad:

ho humm

basic_mind

reinstalled mysql. back to the no error or nothing when sql is called in a script.

mattotto77

have you created a user in mysql that can access the database from localhost?

have you created the database?

there is a package that installs apache mysql and php for you cant remember the name of it. If you want it let me know.

Vigilante

Is php configured to use mysql? php 5 isn't, by default.