DaniWeb Forum Index > Web Development > PHP

how to connect to mysql in wamp

•

Join Date: Jul 2009

Posts: 2

Reputation: prateekm is an unknown quantity at this point

Solved Threads: 0

prateekm

Offline

Newbie Poster

how to connect to mysql in wamp

Jul 11th, 2009

 Help with Code Tags 
 php Syntax (Toggle Plain Text) 
<?php
$con = mysql_connect("localhost:3306","pm" ,"");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }
 
// some code
?>
<?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.

Last edited by peter_budo; Jul 12th, 2009 at 4:19 am. Reason: Keep It Organized - For easy readability, always wrap programming code within posts in [code] (code blocks) and [icode] (inline code) tags.

•

Join Date: Oct 2006

Posts: 1,514

Reputation: ardav will become famous soon enough

Solved Threads: 194

ardav

Offline

Anthrax Poster

Re: how to connect to mysql in wamp

Jul 11th, 2009

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

Twpsyn cythraul. Cawr y dom tarw. Gwybod dim, gofyn dim.

•

Join Date: Jan 2008

Posts: 57

Reputation: emarshah is an unknown quantity at this point

Solved Threads: 5

emarshah

Offline

Junior Poster in Training

Re: how to connect to mysql in wamp

Jul 11th, 2009

•

Originally Posted by 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.

Hello prateekm,

in WAMP, use this syntax for your connection establishment;

 Help with Code Tags 
 php Syntax (Toggle Plain Text) 
$con = mysql_connect("localhost","root" ,"");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }
$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.

Syed Ammar Hassan
" A man is known by his level of Determinism "
--------------------------------------------------------
"Some cause happiness where ever they go, others whenever They go"
--------------------------XIII---------------------------