i want to connect to my database but i don't know how to set the username and the password to the database in order for my connection to be successful.i have EasyPhp installed on my computer which is another way to get php,mysql and apache installed on your computer. any one with an idea?
please help.

First off: Do you know the name of your Database and it's Server Address (typically "localhost"), or the password to your Database?

If you do, insert these values into the following script:

<?php
$dbhost = 'EDIT';
$dbuser = 'EDIT';
$dbpass = 'EDIT';
$conn = mysql_connect($dbhost, $dbuser, $dbpass) or die                      ('Error connecting to mysql');

$dbname = 'EDIT';
mysql_select_db($dbname);
?>

If you get your username/password/database fields correct, you should be connected now

If not, you will see the dreaded error

I'd just make these changes to Lashtal's code so that you can have a bit more informative error message:

PHP Code:

<?php
$dbhost = 'EDIT';
$dbuser = 'EDIT';
$dbpass = 'EDIT';
$dbname = 'EDIT';

if ($conn = mysql_connect($dbhost, $dbuser, $dbpass)) {
  if (!mysql_select_db($dbname)) {
    echo '<p>Unable to connect to the database.  MySQL said &quot;'.mysql_error().'&quot;</p>';
  }
} else {
  echo '<p>Unable to connect to the database server.  MySQL said &quot;'.mysql_error().'&quot;</p>';
}
?>

Very important to include when you're starting out

Helps to have that error or success message show up.

thanks for the all the good answers. but i only know of the database name and the server address(localhost) .i don't know of the username and the password. how do i create them or set them because i did not set or create them when i was creating the database?

Do you have a control panel like cPanel or Plesk? If so, they will allow you to create a user and password -- just remember to assign the user to the database or you won't be able to access the database with that user and password.

If you're executing the SQL directly and have the right privileges, then you can use this syntax:

grant all privileges on dbname.* to 'username'@localhost identified by 'password'