MySQL Database Installation Error

IMC version: 20240409_H3C_iMC_PLAT_7.3__E0710_Professional

Version_MySQL: 8.0

OS Windows Server 2019 

When installing MySQL, the following error occurs when the page leads to a confirmation of the installation summary and then clicks Install.

Begin to install database and data...

    --------------------------------

    Begin to create config_db foreground tables and data...

ERROR 1118 (42000) at line 1441: Row size too large.

The maximum row size for the used table type, not counting BLOBs, is 65535.

This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs

unzip :script/plat_db_mysql_v7r1b06d28tov7r1b06d28sp01_en.sql

After the installation of MySQL Server is completed, the configuration file my.ini of MySQL, which determines the functionality and performance of MySQL, will be automatically generated under the Data Path (default is C:\ProgramData\MySQL\MySQL Server 8.0\) that was set during the installation of MySQL Server. 

Some of the parameters in the automatically generated my.ini file cannot meet the requirements of iMC, so you need to change the my.ini file.

You can refer to the linked documentation, you need to change the [Client],[mysql],[mysqld] parameter

a.     ‍Under [client] , Add the parameter loose-local-infile=1.

b.     Under [mysql], change the value of the default-character-set parameter to match your operating system language. This example uses latin1. If you change the character after IMC has been deployed, you must reinstall IMC and add the parameter local_infile=1.

c.     Under [mysqld], make the following changes:

-     Add the parameter lower_case_table_names=1.

-     Change the value of the character-set-server parameter to latin1.

-     Change the value of the innodb_buffer_pool_size parameter to 512M.

-     Change the value of the innodb_strict_mode parameter to 0.

-     Change the value of the max_allowed_packet parameter to 200M.

-     Change the value of the max_connections parameter to 600.

-     Add the parameter default-time-zOne= '+8:00'.

-     Add the parameter local_infile=1.

Configuring MySQL parameters

Just save the my.ini configuration file after modification and replace the my.ini file in the original path.