Summary of MariaDB database installation in Windows

Today, we need to install a database named MariaDB in windows because of our work. I am not familiar with this database, So Baidu has found two methods. Let's share the following.

Method 1: It looks simple, but it is not installed successfully.

1. Download MariaDB from the official website
Address: https://downloads.mariadb.org/

Ii. Installation
1. decompress the package.
2. unzip the directory to see the 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 sub-memory select one of them COPY to C: Windows directory, and modify the name to my. ini.
3. Open my. ini and add
[WinMySQLAdmin]
Server = D:/dev/mariadb/bin/mysqld.exe
User = root
Password = mariadb
[Mysqld]
Basedir = decompressed path
Datadir = decompressed path/data

3. add and delete a service
1. CMD, switch to MariaDB, decompress the package, and run "mysqld -- install yourservicename ".
2. CMD, SC deleteyourservicename.

Iv. System Error 1076
When the service is started, "system error 1076" is displayed. Find "host name. err" in the path/data directory after MariaDB unzipping, and then find the cause.

5. Modify the ROOT password
CMD, switch to MariaDB, decompress the package, and run "mysql-uroot-p" to switch to MariaDB mode, run "set password for 'root' @ 'localhost' = PASSWORD ('new password.

Method 2: Detailed installation method with images

Note:

MariaDB is an open-source MySQL-based database that is compatible with MySQL. The existing MySQL database can be migrated to MariaDB for use.

Download MariaDB:

32-bit: http://mirrors.hustunique.com/mariadb/mariadb-5.5.33a/win32-packages/mariadb-5.5.33a-win32.msi

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

Operating System:32-bit Windows Server 2003

MariaDB version:Mariadb-5.5.33a (latest stable version)

Install MariaDB

Open the mariadb-5.5.33a-win32.msi installation file, as shown in

Next

Check I accept the terms in the License Agreement

Accept the terms in the license agreement

Next

Select to install all components

Click Browse... to Browse and modify the MariaDB installation directory.

Modify it to C: MariaDB 5.5

Next

Check Modify password for database user "root"

Set the root password of the MariaDB database account

Enable access from remote machines

Prohibit remote access to the MariaDB database. You can only connect to MariaDB locally

The Create An Anonymous Account option is deselected by default.

Prohibit new anonymous users from accessing MariaDB

Check Use UTF8 as default server's charater set

MariaDB uses UTF-8 encoding by default.

Next

Select Install as service to Install the service

Service Name: MySQL

The default service name of the MariaDB database is MySQL.

Enable networking

TCP port: 3306

MariaDB uses TCP port 3306 by default.

Optimize for transactions is selected by default.

Buffer pool size: 1022

The default cache is 12.5% of the memory size, and the 32-bit MariaDB has a maximum cache capacity of 1 GB.

Uncheck Enable the Feedback plugin and submit amonymous usage information

Disable feedback and submit usage information

Next

Install

Installing

Finish Installation

MariaDB 5.5 is displayed in the Start Menu.

As shown in

Open MySQL Client (MariaDB 5.5) and enter the root password set above to log on, as shown in

Open HeidiSQL, as shown in

Click Add, as shown in

Enter the root user password and click open, as shown in. The MariaDB Management page is displayed.

Open the MariaDB installation directory C: MariaDB 5.5 and you can see that the directory structure is consistent with that of MySQL!

Now, MariaDB is installed in Windows!