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

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, Dec 11 '13 at 06:49
Try to log on to phpMyAdmin using the same credentials as specified in opendb.php, does that work? — Kris Van den Bergh, Dec 11 '13 at 06: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, Dec 11 '13 at 06: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, Dec 11 '13 at 07:00
that i know, it is an phpmyadmin password. I am asking what is the value of $dbpass or what you are storing in it? and also have you set any password for phpmyadmin manually? — Ankur Dhanuka, Dec 11 '13 at 08:00
The value of $dbpass is stored on other file 'configdb.inc', which shows the user and passwoed inside the file. I also set the password for phpmyadmin, which is as same as the the password inside the file — user3056561, Dec 11 '13 at 08:08

score 1 · Answer 1 · answered Dec 11 '13 at 06:54

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 '13 at 06:54

srikanta mondal

119
2
15

score 0 · Answer 2 · answered Dec 11 '13 at 07:02

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 '13 at 07:02

Moax6629

378
4
14

score -1 · Answer 3 · answered Dec 11 '13 at 07:12

-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 '13 at 07:12

Ankur Dhanuka

1,217
2
11
22

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

3 Answers3