## Issue observed when checking against 5.7.32 but no fatal issues reported when checked against 5.7.43 ### 5.7.32 bin/mysqlsh -- util checkForServerUpgrade root@localhost --target-version=8.0.34 --output-format=JSON Please provide the password for 'root@localhost': Save password for 'root@localhost'? [Y]es/[N]o/Ne[v]er (default No): { "serverAddress": "localhost:3306", "serverVersion": "5.7.32 - MySQL Community Server (GPL)", "targetVersion": "8.0.34", "errorCount": 1, "warningCount": 149, "noticeCount": 2, "summary": "1 errors were found. Please correct these issues before upgrading to avoid compatibility issues.", "checksPerformed": [ { "id": "oldTemporalCheck", "title": "Usage of old temporal type", "status": "OK", "detectedProblems": [] }, { "id": "routinesSyntaxCheck", "title": "MySQL 8.0 syntax check for routine-like objects", "status": "OK", "detectedProblems": [] }, { "id": "reservedKeywordsCheck", "title": "Usage of db objects with names conflicting with new reserved keywords", "status": "OK", "detectedProblems": [] }, { "id": "utf8mb3Check", "title": "Usage of utf8mb3 charset", "status": "OK", "description": "Warning: The following objects use the utf8mb3 character set. It is recommended to convert them to use utf8mb4 instead, for improved Unicode support.", "documentationLink": "https://dev.mysql.com/doc/refman/8.0/en/charset-unicode-utf8mb3.html", "detectedProblems": [ { "level": "Warning", "dbObject": "demo.account_change.log_id", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.account_change.app_version", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.account_change.c_ip", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.account_change.geo_city", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.account_change.geo_country_long", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.account_change.geo_region", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.account_change.http_req", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.account_change.module", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.account_change.rel_obj_name", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.account_change.s_ip", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.account_change.tag", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.account_change.action_cn", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.account_change.action_en", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.account_change.action_result", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.account_change.app_name_cn", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.account_change.app_name_en", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.account_change.log_details", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.account_change.log_type", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.account_change.operated_user_name", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.account_change.operator_name", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.account_change.result_msg", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.account_change.session_id", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.audit_view_history.auth_type", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.audit_view_history.device_type", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.audit_view_history.login_ip", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.audit_view_history.city", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.audit_view_history.username", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.dept.log_id", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.dept.app_version", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.dept.c_ip", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.dept.geo_city", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.dept.geo_country_long", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.dept.geo_region", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.dept.http_req", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.dept.module", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.dept.rel_obj_name", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.dept.s_ip", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.dept.tag", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.dept.action_cn", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.dept.action_en", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.dept.action_result", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.dept.app_name_cn", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.dept.app_name_en", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.dept.leader_name", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.dept.log_details", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.dept.log_type", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.dept.name_en_path", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.dept.name_path", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.dept.operated_user_name", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.dept.operator_name", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.dept.org_code", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.dept.org_name", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.dept.org_name_en", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.dept.org_path", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.dept.parent_org_name", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.dept.parent_org_name_en", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.dept.result_msg", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.dept.session_id", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.login_record_history.id", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.login_record_history.username", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.login_record_history.login_account", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.login_record_history.auth_type", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.login_record_history.mobile_number", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.login_record_history.device_abbreviate", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.login_record_history.device_type", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.login_record_history.login_ip", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.login_record_history.city", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.login_record_history.browser_type", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.login_record_history.user_agent", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.login_record_history.device_printer", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.login_record_history.protocol", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.login_record_history.request_application", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.login_record_history.application_account", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.login_record_history.risk_trigger", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.login_record_history.trust_trigger", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.login_record_history.domain_id", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.platform_role.log_id", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.platform_role.app_version", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.platform_role.c_ip", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.platform_role.geo_city", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.platform_role.geo_country_long", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.platform_role.geo_region", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.platform_role.http_req", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.platform_role.module", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.platform_role.rel_obj_name", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.platform_role.s_ip", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.platform_role.tag", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.platform_role.action_cn", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.platform_role.action_en", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.platform_role.action_result", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.platform_role.app_name_cn", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.platform_role.app_name_en", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.platform_role.log_details", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.platform_role.log_type", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.platform_role.operated_user_name", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.platform_role.operator_name", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.platform_role.result_msg", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.platform_role.role_name", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.platform_role.role_no", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.platform_role.session_id", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.pwd_change.log_id", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.pwd_change.app_version", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.pwd_change.c_ip", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.pwd_change.geo_city", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.pwd_change.geo_country_long", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.pwd_change.geo_region", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.pwd_change.http_req", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.pwd_change.module", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.pwd_change.rel_obj_name", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.pwd_change.s_ip", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.pwd_change.tag", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.pwd_change.action_cn", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.pwd_change.action_en", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.pwd_change.action_result", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.pwd_change.app_name_cn", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.pwd_change.app_name_en", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.pwd_change.check_value", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.pwd_change.field_type", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.pwd_change.field_value", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.pwd_change.input_value", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.pwd_change.log_type", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.pwd_change.modify_type", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.pwd_change.operated_user_name", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.pwd_change.operator_name", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.pwd_change.result_msg", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.pwd_change.session_id", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.user_info_change.log_id", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.user_info_change.app_version", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.user_info_change.c_ip", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.user_info_change.geo_city", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.user_info_change.geo_country_long", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.user_info_change.geo_region", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.user_info_change.http_req", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.user_info_change.module", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.user_info_change.rel_obj_name", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.user_info_change.s_ip", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.user_info_change.tag", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.user_info_change.action_cn", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.user_info_change.action_en", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.user_info_change.action_result", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.user_info_change.app_name_cn", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.user_info_change.app_name_en", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.user_info_change.log_details", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.user_info_change.log_type", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.user_info_change.operated_user_name", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.user_info_change.operator_name", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.user_info_change.result_msg", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.user_info_change.session_id", "description": "column's default character set: utf8" } ] }, { "id": "mysqlSchemaCheck", "title": "Table names in the mysql schema conflicting with new tables in 8.0", "status": "OK", "detectedProblems": [] }, { "id": "nonNativePartitioningCheck", "title": "Partitioned tables using engines with non native partitioning", "status": "OK", "detectedProblems": [] }, { "id": "foreignKeyLengthCheck", "title": "Foreign key constraint names longer than 64 characters", "status": "OK", "detectedProblems": [] }, { "id": "maxdbFlagCheck", "title": "Usage of obsolete MAXDB sql_mode flag", "status": "OK", "detectedProblems": [] }, { "id": "sqlModeFlagCheck", "title": "Usage of obsolete sql_mode flags", "status": "OK", "description": "Notice: The following DB objects have obsolete options persisted for sql_mode, which will be cleared during upgrade to 8.0.", "documentationLink": "https://dev.mysql.com/doc/refman/8.0/en/mysql-nutshell.html#mysql-nutshell-removals", "detectedProblems": [ { "level": "Notice", "dbObject": "global system variable sql_mode", "description": "defined using obsolete NO_AUTO_CREATE_USER option" } ] }, { "id": "enumSetElementLenghtCheck", "title": "ENUM/SET column definitions containing elements longer than 255 characters", "status": "OK", "detectedProblems": [] }, { "id": "partitionedTablesInSharedTablespaceCheck", "title": "Usage of partitioned tables in shared tablespaces", "status": "OK", "detectedProblems": [] }, { "id": "circularDirectoryCheck", "title": "Circular directory references in tablespace data file paths", "status": "OK", "detectedProblems": [] }, { "id": "removedFunctionsCheck", "title": "Usage of removed functions", "status": "OK", "detectedProblems": [] }, { "id": "groupByAscCheck", "title": "Usage of removed GROUP BY ASC/DESC syntax", "status": "OK", "detectedProblems": [] }, { "id": "removedSysLogVars", "title": "Removed system variables for error logging to the system log configuration", "status": "CONFIGURATION_ERROR", "description": "To run this check requires full path to MySQL server configuration file to be specified at 'configPath' key of options dictionary", "documentationLink": "https://dev.mysql.com/doc/relnotes/mysql/8.0/en/news-8-0-13.html#mysqld-8-0-13-logging" }, { "id": "removedSysVars", "title": "Removed system variables", "status": "CONFIGURATION_ERROR", "description": "To run this check requires full path to MySQL server configuration file to be specified at 'configPath' key of options dictionary", "documentationLink": "https://dev.mysql.com/doc/refman/8.0/en/added-deprecated-removed.html#optvars-removed" }, { "id": "sysVarsNewDefaults", "title": "System variables with new default values", "status": "CONFIGURATION_ERROR", "description": "To run this check requires full path to MySQL server configuration file to be specified at 'configPath' key of options dictionary", "documentationLink": "https://mysqlserverteam.com/new-defaults-in-mysql-8-0/" }, { "id": "zeroDatesCheck", "title": "Zero Date, Datetime, and Timestamp values", "status": "OK", "detectedProblems": [] }, { "id": "schemaInconsistencyCheck", "title": "Schema inconsistencies resulting from file removal or corruption", "status": "OK", "detectedProblems": [] }, { "id": "engineMixupCheck", "title": "Tables recognized by InnoDB that belong to a different engine", "status": "OK", "detectedProblems": [] }, { "id": "checkTableOutput", "title": "Issues reported by 'check table x for upgrade' command", "status": "OK", "detectedProblems": [ { "level": "Notice", "dbObject": "demo.audit_view_account", "description": "No database selected" }, { "level": "Error", "dbObject": "demo.audit_view_account", "description": "Corrupt" } ] }, { "id": "columnsWhichCannotHaveDefaultsCheck", "title": "Columns which cannot have default values", "status": "OK", "detectedProblems": [] }, { "id": "mysqlInvalid57NamesCheck", "title": "Check for invalid table names and schema names used in 5.7", "status": "OK", "detectedProblems": [] }, { "id": "mysqlOrphanedRoutinesCheck", "title": "Check for orphaned routines in 5.7", "status": "OK", "detectedProblems": [] }, { "id": "mysqlDollarSignNameCheck", "title": "Check for deprecated usage of single dollar signs in object names", "status": "OK", "detectedProblems": [] }, { "id": "mysqlIndexTooLargeCheck", "title": "Check for indexes that are too large to work on higher versions of MySQL Server than 5.7", "status": "OK", "detectedProblems": [] }, { "id": "mysqlEmptyDotTableSyntaxCheck", "title": "Check for deprecated '.' syntax used in routines.", "status": "OK", "detectedProblems": [] } ], "manualChecks": [ { "id": "defaultAuthenticationPlugin", "title": "New default authentication plugin considerations", "description": "Warning: The new default authentication plugin 'caching_sha2_password' offers more secure password hashing than previously used 'mysql_native_password' (and consequent improved client connection authentication). However, it also has compatibility implications that may affect existing MySQL installations. If your MySQL installation must serve pre-8.0 clients and you encounter compatibility issues after upgrading, the simplest way to address those issues is to reconfigure the server to revert to the previous default authentication plugin (mysql_native_password). For example, use these lines in the server option file:\n\n[mysqld]\ndefault_authentication_plugin=mysql_native_password\n\nHowever, the setting should be viewed as temporary, not as a long term or permanent solution, because it causes new accounts created with the setting in effect to forego the improved authentication security.\nIf you are using replication please take time to understand how the authentication plugin changes may impact you.", "documentationLink": "https://dev.mysql.com/doc/refman/8.0/en/upgrading-from-previous-series.html#upgrade-caching-sha2-password-compatibility-issues\nhttps://dev.mysql.com/doc/refman/8.0/en/upgrading-from-previous-series.html#upgrade-caching-sha2-password-replication" } ] } ### 5.7.43 bin/mysqlsh -- util checkForServerUpgrade root@localhost --target-version=8.0.34 --output-format=JSON Please provide the password for 'root@localhost': Save password for 'root@localhost'? [Y]es/[N]o/Ne[v]er (default No): { "serverAddress": "localhost:3306", "serverVersion": "5.7.43 - MySQL Community Server (GPL)", "targetVersion": "8.0.34", "errorCount": 0, "warningCount": 149, "noticeCount": 1, "summary": "No fatal errors were found that would prevent an upgrade, but some potential issues were detected. Please ensure that the reported issues are not significant before upgrading.", "checksPerformed": [ { "id": "oldTemporalCheck", "title": "Usage of old temporal type", "status": "OK", "detectedProblems": [] }, { "id": "routinesSyntaxCheck", "title": "MySQL 8.0 syntax check for routine-like objects", "status": "OK", "detectedProblems": [] }, { "id": "reservedKeywordsCheck", "title": "Usage of db objects with names conflicting with new reserved keywords", "status": "OK", "detectedProblems": [] }, { "id": "utf8mb3Check", "title": "Usage of utf8mb3 charset", "status": "OK", "description": "Warning: The following objects use the utf8mb3 character set. It is recommended to convert them to use utf8mb4 instead, for improved Unicode support.", "documentationLink": "https://dev.mysql.com/doc/refman/8.0/en/charset-unicode-utf8mb3.html", "detectedProblems": [ { "level": "Warning", "dbObject": "demo.account_change.log_id", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.account_change.app_version", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.account_change.c_ip", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.account_change.geo_city", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.account_change.geo_country_long", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.account_change.geo_region", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.account_change.http_req", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.account_change.module", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.account_change.rel_obj_name", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.account_change.s_ip", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.account_change.tag", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.account_change.action_cn", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.account_change.action_en", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.account_change.action_result", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.account_change.app_name_cn", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.account_change.app_name_en", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.account_change.log_details", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.account_change.log_type", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.account_change.operated_user_name", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.account_change.operator_name", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.account_change.result_msg", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.account_change.session_id", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.audit_view_history.auth_type", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.audit_view_history.device_type", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.audit_view_history.login_ip", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.audit_view_history.city", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.audit_view_history.username", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.dept.log_id", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.dept.app_version", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.dept.c_ip", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.dept.geo_city", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.dept.geo_country_long", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.dept.geo_region", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.dept.http_req", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.dept.module", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.dept.rel_obj_name", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.dept.s_ip", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.dept.tag", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.dept.action_cn", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.dept.action_en", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.dept.action_result", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.dept.app_name_cn", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.dept.app_name_en", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.dept.leader_name", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.dept.log_details", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.dept.log_type", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.dept.name_en_path", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.dept.name_path", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.dept.operated_user_name", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.dept.operator_name", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.dept.org_code", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.dept.org_name", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.dept.org_name_en", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.dept.org_path", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.dept.parent_org_name", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.dept.parent_org_name_en", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.dept.result_msg", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.dept.session_id", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.login_record_history.id", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.login_record_history.username", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.login_record_history.login_account", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.login_record_history.auth_type", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.login_record_history.mobile_number", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.login_record_history.device_abbreviate", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.login_record_history.device_type", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.login_record_history.login_ip", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.login_record_history.city", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.login_record_history.browser_type", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.login_record_history.user_agent", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.login_record_history.device_printer", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.login_record_history.protocol", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.login_record_history.request_application", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.login_record_history.application_account", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.login_record_history.risk_trigger", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.login_record_history.trust_trigger", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.login_record_history.domain_id", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.platform_role.log_id", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.platform_role.app_version", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.platform_role.c_ip", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.platform_role.geo_city", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.platform_role.geo_country_long", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.platform_role.geo_region", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.platform_role.http_req", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.platform_role.module", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.platform_role.rel_obj_name", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.platform_role.s_ip", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.platform_role.tag", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.platform_role.action_cn", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.platform_role.action_en", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.platform_role.action_result", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.platform_role.app_name_cn", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.platform_role.app_name_en", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.platform_role.log_details", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.platform_role.log_type", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.platform_role.operated_user_name", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.platform_role.operator_name", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.platform_role.result_msg", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.platform_role.role_name", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.platform_role.role_no", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.platform_role.session_id", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.pwd_change.log_id", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.pwd_change.app_version", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.pwd_change.c_ip", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.pwd_change.geo_city", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.pwd_change.geo_country_long", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.pwd_change.geo_region", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.pwd_change.http_req", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.pwd_change.module", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.pwd_change.rel_obj_name", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.pwd_change.s_ip", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.pwd_change.tag", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.pwd_change.action_cn", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.pwd_change.action_en", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.pwd_change.action_result", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.pwd_change.app_name_cn", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.pwd_change.app_name_en", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.pwd_change.check_value", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.pwd_change.field_type", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.pwd_change.field_value", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.pwd_change.input_value", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.pwd_change.log_type", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.pwd_change.modify_type", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.pwd_change.operated_user_name", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.pwd_change.operator_name", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.pwd_change.result_msg", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.pwd_change.session_id", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.user_info_change.log_id", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.user_info_change.app_version", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.user_info_change.c_ip", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.user_info_change.geo_city", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.user_info_change.geo_country_long", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.user_info_change.geo_region", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.user_info_change.http_req", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.user_info_change.module", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.user_info_change.rel_obj_name", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.user_info_change.s_ip", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.user_info_change.tag", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.user_info_change.action_cn", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.user_info_change.action_en", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.user_info_change.action_result", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.user_info_change.app_name_cn", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.user_info_change.app_name_en", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.user_info_change.log_details", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.user_info_change.log_type", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.user_info_change.operated_user_name", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.user_info_change.operator_name", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.user_info_change.result_msg", "description": "column's default character set: utf8" }, { "level": "Warning", "dbObject": "demo.user_info_change.session_id", "description": "column's default character set: utf8" } ] }, { "id": "mysqlSchemaCheck", "title": "Table names in the mysql schema conflicting with new tables in 8.0", "status": "OK", "detectedProblems": [] }, { "id": "nonNativePartitioningCheck", "title": "Partitioned tables using engines with non native partitioning", "status": "OK", "detectedProblems": [] }, { "id": "foreignKeyLengthCheck", "title": "Foreign key constraint names longer than 64 characters", "status": "OK", "detectedProblems": [] }, { "id": "maxdbFlagCheck", "title": "Usage of obsolete MAXDB sql_mode flag", "status": "OK", "detectedProblems": [] }, { "id": "sqlModeFlagCheck", "title": "Usage of obsolete sql_mode flags", "status": "OK", "description": "Notice: The following DB objects have obsolete options persisted for sql_mode, which will be cleared during upgrade to 8.0.", "documentationLink": "https://dev.mysql.com/doc/refman/8.0/en/mysql-nutshell.html#mysql-nutshell-removals", "detectedProblems": [ { "level": "Notice", "dbObject": "global system variable sql_mode", "description": "defined using obsolete NO_AUTO_CREATE_USER option" } ] }, { "id": "enumSetElementLenghtCheck", "title": "ENUM/SET column definitions containing elements longer than 255 characters", "status": "OK", "detectedProblems": [] }, { "id": "partitionedTablesInSharedTablespaceCheck", "title": "Usage of partitioned tables in shared tablespaces", "status": "OK", "detectedProblems": [] }, { "id": "circularDirectoryCheck", "title": "Circular directory references in tablespace data file paths", "status": "OK", "detectedProblems": [] }, { "id": "removedFunctionsCheck", "title": "Usage of removed functions", "status": "OK", "detectedProblems": [] }, { "id": "groupByAscCheck", "title": "Usage of removed GROUP BY ASC/DESC syntax", "status": "OK", "detectedProblems": [] }, { "id": "removedSysLogVars", "title": "Removed system variables for error logging to the system log configuration", "status": "CONFIGURATION_ERROR", "description": "To run this check requires full path to MySQL server configuration file to be specified at 'configPath' key of options dictionary", "documentationLink": "https://dev.mysql.com/doc/relnotes/mysql/8.0/en/news-8-0-13.html#mysqld-8-0-13-logging" }, { "id": "removedSysVars", "title": "Removed system variables", "status": "CONFIGURATION_ERROR", "description": "To run this check requires full path to MySQL server configuration file to be specified at 'configPath' key of options dictionary", "documentationLink": "https://dev.mysql.com/doc/refman/8.0/en/added-deprecated-removed.html#optvars-removed" }, { "id": "sysVarsNewDefaults", "title": "System variables with new default values", "status": "CONFIGURATION_ERROR", "description": "To run this check requires full path to MySQL server configuration file to be specified at 'configPath' key of options dictionary", "documentationLink": "https://mysqlserverteam.com/new-defaults-in-mysql-8-0/" }, { "id": "zeroDatesCheck", "title": "Zero Date, Datetime, and Timestamp values", "status": "OK", "detectedProblems": [] }, { "id": "schemaInconsistencyCheck", "title": "Schema inconsistencies resulting from file removal or corruption", "status": "OK", "detectedProblems": [] }, { "id": "engineMixupCheck", "title": "Tables recognized by InnoDB that belong to a different engine", "status": "OK", "detectedProblems": [] }, { "id": "checkTableOutput", "title": "Issues reported by 'check table x for upgrade' command", "status": "OK", "detectedProblems": [] }, { "id": "columnsWhichCannotHaveDefaultsCheck", "title": "Columns which cannot have default values", "status": "OK", "detectedProblems": [] }, { "id": "mysqlInvalid57NamesCheck", "title": "Check for invalid table names and schema names used in 5.7", "status": "OK", "detectedProblems": [] }, { "id": "mysqlOrphanedRoutinesCheck", "title": "Check for orphaned routines in 5.7", "status": "OK", "detectedProblems": [] }, { "id": "mysqlDollarSignNameCheck", "title": "Check for deprecated usage of single dollar signs in object names", "status": "OK", "detectedProblems": [] }, { "id": "mysqlIndexTooLargeCheck", "title": "Check for indexes that are too large to work on higher versions of MySQL Server than 5.7", "status": "OK", "detectedProblems": [] }, { "id": "mysqlEmptyDotTableSyntaxCheck", "title": "Check for deprecated '.
' syntax used in routines.", "status": "OK", "detectedProblems": [] } ], "manualChecks": [ { "id": "defaultAuthenticationPlugin", "title": "New default authentication plugin considerations", "description": "Warning: The new default authentication plugin 'caching_sha2_password' offers more secure password hashing than previously used 'mysql_native_password' (and consequent improved client connection authentication). However, it also has compatibility implications that may affect existing MySQL installations. If your MySQL installation must serve pre-8.0 clients and you encounter compatibility issues after upgrading, the simplest way to address those issues is to reconfigure the server to revert to the previous default authentication plugin (mysql_native_password). For example, use these lines in the server option file:\n\n[mysqld]\ndefault_authentication_plugin=mysql_native_password\n\nHowever, the setting should be viewed as temporary, not as a long term or permanent solution, because it causes new accounts created with the setting in effect to forego the improved authentication security.\nIf you are using replication please take time to understand how the authentication plugin changes may impact you.", "documentationLink": "https://dev.mysql.com/doc/refman/8.0/en/upgrading-from-previous-series.html#upgrade-caching-sha2-password-compatibility-issues\nhttps://dev.mysql.com/doc/refman/8.0/en/upgrading-from-previous-series.html#upgrade-caching-sha2-password-replication" } ] }