MySQL Server installation and configuration
Installation
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.
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