Setup method of MariaDB database environment in Windows Server 2016 Server Configuration Guide

Updated: August 05, 2017 23:07:32 Author: Miao Zhenghui

This article mainly introduces the MariaDB database environment construction method of Windows Server 2016 server configuration guide, the need of friends can refer to the next

MariaDB is fully compatible with Mysql and provides even better performance. And MariaDB is maintained by the open source community, using the GPl protocol, in the current prevalence of IOE, MariaDB instead of Mysql is the trend of The Times!

MariaDB 10.1 has the new features of Mysql 5.7, MariaDB 10.0 has the new features of Mysql 5.6, and MariaDB 5.5 corresponds to Mysql 5.5, roughly so.

If your VPS disk is SSD-based, you will get better performance with MariaDB 10.1.

Note: Database application comparison is memory intensive software, may crash due to insufficient memory, it is recommended to set virtual memory first. Tutorial: Setting up virtual memory

Download and install the runtime If you already installed it when you installed PHP, you do not need to install it again. x64 has a 64-bit runtime and x86 has a 32-bit runtime.

32-bit download: https://download.microsoft.com/download/9/3/F/93FCF1E7-E6A4-478B-96E7-D4B285925B00/vc_redist.x86.exe 64 downloads: https://download.microsoft.com/download/9/3/F/93FCF1E7-E6A4-478B-96E7-D4B285925B00/vc_redist.x64.exe

Download MariaDB The download address of MariaDB 10.1.11 is listed here:

64 http://mirrors.ustc.edu.cn/MariaDB//MariaDB-10.1.11/winx64-packages/MariaDB-10.1.11-winx64.msi 32 bits http://mirrors.ustc.edu.cn/MariaDB/MariaDB-10.1.11/win32-packages/MariaDB-10.1.11-win32.msi

Alibaba Cloud Intranet:

64 http://mirrors.aliyuncs.com/MariaDB//MariaDB-10.1.11/winx64-packages/MariaDB-10.1.11-winx64.msi 32 bits http://mirrors.aliyuncs.com/MariaDB/MariaDB-10.1.11/win32-packages/MariaDB-10.1.11-win32.msi

Install MariaDB

安装MariaDB

Here we just need to install MariaDB Server, everything else x.

选择组件

Use the following image, enter the root password, and select according to the comments and requirements
选择功能

And then? All default here.

全部默认

Whether to feedback information, according to your preferences can be chosen.

是否反馈信息，根据喜好选择即可。

Then it started to install ~

开始安装 MariaDB 了

After the installation, the following software is available

安装好后，一共有如下软件

Test open MySQL Client and enter the root password, you can log in, and use the command line to operate MariaDB ~

测试登入

Articles you may be interested in:

How to successfully install MariaDB in CentOS 7

This article mainly introduces the successful installation of MariaDB in CentOS 7 method tutorial, the text through the graphic introduction is very detailed, we have a certain reference value, the need for friends can refer to learn, the following to learn together.
2017-04-04
CMake Error at MariaDB

This article mainly introduces the following errors when installing MariaDB today, but I have installed the libaio-devel library, the need of friends can refer to it
2014-12-12
Details Centos uses YUM to install MariaDB

This article mainly introduces the details of Centos using YUM to install MariaDB related information, need friends can refer to the next
2015-09-09
About mongoose connection mongodb repeated access error solution

This article mainly introduces the relevant information about the solution of mongoose's repeated access to mongodb, and the friends who need it can refer to it
2016-01-01
Example of Mariadb database master/Slave replication synchronization configuration process

This article mainly introduces the detailed explanation of the master/slave replication synchronization configuration process of Mariadb database. If you need it, you can use it for reference. I hope it can be helpful
2022-11-11
Error 28663 Cannot start the MongoDB server is reported

Today, when learning mongoDB, start always failed, search for a long time to find this document to solve the problem, is the engine problem, the need of friends can refer to
2020-02-02
Analysis of MariaDB database installation and system initialization operation for Windows 7

This article mainly introduces the Windows7 installation MariaDB database and system initialization operations, a concise analysis of the Windows7 platform to install mariadb database steps, configuration methods and related precautions, the need of friends can refer to the next
2018-05-05
Example description of installing MariaDB database in Linux

This article mainly introduces the Linux installation MariaDB database example detailed explanation, this article gives you a very detailed introduction to everyone's study or work has a certain reference value, the need of friends can refer to the next
2020-11-11
MySQL branch selection reference: Percona or MariaDB

This article mainly introduces the reference of MySQL branch selection: Percona or MariaDB. This article explains the background knowledge of Percona and MariaDB respectively, and gives a reference for the selection of using them
2015-03-03
MariaDB configures the dual-master replication scheme

The more common replication architectures in MySQL replication include "one master and one slave", "one master and multiple slaves", "double master", "multi-level replication" and "multi-master ring mechanism", etc. Today, we will discuss in detail the scheme of MariaDB configuration of dual master replication
2017-03-03