PHP - Connection failed: Access denied for user 'username'@'localhost' (using password: YES)

Question

I am facing this error. tried all solutions given in other threads...creating a new user@localhost and grant privileges to it. But nothing works for me...

still getting this error..

Connection failed: Access denied for user 'username'@'localhost' (using password: YES)

here is my code..

<?php
$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "databasename";

// Create connection
$conn = mysqli_connect($servername, $username, $password, $dbname);
// Check connection
if (!$conn) {
    die("Connection failed: " . mysqli_connect_error());
}
else {
    echo "Connection Successful";
}
mysqli_close($conn);
?>

The issue is on your MySQL configuration then (assuming you are using the correct username and password). Did you grant privileges to the "username" account on localhost? Did you flush privileges after? Is the account actually created with the proper "IDENTIFIED BY" clause for the "password"? — SArnab, Jul 02 '16 at 12:05
It's most likely not an issue with your PHP code, but with your actual MYSQL configuration as mentioned above. — The Codesee, Jul 02 '16 at 12:05
if you use phpmyadmin look on users and check if your user have correct host for access. http://webvaultwiki.com.au/(S(iungfwenvz2f5c55pioeinil))/GetFile.aspx?File=/images/screenshots/mysql/phpmyadmin04.png — daremachine, Jul 02 '16 at 12:10
yes, i created a separate user for my database..and also grant all privileges to it... — SumIt Sahu, Jul 02 '16 at 17:31

score 1 · Answer 1 · edited Sep 23 '19 at 11:35

1 of 2 things is probably happening

Your password is incorrect
username is not authorized to access that database

What do you get when you execute execute following query

FLUSH PRIVILEGES; SHOW GRANTS;

You can probably find your problem here.

Update July 4,2016

I suspect that the user's password was stored incorrectly. Try resetting the password (you may need to be connected as the root user for this to work):

ALTER USER 'username'@'localhost'
    -> IDENTIFIED BY 'cleartext_password';

If that doesn't work you could try the older syntax:

SET PASSWORD FOR 'username'@'localhost' = PASSWORD('cleartext_password');

Replace cleartext_password with the password you wish to use. Then try to connect again.

Does it work?

still the same problem :'(

Ok, let's start with a fresh new user. Execute the 3 commands below as the root user.

CREATE USER 'newuser'@'localhost' IDENTIFIED BY 'cleartext_password';
GRANT ALL PRIVILEGES ON * . * TO 'newuser'@'localhost';
FLUSH PRIVILEGES;

If all 3 commands executed properly, try next to connect to your database as newuser.

Did it work? If not, what error do you see?

GRANT ALL PRIVILEGES ON *.* TO 'username'@'localhost' WITH GRANT OPTION GRANT ALL PRIVILEGES ON `databasename`.* TO 'weirdmyth'@'localhost' GRANT PROXY ON ''@'' TO 'username'@'localhost' WITH GRANT OPTION — SumIt Sahu, Jul 02 '16 at 17:34

score 1 · Answer 2 · answered Jul 02 '16 at 12:38

1

Some thing wrong with username or password

If you are using windows by default username is "root" and password is "" (empty),

answered Jul 02 '16 at 12:38

Manish Patil

11
2

no i m not using root....i created a separate user for that database...and also grant all privileges to it ...and also m using Ubuntu 16.04 – SumIt Sahu Jul 03 '16 at 09:12
Also, using root and "" empty password didn't work neither – Mahdi Alkhatib Apr 18 '18 at 08:06

PHP - Connection failed: Access denied for user 'username'@'localhost' (using password: YES)

2 Answers2