PHP Does not show errors when trying to connect to a wrong database using PDO

Question

I'm pretty much new to PHP and I'm having a very basic problem which I haven't found a solution to despite looking through similar questions in the forum.

I'm trying to connect PHP with my database (MySQL) through PDO. If I enter a wrong username or password php does show an error in the browser but if I enter a wrong database name it doesn't retireve any errors. How is this possible? My code is as follows:

<?php
try{
    $conn = new PDO('mysql:127.0.0.1;dbname=myDb','root','root');
    $conn -> setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
} catch(PDOexception $e){
    echo 'wrong credentials';
}

My php.ini file is configured to show errors and Apache was restarted after modifying it with the following values:

error_reporting  =  E_ALL | E_STRICT
display_errors = On
display_startup_errors = On
log_errors = On

I also tried to use the following code at the begining of my script but it still doesn't show errors related to a wrong database name

ini_set('display_errors', 1);
error_reporting(~0);

Thanks a lot in advance for your help, I'm sure is probably a pretty stupid thing but I honestly can't figure it out.

What does $conn->errorInfo() show you?

Tim Biegeleisen
– Tim Biegeleisen

2015-04-15 01:06:59 +00:00
Commented Apr 15, 2015 at 1:06 — Tim Biegeleisen
– Tim Biegeleisen, Commented Apr 15, 2015 at 1:06
Have you tried looking in the Apache error log?

Itay Moav -Malimovka
– Itay Moav -Malimovka

2015-04-15 01:43:08 +00:00
Commented Apr 15, 2015 at 1:43 — Itay Moav -Malimovka
– Itay Moav -Malimovka, Commented Apr 15, 2015 at 1:43
@RyanVincent Please go ahead and post this as the answer.

Tim Biegeleisen
– Tim Biegeleisen

2015-04-15 04:05:35 +00:00
Commented Apr 15, 2015 at 4:05 — Tim Biegeleisen
– Tim Biegeleisen, Commented Apr 15, 2015 at 4:05

Ryan Vincent · Accepted Answer · 2018-06-22 12:52:40Z

4

This turned into quite a tricky bug to find and explain even though it is quite simple.

The issue is that the dsn string is incorrect.

current value: 'mysql:127.0.0.1;dbname=myDb'

it should be: 'mysql:host=127.0.0.1;dbname=myDB' note: host= was missing.

However, PDO does not validate the dsn parameter string correctly and connects to the Localhost database without any error.

However, it has ignored the dbname parameter, so that when you try a query then you get an error of: 1046 No database selected'.

Clarification of what is happening (see Alfredo Delgado below): PDO is ignoring the malformed parameter completely and assuming the Localhost database is what you want. ;-/

As mentioned by Alfredo Delgado:

... "the resulting behavior of not having host= in the dsn was that PDO was silently defaulting to localhost. Since I happened to have a local copy of the DB I wasted hours chasing down red herrings like permissions."

edited Jun 22, 2018 at 12:52

answered Apr 15, 2015 at 4:16

Ryan Vincent

4,5137 gold badges24 silver badges33 bronze badges

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

11 Comments

Ryan Vincent Over a year ago

This is also related to 'other issues' with PDO as regards 'PDO::ATTR_EMULATE_PREPARES, false'. It stops exceptions being raised with certain versions of PHP and PDO. I need to check the later versions. see

Alfredo Delgado Over a year ago

I ran into this, today. The resulting behavior of not having host= in the dsn was that PDO was silently defaulting to localhost. Since I happened to have a local copy of the DB I wasted hours chasing down red herrings like permissions.

Ryan Vincent Over a year ago

@AlfredoDelgado, you have my sympathy. ;-/ As the error report is incorrect it really is an amazing 'timesink' trying to find and explain what is actually wrong. .Updated the answer.

Klem Lloyd Mwenya Over a year ago

@RyanVincent, yes I do have 'spaces', but are spaces regarded in those particular places in PHP programing?

Klem Lloyd Mwenya Over a year ago

@RyanViçeñte, oh yes I can access database from PHPMyAdmin!

|

Collectives™ on Stack Overflow

PHP Does not show errors when trying to connect to a wrong database using PDO

1 Answer 1

11 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

11 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related