MySQL Server installation and configuration


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.

Download the MySQL 5.7 (or older) Windows Installer from and execute it.

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


Download the ODBC Connector 5.2 (or older) Windows Installer from and install it.


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:


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)

For MySQL >= 5.6.22:

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 maximal value is 100, the value also has to be integer)
For example:

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