I have two database servers, MySQL and MariaDB, when I’m trying to connect to my local database on MySQL server, I always get “Connectionfailed: SQLSTATE[HY000] [1049] Unknown database ‘ruff'”. I found out, that my code is connecting into MariaDB server instead of MySQL. I can CREATE and CONNECT to any database on MariaDB.
How can I connect to MySQL server databases?
My code is:
JavaScript
x
// 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();
Advertisement
Answer
Adding port number after the localhost solved the problem.
JavaScript
$servername = "localhost:3308"; //MySQL
$servername2 = "localhost:3306"; //MariaDB