10 March 2022

How To Install Mariadb 10.5 On Windows 10

Mariadb version 10.05 is now available. It is open-source and free database server, and many hosting provider love using it. I want to install mariadb on my pc with windows 10 installed. I can install wordpress, then install wordpress plugins and wordpress themes locally before install theme on live hosting.

Why you need mariadb server? Because it can store your wordpress-powered blog data. Nowadays many hosting provider and blogger prefer using mariadb server to mysql server to store their wordpress data.

Install Mariadb On Windows 10

To install mariadb server on windows pc:

1. Download mariadb windows installer from their site https://downloads.mariadb.org. And double click on it.

2. Click on the "next" button.

Install Mariadb On Windows 10

3. You must check "I accept the terms in the Licence Aggreement" box, then click on "next" button

Install Mariadb On Windows 10

4. To use the default installation procedure, click on "next" button.

Install Mariadb On Windows 10

5. Create password. Example: 1234. Then click "next" button.

Install Mariadb On Windows 10

6. Create Service Name. Example: MariaDB1050. And for the TCP port, I use 3309 for the example. Then click on "next" button.

Install Mariadb On Windows 10

7. Wait a minutes. The installation process is running. When it is complete, you will see a pop up that tell you the installation of mariadb server is done.

Install Mariadb On Windows 10

Login Into Mariadb Server

In the windows search box, type mariadb. If the mariadb app show up, double click on it and type the password you have just created. Press enter.

Install Mariadb On Windows 10

Create database

To create database :

CREATE DATABASE wpblog;

Delete database

To delete database :

DROP DATABASE wpblog;

Backup the database

To backup database:

"C:\Program Files\MariaDB 10.5\bin\mysqldump.exe" --host=localhost --port=3309 --user=root --password wpblog > wpblog.sql

Restore the database

To restore database:

"C:\Program Files\MariaDB 10.5\bin\mysql.exe" --host=localhost --port=3309 --user=root --password wpblog < wpblog.sql

Comments are closed