connect to php on XAMPP

[NewNet]

[code]<?php
$con = mysql_connect("localhost","root","test");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}

mysql_select_db("mysql", $con);

$result = mysql_query("Select * from User", $con);

while($row = mysql_fetch_array($result))
{
echo $row['User'] . " " . $row['Host'];
echo "<br />";
}

mysql_close($con);
?>[/code]
[b]Could not connect: Access denied for user 'root'@'localhost'I got error on [/b]

[sidewinder]

Only problem I see here might be with password. Xampplite doesn't use
root password for mysql by default. Did you set it to 'test'?

[NewNet]

Dear sidewinder,
You are right, I delete my Xammp and reinstall it , then my password is null , then the connection work,
[b]do I have to left the root password to "" I try to creat a new password and user but just get the same error , why??
[/b]

[NewNet]

after I retry the password I can connect to db by php code , but
when I run http://localhost/phpmyadmin/
I got [b]#1045 - Access denied for user 'root'@'localhost' (using password: NO)[/b]
why
by the way if I install Xampp lit , can i still ron mysql on Command Pronmpt ??
thank you

[sidewinder]

Go to your xampplite directory, then to phpmyadmin. Find
config.inc.php. In this file you can set your username, password and
authorization method (default is config). As an alternative go to
127.0.0.1/xampp and then on the left side there must be something
related with security. Under that tab you can set mysql password and
it will automaticaly change your phpmyadmin authorizaton method
(cookie or browser only). For more information check this
http://www.phpmyadmin.net/documentation/Documentation.html#config

I hope that helps. Good luck.

ps.

Yes you can use console to manage your mysql dbs in xampplite. Console
client is in either xamplite/mysql/bin or xampplite/bin or
/xamplite/apache/bin. Im away from my comp and i cant remember exactly
where executables are placed.

[NewNet]

Thank you,
after I set the following change