服务器选择-MySQL/MariaDB

Question

我有两个数据库服务器，MySQL和MariaDB，当我试图在MySQL服务器上连接到我的本地数据库时，我总是得到"Connectionfailed:SQLSTATE[HY000][1049]未知数据库'ruf'"。我发现，我的代码正在连接到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

在本地主机解决问题后添加端口号。

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