Summary of installing MARIADB databases under Windows

Method One, looks very simple but did not install successfully, then some method two

First, the official website download mariadb
Address: https://downloads.mariadb.org/

Second, the installation
1. Decompression.
2. After decompression in the directory to see My-huge.ini, My-innodb-heavy-4g.ini, My-large.ini, My-medium.ini, My-small.ini 5 files, according to the size of the memory select one copy to C : Windows directory, and modify the name for My.ini.
3. Open My.ini, add
[Winmysqladmin]
Server=d:/dev/mariadb/bin/mysqld.exe
User=root
Password=mariadb
[Mysqld]
Basedir= after decompression path
Datadir= after decompression path/data

Third, add Delete service
1.CMD, switch to MARIADB after decompression path/bin, execute "mysqld--install yourservicename".
2.CMD,SC Deleteyourservicename.

Iv. System Error 1076
A "system error 1076" was encountered while starting the service, and the reason was found in the/data directory under mariadb decompression path, "host name. Err".

V. Modify the root password
CMD, switch to MARIADB after decompression path/bin, perform "mysql-uroot-p" switch to MARIADB mode, then execute "SET PASSWORD for ' root ' @ ' localhost ' = PASSWORD (' new password ');", Can.

method Two, with a detailed picture installation method

Description

MARIADB is an Open-source database based on MySQL, compatible with MySQL, the existing MySQL database can be migrated to mariadb use

MARIADB Download:

32 digits:Http://mirrors.hustunique.com/mariadb/mariadb-5.5.33a/win32-packages/mariadb-5.5.33a-win32.msi

64 digits:http://mirrors.scie.in/mariadb/mariadb-5.5.33a/winx64-packages/mariadb-5.5.33a-winx64.msi

Operating System: Windows Server 2003 32-bit

mariadb Version: mariadb-5.5.33a(current stable version)

Install MARIADB

Open the Mariadb-5.5.33a-win32.msi installation file as shown in the following illustration

Next

Tick I accept the terms in the License agreement

Accept the terms of the license agreement

Next

Choose to install all components

Click to browse ... Browse, modify MARIADB installation directory

Modified here as:c:mariadb 5.5

Next

Tick Modify Password for database user "root"

Set the password for the MARIADB database account root

Default does not tick Enable access from remote machines for

Remote access to the MARIADB database is prohibited and can only be connected locally mariadb

Default does not tick Create an Anonymous account

Disable new anonymous user access mariadb

Tick Use UTF8 as default server ' s Charater set

MARIADB by default using UTF8 encoding

Next

Tick Install as Service installation service

Service Name:MySQL

MARIADB database default service name is MySQL

Tick Enable Networking to open Network

TCP port:3306

The MARIADB database uses the TCP 3306 port by default

Default checkmark Optimize for transactions

Buffer Pool size:1022

The default cache is 12.5% of memory size, and the 32-bit version of MARIADB limits the maximum cache to 1GB

No tick Enable the Feedback plugin and submit amonymous usage information

Prevent feedback and submit usage information

Next

Install Installation

Being installed

Finish installation Complete

At the Start menu you can see MARIADB 5.5

As shown in the following figure

Open the MySQL Client (mariadb 5.5) and enter the root password login set above, as shown in the following figure

Open Heidisql, as shown in the following figure

Dot new, as shown in the following figure

Enter the root user password, click Open, as shown in the following figure, into the MARIADB management interface

Open MARIADB installation directory C:MARIADB 5.5 can see the same structure as the MySQL directory!

At this point, MARIADB is installed under Windows!