PHP, Failed connecting to database

Wampserver 3.2.0 new instalation or upgrading

This might help others

Probably xamp using mariaDB as default too.

Wamp server comes with mariaDB and mysql, and instaling mariaDB as default on 3306 port.

To make mysql work!

On instalation it asks to use mariaDB or MySql, mariaDB is checked as default and you cant change it, check mysql option and install.

when instalation done both will be runing mariaDB on default port and mysql on another port.

Right click on wamp icon where its runing should be on right bottom corner, goto tools and see your mysql runing port.

And include in your database connection same as folowng :

$host = 'localhost';
$db   = 'test';
$user = 'root';
$pass = '';
$charset = 'utf8mb4';
$port = '3308';

$dsn = "mysql:host=$host;dbname=$db;port=$port;charset=$charset";
$options = [
    PDO::ATTR_ERRMODE            => PDO::ERRMODE_EXCEPTION,
    PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC,
    PDO::ATTR_EMULATE_PREPARES   => false,
];
try {
     $pdo = new PDO($dsn, $user, $pass, $options);
} catch (\PDOException $e) {
     throw new \PDOException($e->getMessage(), (int)$e->getCode());
}

Note : I am using pdo.

See here for more : https://sourceforge.net/projects/wampserver/