how to connect to mysql in wamp

[prateekm]

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

// some code
?>

on writing the above code it is showing the following error:

Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'pm'@'localhost' (using password: NO) in C:\wamp\www\p2.php on line 83
Could not connect: Access denied for user 'pm'@'localhost' (using password: NO)

how can i solve this error.

[diafol]

Is 'pm' an user? Try 'root' and no password (default settings).

[emarshah]

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

// some code ?>

on writing the above code it is showing the following error:

Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'pm'@'localhost' (using password: NO) in C:\wamp\www\p2.php on line 83 Could not connect: Access denied for user 'pm'@'localhost' (using password: NO)

how can i solve this error.

Hello prateekm,

in WAMP, use this syntax for your connection establishment;

$con = mysql_connect("localhost","root" ,"");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

Hope it will help you...
Why you are writing port number with localhost? Also No username "pm" with password as "empty string" is registered.

[prateekm]

Is 'pm' an user? Try 'root' and no password (default settings).

thanks bro.....i got my mistake......its working with root and no password