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

Question

0.00/5 (No votes)

See more:

hi,

i have made a login page for my website but when i test the login from the 'localhost' i get the message below:

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

can anyone help me with this error.

for your information, i have added my password to the file 'config.inc.php' by changing:

PHP

$cfg['Servers'][$i]['password']      = '';

TO

PHP

$cfg['Servers'][$i]['password']      = 'password';

Thank You for any help

Hamza

Posted 11-Apr-12 8:40am

hamza_786

Add a Solution

2 solutions

Solution 2

That error means that a webpage is accessing a server that has a password, but is not using one. root@localhost has a password and probably your mysql_connect() doesn't have a password parameter set up. Let's say you used:

$cfg['Servers'][$i]['password'] = 'password';

Your mysql_connect() should contain that password as well along with the proper parameters for ROOT@LOCALHOST

try this for instance:

mysql_connect("localhost","root","password");

Posted 3-Aug-12 5:03am

Member 9333147

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

SamarRizvi · Accepted Answer · 2012-04-11T17:10:00

Solution 1

Create a new user through phpMyAdmin and give it full privileges to the required database or for all databases. Then in config.inc.php write the username and password as you gave for new user.

Posted 11-Apr-12 17:10pm

SamarRizvi

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

2 solutions

Solution 2

Solution 1

Add your solution here

Preview 0

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

2 solutions

Solution 2

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us