MySQL Server installation and configuration

Installation

validation-status-icon-error WARNING

MySQL database is supported up to version 5.7 and ODBC driver up to version 5.3.10. Upgrading to a higher version (5.3.11 or 8.x) of MySQL and ODBC driver is not recommended.

The ESMC Virtual Appliance is running ODBC 8.0.11-el7. From the 8.x versions, only this version is proven to be compatible with the ESMC. Major Linux distributions do not provide this version in their repository.

1.Download the MySQL 5.7 (or older) Windows installer from https://dev.mysql.com/downloads/windows/installer/5.7.html and execute it.

2.During the installation setup, select Custom > MySQL Server to install.

mysql_component

3.Complete the installation of MySQL Server.

4.Download and install Microsoft Visual C++ 2010 Redistributable Package (a prerequisite for ODBC Connector 5.2). Make sure it matches the bitness of the installed MySQL Server: 32-bit or 64-bit.

5.Download the ODBC Connector 5.2 (or older) Windows Installer from https://dev.mysql.com/downloads/connector/odbc/5.2.html and install it. Make sure it matches the bitness of the installed MySQL Server.

Configuration

Open the following file in a text editor:

C:\ProgramData\MySQL\MySQL Server 5.7\my.ini

Find and edit or append the following configuration into the [mysqld] section of the my.ini file:

max_allowed_packet=33M

For MySQL 5.6.20 and 5.6.21 (you can determine your MySQL version by using mysql --version):

oinnodb_log_file_size needs to be set to at least 200 MB (for example innodb_log_file_size=200M), but not more than 3000 MB

For MySQL 5.6.22 and later:

oinnodb_log_file_size*innodb_log_files_in_group needs to be set to at least 200 MB (* denotes multiplication, the product of the two parameters must be > 200 MB. The minimal value for innodb_log_files_in_group is 2 and maximum value is 100, the value also has to be integer).
For example:
innodb_log_file_size=100M
innodb_log_files_in_group=2

Save and close the file and enter the following command to restart the MySQL server and apply the configuration (the process name depends on the version of MySQL, version 5.7 = MySQL57 etc.):

net stop mysql57

net start mysql57

Enter following command in Command Prompt to check whether the MySQL server is running:

sc query mysql57