MariaDB Server installation and configuration—Windows
•I. Install the MariaDB Server
•II. Configure the MariaDB Server
•III. Install the MariaDB ODBC Connector
I. Install the MariaDB Server
|
For more details, see Installing MariaDB MSI Packages on Windows. |
1.Download the MariaDB Server installer for Windows and execute it.
|
Ensure to install a supported database server and connector version. |
2.Click Next.
3.Select the check box I accept the terms in the License Agreement and click Next.
4.Optional: In the Custom Setup window, you can customize the installation. Click Next.
5.Keep the check box Modify password for database user root selected, type the root password twice and click Next.
|
Save the root password—you will need it during the ESET PROTECT Server installation (see the installation steps on Windows or Linux). |
6.Optional: In the Default instance properties, you can adjust the database configuration. Click Next.
7.Click Install and wait until the installation completes. Click Finish to close the installation window.
Follow the steps below to configure the MariaDB Server.
II. Configure the MariaDB Server
1.Open the following file in a text editor:
C:\Program Files\MariaDB 11.8\data\my.ini
2.Find and edit or append the following configuration in the [mysqld] section of the my.ini file:
Parameter |
Description |
|||
|---|---|---|---|---|
max_allowed_packet=33M |
|
|||
innodb_log_file_size=100M innodb_log_files_in_group=2 |
The multiplication of values of these two parameters must be at least 200. The minimum value for innodb_log_files_in_group is 2 and maximum value is 100; the value also must be integer. |
3.Save and close the my.ini file.
4.Open the Command Prompt and type the following commands to restart the MariaDB Server and apply the configuration (the service name may differ, depending on the installation):
net stop mariadb
net start mariadb
5.Type the following command in Command Prompt to check whether the MariaDB Server is running:
sc query mariadb
Follow the steps below to install the MariaDB ODBC Connector.
III. Install the MariaDB ODBC Connector
|
Ensure to install a supported database server and connector version. |
1.Download the MariaDB ODBC Connector for Windows installer and execute it.
2.Click Next.
3.Select the check box I accept the terms in the License Agreement and click Next.
4.In the Choose Setup Type window, select Typical.
5.Click Install and wait until the installation completes. Click Finish to close the installation window.