php- Unable to connect to database with PDO

Question

I'm having problems connecting to my local database. For some reason when I try to connect it shows the error below:

Connection failed: SQLSTATE[HY000] [1045] Access denied for user 'root'@'localhost' (using password: NO)

I manage to connect to my phpmyadmin with the user, and using to command line, but when I try using my php script I can't. But I did manage to do it before.

I use a simple PDO connection code:

<?php
define('DB_USER', "root");
define('DB_PASSWORD', "");
$DB_SERVER = "localhost";
$DB_DATABASE = "app-db";

try {
    $conn = new PDO("mysql:host=$DB_SERVER;dbname=$DB_DATABASE", DB_USER, DB_PASSWORD);
    // set the PDO error mode to exception
    $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
} catch(PDOException $e) {
    echo "Connection failed: " . $e->getMessage();
}

I've also tried using 'new mysqli(host, user, password)' and 'mysqli_connect(host, user, password,database)' and the same response, access denied for user.

Any help will be great.

what are you using for your local development? XAMPP? WAMP? MAMP? Or Laragon? — Abdul Rahman A Samad
– Abdul Rahman A Samad, Commented Mar 17, 2019 at 10:48

spazmantiz · Accepted Answer · 2022-12-23 09:57:15Z

1

Are you sure that you DB engine is ON? And that user is without password? Maybe is root root?

And little tip : If your string shouldn't be interpreted use ' instead " . It will faster. For example:

    define('DB_USER', 'root'); 
    define('DB_PASSWORD', ''); 
    $DB_SERVER = 'localhost';
    $DB_DATABASE = 'app-db';

edited Dec 23, 2022 at 9:57

spazmantiz

592 silver badges4 bronze badges

answered Mar 16, 2019 at 12:14

Hipodupa

334 bronze badges

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

1 Comment

androidYS Over a year ago

yes it is on the root is without password. I managed to connect using any other option. and thanks for the tip

Collectives™ on Stack Overflow

php- Unable to connect to database with PDO

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related