How to install MariaDB? Detailed tutorial on installation, use and configuration of mariadb10.5 database under Windows

Time:2020-11-19

MariaDB database management systemIt is an alternative database for MySQL. MariaDB is a logical choice for scalable and reliable SQL servers. MariaDB 10.5 is the current stable series of MariaDB.

PS: here it isOfficial installation version and decompression version of the tutorial diagramFor reference only, please refer to the operation steps of this article for detailed methods!

Software name:
MariaDB 10.5.5 stable official 32-bit for windows
Software size:
45.7MB
Update time:
2020-08-21Download now
Software name:
MariaDB 10.5.5 (database management) stable official latest installation 64 bit
Software size:
50.3MB
Update time:
2020-08-21Download now

Installation tutorial

1. Download the software, double-click to run mariadb-10.5.5-winx64.msi

2. Click I accept… To accept the license agreement

3. Select the component and software installation path

4. Set the password for the database

5. Default next step

6. Click Install to install

7. After installation, the icon will be generated on the desktop

How to use the green decompression version

Software name:
5.5-bit official database management
Software size:
53.5MB
Update time:
2020-08-21Download now
Software name:
MariaDB (database management system) v10.5.5 32-bit official green decompression Version (with tutorial)
Software size:
48.1MB
Update time:
2020-08-21Download now

PS: Download and unzip to a directory, pay attention to the path is English, otherwise affect the use!

My is not available in the latest decompression version- huge.ini 、my-innodb-heavy-4G.ini、my- large.ini 、my- medium.ini 、my- small.ini 5 files, installation is also easier, can automatically generate configuration files

1. Enter CMD in the start menu, right-click to run as an administrator. After running, CD the execution directory to bin directory in your decompression directory, and select the required software version. Take 64 bit as an example

Enter D: enter

Enter CD D: 360downloads / mariadb-10.5.5-winx64 / mariadb-10.5.5-winx64 / bin

Input mysqld.exe –install MariaDB

You can see “successfully installed”

2. Create a new data directory in the MariaDB installation directory and enter mysql_ install_ db.exe Initialize (the data directory is the “working directory” by default, otherwise the service cannot be started)

3. Start service: Net start MariaDB

Service added successfully

4. Enter MySQL – uroot to log in to the database (the first login password is blank, do not need to input). After logging in, switch the database: use mysql, and set the password: update user set password = password (“root”) where user = root;
If the setting is successful, a prompt will appear

5. Log out: quit restart service password takes effect:
net stop mariaDB
net start mariaDB

6. The default codes of MariaDB are GBK and Latin1, which are modified to utf8mb4.
After logging in, enter the MySQL database: use mysql, execute the command: Show variables like ‘character%’, and query the character codes of all attributes of the current MySQL database

Execute the following command to modify:

MariaDB [mysql]> set character_set_client=‘utf8mb4’; ;
Query OK, 0 rows affected (0.000 sec)

MariaDB [mysql]> set character_set_connection=‘utf8mb4’;
Query OK, 0 rows affected (0.000 sec)

MariaDB [mysql]> set character_set_database=‘utf8mb4’;
Query OK, 0 rows affected (0.000 sec)

MariaDB [mysql]> set character_set_results=‘utf8mb4’;
Query OK, 0 rows affected (0.000 sec)

MariaDB [mysql]> set character_set_server=‘utf8mb4’;

Query again after modification: Show variables like ‘character%’;

The results are shown in the figure

The above tutorial and the latest configuration of windows is only for reference! Welcome to follow other software tutorial information of developeppaer!