$server = "localhost";
$username = "xyz";
$password = "passw0rd";
$sdosmsDB = "test";

$conn = new PDO("mysql:host=$server; dbname=$sdosmsDB", $username, $password);
    $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
    $conn->exec("SET CHARACTER SET utf8");

} catch(PDOException $e) {

    die( 'Database Connection failed: ' . $e->getMessage());

}

CREATE USER xyz@localhost IDENTIFIED WITH mysql_native_password BY 'passw0rd'