General Description
MySQL—cross-platform relational databases management system. MySQL DBMS may be used as an external DB for Dr.Web Enterprise Security Suite.
To use MySQL as an external database
1.Install the MySQL server.
2.Set up Dr.Web Server to use the respective external database. You can do this in configuration file or via Dr.Web Security Control Center: in the Dr.Web Server configuration menu, the Database tab.
Installation and Supported Versions
Dr.Web Enterprise Security Suite supports the following versions of MySQL DBMS:
•MySQL—all versions starting from 8.0.12,
|
Make sure that for user connecting to MySQL version 8.X the athentication type is caching_sha2_password. This parameter is set during the installation and becomes the default one for every user, or it is manually configured for every user. |
•MariaDB—10.2.2, 10.3, 10.4.
After DBMS installation, before creating a new database, it is necessary to specify the following settings in its configuration file (see your DBMS documentation for more details):
For MySQL of 8.Х versions:
[mysqld] innodb_file_per_table = true max_allowed_packet = 64M |
If the used DBMS MariaDB has version earlier than 10.2.4, when you also must set the following in the configuration file:
binlog_format = mixed |
Parameters
To adjust access to the MySQL DBMS, use the parameters described in Table below.
Parameters of the MySQL DBMS
Name |
Default value |
Description |
HOST |
localhost |
•Database server address—when connecting to database via TCP/IP. •Path to UNIX socket file—when using UDS. If not set, Dr.Web Server tries to locate the file in one of standard mysqld directories. |
PORT |
3306 |
•Connection port number—when connecting to database via TCP/IP. •UNIX socket file name—when using UDS. |
DBNAME |
|
Database name |
USER |
|
Registration name of database user |
PASSWORD |
QUICK |
Database user password |
PRECOMPILEDCACHE |
1048576 |
Cache size of precompiled sql operators (in bytes) |
SSL |
NO |
Allow SSL connections only: •YES—connect to database only if SSL protocol is used, •NO—SSL protocol is not necessary to connect to database. |