[rlq]

Hi,

I just setup Apache, MySQL, and PHP using XAMPP and did several tests, some of them are passed such as PHP info test and date test, but It failed in this following test:

code: Load.php

PHP Code:

<?php
$con = mysql_connect("localhost","rlq","abc123");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

if (mysql_query("CREATE DATABASE my_db",$con))
  {
  echo "Database created";
  }
else
  {
  echo "Error creating database: " . mysql_error();
  }

mysql_close($con);
?>

Test Result:
Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'rlq'@'localhost' (using password: YES) in C:\xampp\htdocs\Load.php on line 2
Could not connect: Access denied for user 'rlq'@'localhost' (using password: YES)

I need your help to continue.
Thanks

[digioz]

Here is an obvious question. Did you add this user and password to the MySQL database?

Pete

[rlq]

Hi Pete,

I installed apache, php and mysql using Xampp. When install, there was no question about user name, password or ... any query. After installed, I tested phpinfo, then tested this database connection code.

However, your question to me is the answer. So can you tell me how to add the user and password to the MySQL database?

Thanks,

[Nico]

XAMPP's default user is "root", and there is no default password, so try leaving this in blank.

[rlq]

hi Nico,
I just tried to modify this line of code
$con = mysql_connect("localhost","rlq","abc123");

to
$con = mysql_connect("localhost","","");

$con = mysql_connect("localhost","rlq","abc123");

and the result is
Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'ODBC'@'localhost' (using password: NO) in C:\xampp\htdocs\Load.php on line 2
Could not connect: Access denied for user 'ODBC'@'localhost' (using password: NO)
So what I did not correct?

thanks,

[Nico]

The user. It should be "root".

PHP Code:

$con = mysql_connect("localhost", "root"); 

[rlq]

hi Nico,
I tried with
$con = mysql_connect("localhost","root");

and the result is
Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'root '@'localhost' (using password: NO) in C:\xampp\htdocs\Load.php on line 2
Could not connect: Access denied for user 'root '@'localhost' (using password: NO)

thanks,

[Nico]

Actually, try it this way:

PHP Code:

$con = mysql_connect("localhost", "root", ""); 

[rlq]

OOPS, I had "root " instead of "root". Your first suggestion is work.
thanks,

[rlq]

Peter, Nico,
I really appreciate your help. The first time I join the internet help group.
I am deeply impressed this group( can I say our group).
thanks