Mysql - PDO Error - Invalid catalog name: 1046 No database selected

Question

I have a problem with PDO, and I see absolutely no where he come. I can not question my MySQL database. Just to test I used the following code (having quite sour previously configured the parameters for the connection: ``` $dbh= new PDO('mysql:host=serverName;dbname=Mydatabase','user','password'); $dbh->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); var_dump($dbh); // gives : object(PDO)#1 (0) { } $res=$dbh->query('SELECT * FROM table'); ``` The connection is made correctly with MySQL but after query I get this error: Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[3D000]: Invalid catalog name: 1046 No database selected' in /home/outout/public_html/file.php:16 Stack trace: #0 /home/outout/public_html/file.php(16): PDO->query('select * from t...') #1 {main} thrown in /home/outout/public_html/file.php on line 16. The code works on a local machine, but as soon as I put it online (cPanel) it shows me this error. Do I have to configure PDO in .htaccess? I ab…

Accepted Answer

You made some mistake or a typo. Make sure that database exists on the server you are connecting to and correctly set in the DSN like this

```
dbname=Mydatabase;
```

without spaces or other symbols. Character case is also important.

```
$dbh = new PDO('mysql:host=serverName;dbname=Mydatabase;charset=utf8mb4','user','pass');
```

should work

Mysql - PDO Error - Invalid catalog name: 1046 No database selected

Solution

Problem