Cara Instalasi MariaDB di Windows 10

Unduh Installer MariaDB

https://downloads.mariadb.org/mariadb/10.4.11/

Instalasi MariaDB

Double click file mariadb-10.4.11-winx64.msi


Klik "Next"


Klik "Next"


Klik "Next"



Masukkan password database untuk root yang anda inginkan, misal: root.
Celist pada Use UTF8 as default server's character set.

Klik "Next"


Klik "Next"


Klik "Next"


Klik "Install"

Klik "Yes" pada jendela alert yang muncul "Do you want to allow this app to make changes to your device".


Tunggu proses instalasi yang berlangsung.


Klik "Finish" untuk mengakhiri.

Testing

Silahkan buka Command Prompt, ketik:

mysql -u root -p

Ketikkan password yang anda buat saat instalasi.


Buat file baru di dalam D:\Sites

<?php
$mysqli = new mysqli("localhost","root","root","test");

// Check connection
if ($mysqli -> connect_errno) {
  echo "<h2>Failed to connect to MySQL: " . $mysqli -> connect_error . "</h2>";
}else{
 echo "<h2>Connection has been successful</h2>";
}

?>

Simpan dengan nama testdb.php.
Buka web browser, kemudian ketik: localhost/testdb.php