MySql Access denied for user ''@'localhost' to database

Question

I am trying to connect with Mysql using PHP. It works fine when I do it without a database. But gives me the following error when I try to connect with a database.

Warning: mysqli::__construct(): (HY000/1044): Access denied for user ''@'localhost' to database 'db_test' in C:\xampp\htdocs\Projects\DemoProject\demo2.php on line 13 Connection failed: Access denied for user ''@'localhost' to database 'db_test'

My PHP code is given below.

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

$conn = new mysqli($servername, $username, $password, $dbname);

if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
} 
else 
    echo "Connected Successfully";
?>

does the user have the assigned rights to access this database? does the database exists? btw, The default user in xampp is root with no password. — Sven Eberth
– Sven Eberth, Commented May 23, 2018 at 19:51
yes. the database exists. But I am not sure whether the user has the right to access the database. Ho to check it out or how to give the access? — Sohid Ullah
– Sohid Ullah, Commented May 23, 2018 at 19:53

user8406805 · Accepted Answer · 2018-05-23 19:56:06Z

1

Replace the user with your username and pass with your password for database and run the below command grant and flush privileges from root user.

grant all privileges on db_test.* to 'user'@'localhost' identified by 'pass';

flush privileges;

answered May 23, 2018 at 19:56

user8406805

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

Comments

Sohid Ullah · Accepted Answer · 2018-05-24 19:13:16Z

0

I actually used the wrong username. To check the username and servername just run the query given below-

select CURRENT_USER();

In general, username set as root and server name set as localhost by default.

answered May 24, 2018 at 19:13

Sohid Ullah

751 gold badge1 silver badge7 bronze badges

Collectives™ on Stack Overflow

MySql Access denied for user ''@'localhost' to database

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related