Test database connection in php without username & password

Question

There are some nice php database connection tests around, but they all seem to require a username & password. How would one confirm (using php and presumably mysqli) that a database server is up and would accept connections should one be attempted with a correct username & password, but report some details on the failure if the server was down or timed out or what not.

Look for a difference in the error message. If the server is offline you'll get a different error message when trying to connect than you will if it's there but it doesn't recognise the credentials. Or you could just try and telnet to the port. — ADyson
– ADyson, Commented Dec 12, 2020 at 17:23
I have to say this is a rather strange requirement. Credentials are set up by the system administrator so if your access is denied then it means the server is not reachable from your POV. — Dharman
– Dharman ♦, Commented Dec 12, 2020 at 17:30

Jimmy · Accepted Answer · 2020-12-12 19:13:36Z

3

I would use the code 1045 to see if you can connect. This error code indicates that the credentials are incorrect. If the server responds with that code then it means it is reachable.

<?php

$reachable = false;

mysqli_report(MYSQLI_REPORT_ERROR | MYSQLI_REPORT_STRICT);
try {
    $mysqli = new mysqli('localhost', 'some invalid user', 'wrong password');
} catch (mysqli_sql_exception $e) {
    if (1045 === $e->getCode()) {
        $reachable = true;
    }
}

var_dump($reachable);
?>

edited Dec 12, 2020 at 19:13

Jimmy

5,26110 gold badges57 silver badges83 bronze badges

answered Dec 12, 2020 at 17:28

Dharman♦

34k27 gold badges106 silver badges158 bronze badges

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

Collectives™ on Stack Overflow

Test database connection in php without username & password

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related