在winserver2012R2上使用mysql数据库，IMC安装失败

Begin to install database and data...

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

 Begin to create config_db database... 

mysql: [Warning] Using a password on the command line interface can be insecure

mysql: [Warning] Using a password on the command line interface can be insecure. 

mysql: [Warning] Using a password on the command line interface can be insecure. 

 End to create config_db database.

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

 Begin to create config_db table... 

mysql: [Warning] Using a password on the command line interface can be insecure. 

mysql: [Warning] Using a password on the command line interface can be insecure. 

mysql: [Warning] Using a password on the command line interface can be insecure. 

mysql: [Warning] Using a password on the command line interface can be insecure. 

mysql: [Warning] Using a password on the command line interface can be insecure. 

 End to create config_db table. -- -- -- -- -- -- -- -- -- -- -- -- -- -- - Begin to install config_db data... mysql: [Warning] Using a password on the command line interface can be insecure. ERROR 1366 (HY000) at line 180: Incorrect string value: '\xC9\xE8\xB1\xB8\xC9\xCF...' for column 'para_desc' at row 1 

详细报错：

 2021-11-29 18:37:37 [INFO ] [ActiveMQ Session Task-1] [com.h3c.imc.deploy.dma.AgentMessageHandler::masterConnectStateChanged(1083)] Receive master state change message: Connected 

2021-11-29 18:37:37 [INFO ] [AWT-EventQueue-0] [com.h3c.imc.deploy.dma.ComponentDeployInfo::isComponentsConformable(622)] Components conformable check failed: no component deployed

 2021-11-29 18:37:37 [INFO ] [AWT-EventQueue-0] [com.h3c.imc.deploy.dma.ComponentDeployInfo::isComponentsConformable(622)] Components conformable check failed: no component deployed 

2021-11-29 18:37:37 [INFO ] [AWT-EventQueue-0] [com.h3c.imc.deploy.dma.ComponentDeployInfo::isComponentsConformable(622)] Components conformable check failed: no component deployed

 2021-11-29 18:37:40 [INFO ] [main] [com.h3c.imc.deploy.install.InstallationComponentInfo::resolveResource(437)] 开始获取%iMC.dm 

2021-11-29 18:37:40 [INFO ] [main] [com.h3c.imc.deploy.install.InstallationComponentInfo::resolveResource(437)] 开始获取%iMC.dm.description 

2021-11-29 18:37:40 [INFO ] [main] [com.h3c.imc.deploy.install.InstallationComponentInfo::resolveResource(437)] 开始获取%iMC.icc 

2021-11-29 18:37:40 [INFO ] [main] [com.h3c.imc.deploy.install.InstallationComponentInfo::resolveResource(437)] 开始获取%iMC.icc.description 

2021-11-29 18:37:41 [INFO ] [main] [com.h3c.imc.deploy.install.InstallationComponentInfo::resolveResource(437)] 开始获取%iMC.netasset 

2021-11-29 18:37:41 [INFO ] [main] [com.h3c.imc.deploy.install.InstallationComponentInfo::resolveResource(437)] 开始获取%iMC.netasset.description 

2021-11-29 18:37:41 [INFO ] [main] [com.h3c.imc.deploy.install.InstallationComponentInfo::resolveResource(437)] 开始获取%iMC.nme.fault 2021-11-29 18:37:41 [INFO ] [main] [com.h3c.imc.deploy.install.InstallationComponentInfo::resolveResource(437)] 开始获取%iMC.nme.fault.description 

2021-11-29 18:37:41 [INFO ] [main] [com.h3c.imc.deploy.install.InstallationComponentInfo::resolveResource(437)] 开始获取%iMC.nme.perf 

2021-11-29 18:37:41 [INFO ] [main] [com.h3c.imc.deploy.install.InstallationComponentInfo::resolveResource(437)] 开始获取%iMC.nme.perf.description 

2021-11-29 18:37:42 [INFO ] [main] [com.h3c.imc.deploy.install.InstallationComponentInfo::resolveResource(437)] 开始获取%iMC.plat 

2021-11-29 18:37:42 [INFO ] [main] [com.h3c.imc.deploy.install.InstallationComponentInfo::resolveResource(437)] 开始获取%iMC.plat.description 

2021-11-29 18:37:42 [INFO ] [main] [com.h3c.imc.deploy.install.InstallationComponentInfo::resolveResource(437)] 开始获取%iMC.report.plat 2021-11-29 18:37:42 [INFO ] [main] [com.h3c.imc.deploy.install.InstallationComponentInfo::resolveResource(437)] 开始获取%iMC.report.plat.description 

2021-11-29 18:37:42 [INFO ] [main] [com.h3c.imc.deploy.install.InstallationComponentInfo::resolveResource(437)] 开始获取%iMC.scc 

2021-11-29 18:37:42 [INFO ] [main] [com.h3c.imc.deploy.install.InstallationComponentInfo::resolveResource(437)] 开始获取%iMC.scc.description 

2021-11-29 18:37:42 [INFO ] [main] [com.h3c.imc.deploy.install.InstallationComponentInfo::resolveResource(437)] 开始获取%iMC.syslog 

2021-11-29 18:37:42 [INFO ] [main] [com.h3c.imc.deploy.install.InstallationComponentInfo::resolveResource(437)] 开始获取%iMC.syslog.description 

2021-11-29 18:37:42 [INFO ] [main] [com.h3c.imc.deploy.dma.wizard.DeployWizard$WizardData::parseTaskProperties(453)] Deploy component "iMC-PLAT" for the first time: true 

2021-11-29 18:37:44 [INFO ] [main] [com.h3c.imc.deploy.dma.wizard.WelcomePanelDescriptor::aboutToDisplayPanel(95)] data.isNeedSelectDatabase() is : true 

2021-11-29 18:37:44 [INFO ] [main] [com.h3c.imc.deploy.dma.wizard.WelcomePanelDescriptor::aboutToDisplayPanel(96)] data.isNeedInputWebServerPort() is : true 

2021-11-29 18:37:44 [INFO ] [main] [com.h3c.imc.deploy.dma.wizard.WelcomePanelDescriptor::aboutToDisplayPanel(97)] data.isNeedShowCustomPanels() is : false 

2021-11-29 18:37:44 [INFO ] [SwingWorker-pool-1-thread-1] [com.h3c.imc.deploy.dma.wizard.DatabaseSelectPanelDescriptor$DbConnectCheckingWorkingDialog::doWork(2237)] className:com.mysql.cj.jdbc.Driver 

2021-11-29 18:37:44 [INFO ] [SwingWorker-pool-1-thread-1] [com.h3c.imc.deploy.dma.wizard.DatabaseSelectPanelDescriptor$DbConnectCheckingWorkingDialog::doWork(2240)] URL: jdbc:mysql://127.0.0.1:3306/ 

2021-11-29 18:37:44 [INFO ] [SwingWorker-pool-1-thread-1] [com.h3c.imc.deploy.dma.wizard.DatabaseSelectPanelDescriptor$DbConnectCheckingWorkingDialog::doWork(2244)] password = {PROTECTED} 

2021-11-29 18:37:44 [INFO ] [SwingWorker-pool-1-thread-1] [com.h3c.imc.deploy.dma.wizard.DatabaseSelectPanelDescriptor$DbConnectCheckingWorkingDialog::doWork(2246)] allowPublicKeyRetrieval = true 

2021-11-29 18:37:44 [INFO ] [SwingWorker-pool-1-thread-1] [com.h3c.imc.deploy.dma.wizard.DatabaseSelectPanelDescriptor$DbConnectCheckingWorkingDialog::doWork(2246)] serverTimezOne= Asia/Shanghai 

2021-11-29 18:37:44 [INFO ] [SwingWorker-pool-1-thread-1] [com.h3c.imc.deploy.dma.wizard.DatabaseSelectPanelDescriptor$DbConnectCheckingWorkingDialog::doWork(2246)] user = root 

2021-11-29 18:37:44 [INFO ] [SwingWorker-pool-1-thread-1] [com.h3c.imc.deploy.dma.wizard.DatabaseSelectPanelDescriptor$DbConnectCheckingWorkingDialog::doWork(2246)] useSSL = false 

2021-11-29 18:37:45 [INFO ] [main] [com.h3c.imc.deploy.Util::isPortAvailable(4790)] isPortAvailable: 8080 2021-11-29 18:37:45 [INFO ] [main] [com.h3c.imc.deploy.Util::isPortAvailable(4790)] isPortAvailable: 8443 

2021-11-29 18:37:45 [INFO ] [Thread-15] [com.h3c.imc.deploy.dma.wizard.DeployingPanelDescriptor$WorkingThread::run(242)] data.isNeedInstallEmbeddedDatabase(): false 

2021-11-29 18:37:46 [INFO ] [AWT-EventQueue-0] [com.h3c.imc.deploy.dma.ComponentDeployInfo::isComponentsConformable(522)] Components conformable check failed: invalid state - deploying 

2021-11-29 18:37:47 [INFO ] [Thread-15] [com.h3c.imc.deploy.dma.wizard.DeployingPanelDescriptor$WorkingThread::run(286)] Start deploy component: iMC-PLAT [iMC PLAT 7.3 (E0705)] 

2021-11-29 18:37:47 [INFO ] [Thread-15] [com.h3c.imc.deploy.dma.wizard.DeployingPanelDescriptor$WorkingThread::run(298)] Replacement Variables: {${COUNTRY}=CN, ${DATABASE_ADDRESS}=127.0.0.1, ${DATABASE_ADMIN_PASSWORD_ESCAPE}={PROTECTED}, ${DATABASE_ADMIN_PASSWORD}={PROTECTED}, ${DATABASE_ADMIN_USERNAME}=root, ${DATABASE_PORT}=3306, ${DATABASE_TYPE}=MySQL, ${DEPLOY_IP}=127.0.0.1, ${HTTPS_PORT}=8443, ${HTTP_PORT}=8080, ${INSTALL_DESTINATION_DIR}=C:\Program Files\iMC, ${LANGUAGE_U}=zh, ${LANGUAGE}=zh, ${LOCAL_IP_0}=192.168.0.202, ${LOCAL_IP_1}=fe80:0:0:0:15d6:128d:4fb5:3572%eth4, ${LOCAL_IP_2}=fe80:0:0:0:0:5efe:c0a8:ca%net4, ${LOCAL_IP_COUNT}=3, ${MASTER_IP}=localhost, ${SERVER_TYPE}=Master, ${iMC-PLAT['DEPLOY_IP']}=127.0.0.1} 

2021-11-29 18:37:47 [INFO ] [Thread-15] [com.h3c.imc.deploy.dma.wizard.DeployingPanelDescriptor$WorkingThread::run(358)] Executing com.h3c.imc.deploy.tasks.UnzipFileTask(正在解压缩文件 - server_win.zip...)... 

2021-11-29 18:37:48 [INFO ] [Thread-15] [com.h3c.imc.deploy.dma.wizard.DeployingPanelDescriptor$WorkingThread::run(358)] Executing com.h3c.imc.deploy.tasks.UnzipFileTask(正在解压缩文件 - l2topo_server_windows.zip...)... 

2021-11-29 18:37:48 [INFO ] [Thread-15] [com.h3c.imc.deploy.dma.wizard.DeployingPanelDescriptor$WorkingThread::run(358)] Executing com.h3c.imc.deploy.tasks.UnzipFileTask(正在解压缩文件 - dhcpagent_server_win.zip...)... 

2021-11-29 18:37:48 [INFO ] [Thread-15] [com.h3c.imc.deploy.dma.wizard.DeployingPanelDescriptor$WorkingThread::run(358)] Executing com.h3c.imc.deploy.tasks.UnzipFileTask(正在解压缩文件 - client.zip...)... 

2021-11-29 18:38:08 [INFO ] [Thread-15] [com.h3c.imc.deploy.dma.wizard.DeployingPanelDescriptor$WorkingThread::run(358)] Executing com.h3c.imc.deploy.tasks.UnzipFileTask(正在解压缩文件 - client_verfunc.zip...)... 

2021-11-29 18:38:08 [INFO ] [Thread-15] [com.h3c.imc.deploy.dma.wizard.DeployingPanelDescriptor$WorkingThread::run(358)] Executing com.h3c.imc.deploy.tasks.UnzipFileTask(正在解压缩文件 - client_netconf.zip...)... 

2021-11-29 18:38:08 [INFO ] [Thread-15] [com.h3c.imc.deploy.dma.wizard.DeployingPanelDescriptor$WorkingThread::run(358)] Executing com.h3c.imc.deploy.tasks.UnzipFileTask(正在解压缩文件 - imc_bdp.zip...)... 

2021-11-29 18:38:08 [INFO ] [Thread-15] [com.h3c.imc.deploy.dma.wizard.DeployingPanelDescriptor$WorkingThread::run(358)] Executing com.h3c.imc.deploy.tasks.UnzipFileTask(正在解压缩文件 - client_topoplat.zip...)... 

2021-11-29 18:38:08 [INFO ] [Thread-15] [com.h3c.imc.deploy.dma.wizard.DeployingPanelDescriptor$WorkingThread::run(358)] Executing com.h3c.imc.deploy.tasks.UnzipFileTask(正在解压缩文件 - client_usertopo.zip...)... 

2021-11-29 18:38:09 [INFO ] [Thread-15] [com.h3c.imc.deploy.dma.wizard.DeployingPanelDescriptor$WorkingThread::run(358)] Executing com.h3c.imc.deploy.tasks.UnzipFileTask(正在解压缩文件 - client_webdm_mibbrowser.zip...)... 

2021-11-29 18:38:10 [INFO ] [Thread-15] [com.h3c.imc.deploy.dma.wizard.DeployingPanelDescriptor$WorkingThread::run(358)] Executing com.h3c.imc.deploy.tasks.UnzipFileTask(正在解压缩文件 - client_gencfg.zip...)... 

2021-11-29 18:38:10 [INFO ] [Thread-15] [com.h3c.imc.deploy.dma.wizard.DeployingPanelDescriptor$WorkingThread::run(358)] Executing com.h3c.imc.deploy.tasks.UnzipFileTask(正在解压缩文件 - cmdb_if.zip...)... 

2021-11-29 18:38:10 [INFO ] [Thread-15] [com.h3c.imc.deploy.dma.wizard.DeployingPanelDescriptor$WorkingThread::run(358)] Executing com.h3c.imc.deploy.tasks.UnzipFileTask(正在解压缩文件 - imcdm_topopanel_sdk_daily.zip...)... 

2021-11-29 18:38:12 [INFO ] [Thread-15] [com.h3c.imc.deploy.dma.wizard.DeployingPanelDescriptor$WorkingThread::run(358)] Executing com.h3c.imc.deploy.tasks.UnzipFileTask(正在解压缩文件 - 3rd_license_plat.zip...)... 

2021-11-29 18:38:12 [INFO ] [Thread-15] [com.h3c.imc.deploy.dma.wizard.DeployingPanelDescriptor$WorkingThread::run(358)] Executing com.h3c.imc.deploy.tasks.UnzipFileTask(正在解压缩文件 - client_iccconf.zip...)... 

2021-11-29 18:38:12 [INFO ] [Thread-15] [com.h3c.imc.deploy.dma.wizard.DeployingPanelDescriptor$WorkingThread::run(358)] Executing com.h3c.imc.deploy.tasks.UnzipFileTask(正在解压缩文件 - client_imcbigscreen.zip...)...

 2021-11-29 18:38:13 [INFO ] [Thread-15] [com.h3c.imc.deploy.dma.wizard.DeployingPanelDescriptor$WorkingThread::run(358)] Executing com.h3c.imc.deploy.tasks.UnzipFileTask(正在解压缩文件 - imc_datacenter.zip...)... 

2021-11-29 18:38:14 [INFO ] [Thread-15] [com.h3c.imc.deploy.dma.wizard.DeployingPanelDescriptor$WorkingThread::run(358)] Executing com.h3c.imc.deploy.tasks.UnzipFileTask(正在解压缩文件 - oemCustom.zip...)... 

2021-11-29 18:38:14 [INFO ] [Thread-15] [com.h3c.imc.deploy.dma.IPConfigFileManager::readAllConfigs(169)] Start loading server-addr.xml configuration file 

2021-11-29 18:38:14 [WARN ] [Thread-15] [com.h3c.imc.deploy.dma.IPConfigFileManager::readAllConfigs(174)] Config file is not exist - C:\Program Files\iMC\common\conf\server-addr.xml 

2021-11-29 18:38:14 [INFO ] [Thread-15] [com.h3c.imc.deploy.dma.wizard.DeployingPanelDescriptor$WorkingThread::run(358)] Executing com.h3c.imc.deploy.tasks.BuildDatabaseTask(正在执行数据库创建操作 - server\script_mysql.hz...)... 

2021-11-29 18:38:14 [INFO ] [SwingWorker-pool-3-thread-9] [com.h3c.imc.deploy.tasks.BuildDatabaseTask$DatabaseBuilderWorker::doInBackground(855)] 解压数据库文件 

2021-11-29 18:38:15 [INFO ] [SwingWorker-pool-3-thread-9] [com.h3c.imc.deploy.Util::getExecEnvWithDatabaseEnvSet(2106)] getExecEnvWithDatabaseEnvSetMySQL 

2021-11-29 18:38:15 [INFO ] [SwingWorker-pool-3-thread-9] [com.h3c.imc.deploy.Util::getExecEnvsWithMySQLPathSet(2290)] Add MySQL Server Bin to PATH: C:\Program Files\MySQL\MySQL5.7\\bin 

2021-11-29 18:38:18 [ERROR] [SwingWorker-pool-3-thread-9] [com.h3c.imc.deploy.tasks.BuildDatabaseTask$DatabaseBuilderWorker::doInBackground(936)] Execute database script error! return value: 1. For details, see log file: C:\Windows\iMC-Reserved\log\dbresult_202111291838140.log 

2021-11-29 18:38:18 [ERROR] [Thread-15] [com.h3c.imc.deploy.dma.wizard.DeployingPanelDescriptor$WorkingThread::run(363)] Task execute failed 

2021-11-29 18:38:18 [INFO ] [Thread-15] [com.h3c.imc.deploy.dma.IPConfigFileManager::readAllConfigs(169)] Start loading server-addr.xml configuration file 

2021-11-29 18:38:18 [WARN ] [Thread-15] [com.h3c.imc.deploy.dma.IPConfigFileManager::readAllConfigs(174)] Config file is not exist - C:\Program Files\iMC\common\conf\server-addr.xml 

2021-11-29 18:38:18 [INFO ] [Thread-15] [com.h3c.imc.deploy.dma.IPConfigFileManager::saveAllConfigs(354)] Save server address config OK 

2021-11-29 18:38:18 [INFO ] [AWT-EventQueue-0] [com.h3c.imc.deploy.dma.ComponentDeployInfo::isComponentsConformable(622)] Components conformable check failed: no component deployed 

2021-11-29 18:38:22 [WARN ] [main] [com.h3c.imc.deploy.DMALauncher::checkBatchDeploy(619)] Deploy component iMC-PLAT failed, return: ERROR, batch deploy interrupted.

IMC:H3C_iMC_PLAT_7.3_E0705_Standard_windows

MySQL：mysql-5.7.18-winx64