Access denied for user 'root'@'localhost' (using password: NO) for PHP [duplicate]

Question

I want to select some items from table, but the problem is shown that "Access denied for user 'root'@'localhost' (using password: NO)". The db system cannot select something from table. What can I do?

 <html>
 <body>
 <?php
 include ('opendb.php');
 ......
 echo "Date: " . date("Y/m/d") . "<br>";
$result = mysql_query("SELECT count(semail) AS av FROM `table` ")or die( 
 mysql_error());  
  $row = mysql_fetch_assoc($result) or die("No rows returned by query"); 
echo "Daily Volume: ".$result;
  ...... ?>

it's a permission problem, I think root@localhost need password — xfx
– xfx, Commented Dec 11, 2013 at 6:49
Try to log on to phpMyAdmin using the same credentials as specified in opendb.php, does that work? — Kris Van den Bergh
– Kris Van den Bergh, Commented Dec 11, 2013 at 6:50
well we kinda need to see opendb.php, but I am guessing its just a simple permission problem! you need to input a password. — Ahoura Ghotbi
– Ahoura Ghotbi, Commented Dec 11, 2013 at 6:52
Its a privilege problem. If you don't have privileges to access the database or the credentials supplied to the database.php doesn't match to mysql. — vahnevileyes
– vahnevileyes, Commented Dec 11, 2013 at 7:00

srikanta mondal · Accepted Answer · 2013-12-11 06:54:51Z

1

the problem is with your opendb.php file
make sure your database connections credentials are correct.
For some db the default password is root(LAMP environment)

answered Dec 11, 2013 at 6:54

srikanta mondal

1192 silver badges15 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Moax6629 · Accepted Answer · 2013-12-11 07:02:49Z

0

Probably you do not have any password associated to root so instead of 'NO' left the password equal to '' i.e. empty in your opendb.php !

answered Dec 11, 2013 at 7:02

Moax6629

3784 silver badges14 bronze badges

Comments

Ankur Dhanuka · Accepted Answer · 2013-12-11 07:12:35Z

-1

in opendb.php you might have used mysql_connect() function use like this. This will solve your problem

 $con = mysql_connect("localhost","root","") or die("sorry not connected");

answered Dec 11, 2013 at 7:12

Ankur Dhanuka

1,2372 gold badges12 silver badges22 bronze badges

Collectives™ on Stack Overflow

Access denied for user 'root'@'localhost' (using password: NO) for PHP [duplicate]

3 Answers 3

Comments

Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Linked

Related