Apache Friends Support Forum

Hey there,

i'm a newby in xampp and mysql aswell. i installed xampp on my xp pro machine. as far as i could figure out up to now everything works perfectly. for instance: i can create databases and tables in phpmyadmin; i can enter data into them in phpmyadmin and i can search the database in the same surface.
the readme-file of xampp says that

With the preset values, you'll have to use the following syntax: mysql_connect("localhost","root","");

but when i use this action in php my page can't connect to the database. it doesn't return an error neither.
in my php-file i programmed the following to get at least any result:

function printError($errorMesg)
{
printf("<br> %s <br>\n", $errorMesg);
}
if (!($link = mysql_connect("localhost","root","")));
{
printError(sprintf("error connecting to host %s, by user %s", $host, $user)); exit();
}

when running the script, it answers;

error connecting to host localhost, by user root

i didn't change anything in the configuration of any of the programs in xampp.

the truth is out there, they say, thus i hope it will find its way here

Code: Select all

function printError($errorMesg)
{
printf("<br> %s <br>\n", $errorMesg);
}
if (!($link = mysql_connect("localhost","root","")));
{
printError(sprintf("error connecting to host %s, by user %s", $host, $user)); exit();
}


Try this code to make connection to the database:

Code: Select all

$link = mysql_connect('localhost', 'root', '')
   or die ('error connecting to host: '.mysql_error());


What happens?

Code: Select all

function printError($errorMesg)
{
printf("<br> %s <br>\n", $errorMesg);
}
if (!($link = mysql_connect("localhost","root","")));
{
printError(sprintf("error connecting to host %s, by user %s", $host, $user)); exit();
}


I think you can connect if you put password like this

if (!($link = mysql_connect("localhost","root","password")));

if your user (eg root) haves no password set then you may use:

if(!$link=mysql_connect('localhost','root')) print "err connecting";

I have the same problem on my winXP Pro box. PhpMyAdmin works fine, but when i try to connect in my own php scripts, i get nothing. I tried the various codes posted in this topic, but MySql does not return an error, it just doesn't return anything

Anyone got an idea how we can fix this? Maybe something in the MySql config or something?