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.

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

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

mysql_component

Download the ODBC Connector 5.2 (or older) Windows Installer from https://dev.mysql.com/downloads/connector/odbc/5.2.html and install it.

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)

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:
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