C:\Program Files\MySQL\MySQL Server 5.7>bin\mysqld --defaults-file="c:\ProgramData\MySQL\MySQL Server 5.7\my.ini" --standalone --console 2018-05-02T10:53:35.197375Z 0 [ERROR] [MY-011071] [Server] C:\Program Files\MySQL\MySQL Server 5.7\bin\mysqld.exe: Error while setting value 'STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' to 'sql_mode' 2018-05-02T10:53:35.200310Z 0 [ERROR] [MY-010119] [Server] Aborting 2018-05-02T10:53:35.201472Z 0 [Note] [MY-010120] [Server] Binlog end ------------------------------------------------------------------------------------------------------------------------------------- # Set the SQL mode to strict sql-mode="STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION" #NO_AUTO_CREATE_USER ------------------------------------------------------------------------------------------------------------------------------------ C:\Program Files\MySQL\MySQL Server 5.7>bin\mysqld --defaults-file="c:\ProgramData\MySQL\MySQL Server 5.7\my.ini" --standalone --console 2018-05-02T10:56:09.795694Z 0 [Warning] [MY-011071] [Server] option 'read_buffer_size': unsigned value 0 adjusted to 8192 2018-05-02T10:56:09.795725Z 0 [Warning] [MY-011071] [Server] option 'read_rnd_buffer_size': unsigned value 0 adjusted to 1 2018-05-02T10:56:09.795781Z 0 [Warning] [MY-010915] [Server] 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release. 2018-05-02T10:56:09.803582Z 0 [System] [MY-010116] [Server] C:\Program Files\MySQL\MySQL Server 5.7\bin\mysqld.exe (mysqld 8.0.11) starting as process 13480 2018-05-02T10:56:17.586480Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed. 2018-05-02T10:56:17.866518Z 0 [ERROR] [MY-013129] [Server] A message intended for a client cannot be sent there as no client-session is attached. Therefore, we're sending the information to the error-log instead: MY-001146 - Table 'mysql.component' doesn't exist 2018-05-02T10:56:17.870869Z 0 [Warning] [MY-013129] [Server] A message intended for a client cannot be sent there as no client-session is attached. Therefore, we're sending the information to the error-log instead: MY-003543 - The mysql.component table is missing or has an incorrect definition. 2018-05-02T10:56:17.882839Z 0 [Warning] [MY-010929] [Server] Storage engine 'MyISAM' does not support system tables. [mysql.user]. 2018-05-02T10:56:17.885537Z 0 [Warning] [MY-010929] [Server] Storage engine 'MyISAM' does not support system tables. [mysql.db]. 2018-05-02T10:56:17.887026Z 0 [Warning] [MY-010929] [Server] Storage engine 'MyISAM' does not support system tables. [mysql.tables_priv]. 2018-05-02T10:56:17.888606Z 0 [Warning] [MY-010929] [Server] Storage engine 'MyISAM' does not support system tables. [mysql.columns_priv]. 2018-05-02T10:56:17.890228Z 0 [Warning] [MY-010929] [Server] Storage engine 'MyISAM' does not support system tables. [mysql.procs_priv]. 2018-05-02T10:56:17.892148Z 0 [Warning] [MY-010929] [Server] Storage engine 'MyISAM' does not support system tables. [mysql.proxies_priv]. 2018-05-02T10:56:17.895271Z 0 [ERROR] [MY-013143] [Server] Column count of mysql.user is wrong. Expected 49, found 45. The table is probably corrupted 2018-05-02T10:56:17.897129Z 0 [Warning] [MY-010966] [Server] ACL table mysql.role_edges missing. Some operations may fail. 2018-05-02T10:56:17.898534Z 0 [Warning] [MY-010966] [Server] ACL table mysql.default_roles missing. Some operations may fail. 2018-05-02T10:56:17.899920Z 0 [Warning] [MY-010966] [Server] ACL table mysql.global_grants missing. Some operations may fail. 2018-05-02T10:56:17.901298Z 0 [Warning] [MY-010966] [Server] ACL table mysql.password_history missing. Some operations may fail. 2018-05-02T10:56:17.903861Z 0 [ERROR] [MY-010965] [Server] Missing system table mysql.global_grants; please run mysql_upgrade to create it. 2018-05-02T10:56:17.912247Z 0 [Warning] [MY-010727] [Server] System table 'func' is expected to be transactional. 2018-05-02T10:56:17.919385Z 0 [Warning] [MY-010405] [Repl] Info table is not ready to be used. Table 'mysql.slave_master_info' cannot be opened. 2018-05-02T10:56:17.921970Z 0 [ERROR] [MY-010422] [Repl] Error in checking mysql.slave_master_info repository info type of TABLE. 2018-05-02T10:56:17.923727Z 0 [ERROR] [MY-010415] [Repl] Error creating master info: Error checking repositories. 2018-05-02T10:56:17.928494Z 0 [ERROR] [MY-010426] [Repl] Slave: Failed to initialize the master info structure for channel ''; its record may still be present in 'mysql.slave_master_info' table, consider deleting it. 2018-05-02T10:56:17.932905Z 0 [ERROR] [MY-010529] [Repl] Failed to create or recover replication info repositories. 2018-05-02T10:56:17.941238Z 0 [System] [MY-010931] [Server] C:\Program Files\MySQL\MySQL Server 5.7\bin\mysqld.exe: ready for connections. Version: '8.0.11' socket: '' port: 3306 MySQL Community Server - GPL. --------------------------------------------------------------------------------------------------------------------------------------- C:\Program Files\MySQL\MySQL Server 5.7\bin>mysql_upgrade.exe -uroot -p Enter password: ********** Checking if update is needed. Checking server version. Running queries to upgrade MySQL server. Upgrading system table data. Checking system database. mysql.columns_priv OK mysql.component OK mysql.db OK mysql.default_roles OK mysql.engine_cost OK mysql.func OK mysql.general_log OK mysql.global_grants OK mysql.gtid_executed OK mysql.help_category OK mysql.help_keyword OK mysql.help_relation OK mysql.help_topic OK mysql.innodb_index_stats OK mysql.innodb_table_stats OK mysql.ndb_binlog_index OK mysql.password_history OK mysql.plugin OK mysql.procs_priv OK mysql.proxies_priv OK mysql.role_edges OK mysql.server_cost OK mysql.servers OK mysql.slave_master_info OK mysql.slave_relay_log_info OK mysql.slave_worker_info OK mysql.slow_log OK mysql.tables_priv OK mysql.time_zone OK mysql.time_zone_leap_second OK mysql.time_zone_name OK mysql.time_zone_transition OK mysql.time_zone_transition_type OK mysql.user OK Found outdated sys schema version 1.5.1. Upgrading the sys schema. Checking databases. sys.sys_config OK Upgrade process completed successfully. Checking if update is needed. C:\Program Files\MySQL\MySQL Server 5.7\bin>mysqladmin -uroot -p shutdown Enter password: **********