服务器选择- MySQL / MariaDB

Question

我有两个数据库服务器，MySQL和MariaDB，当我试图连接到MySQL服务器上的本地数据库时，我总是收到“连接失败: SQLSTATEHY000未知数据库'ruff'”的消息。我发现，我的代码是连接到MariaDB服务器，而不是MySQL。我可以创建并连接到MariaDB上的任何数据库。

如何连接到MySQL服务器数据库？

我的代码是：

// Creating a connection
$conn = new mysqli($servername, $username, $password);
// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}
// Creating a database named $dBName
$sql = "CREATE DATABASE $dBName";
if ($conn->query($sql) === TRUE) {
    echo "Database created successfully with the name newDB";
} else {
    echo "Error creating database: " . $conn->error;
}
// Connecting to database named $dBName
$conn = mysqli_connect($servername, $dBUsername, $dBPassword, $dBName);

if (!$conn)
{
    die("Connection fail: ".mysqli_connect_error());
}

// closing connection
$conn->close();

Answer 1

在localhost之后添加端口号解决了这个问题。

$servername = "localhost:3308"; //MySQL
$servername2 = "localhost:3306"; //MariaDB