-- Followed in place upgrade - https://dev.mysql.com/doc/refman/8.0/en/windows-upgrading.html -- 5.7 my.ini [client] port=3306 [mysql] default-character-set=utf8mb4 [mysqld] # The TCP/IP Port the MySQL Server will listen on port=3306 max_allowed_packet=256M datadir="D:\ushastry\MySQL\mysql-5.7.21-winx64\data" basedir="D:\ushastry\MySQL\mysql-5.7.21-winx64" -- setup MySQL 5.7.21 using the Windows ZIP Distribution bin\mysqld --defaults-file=./my.ini --initialize-insecure --log-error-verbosity=3 bin\mysqld --defaults-file=./my.ini -- Create "test" schema D:\ushastry\MySQL\mysql-5.7.21-winx64>bin\mysql -uroot -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 3 Server version: 5.7.21 MySQL Community Server (GPL) Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> create database test; Query OK, 1 row affected (0.00 sec) mysql> \q Bye D:\ushastry\MySQL\mysql-5.7.21-winx64> -- Shutdown - before upgrading from MySQL 5.7 to 8.0, use mysqladmin from MySQL 5.7 as follows: D:\ushastry\MySQL\mysql-5.7.21-winx64>bin\mysqladmin -uroot -p shutdown Enter password: # Extract the MySQL 8.0 ZIP archive. You may either overwrite your existing MySQL installation (usually located at C:\/mysql), or install it into a different directory, such as C:\mysql8. Overwriting the existing installation is recommended. Extracted in D:\ushastry\MySQL\mysql-8.0.12-winx64> D:\ushastry\MySQL\mysql-5.7.21-winx64>cd D:\ushastry\MySQL\mysql-8.0.12-winx64 -- 8.0 my.ini [client] port=3306 [mysql] default-character-set=utf8mb4 [mysqld] # The TCP/IP Port the MySQL Server will listen on port=3306 max_allowed_packet=256M datadir="D:\ushastry\MySQL\mysql-5.7.21-winx64\data" basedir="D:\ushastry\MySQL\mysql-8.0.12-winx64" -- started 8.0 instance using 5.7 datadir D:\ushastry\MySQL\mysql-5.7.21-winx64> D:\ushastry\MySQL\mysql-5.7.21-winx64>cd D:\ushastry\MySQL\mysql-8.0.12-winx64 D:\ushastry\MySQL\mysql-8.0.12-winx64>bin\mysqld --defaults-file=./my.ini -- Confirmed that 8.0.12 is up and running D:\ushastry\MySQL\mysql-8.0.12-winx64>bin\mysql -uroot -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 9 Server version: 8.0.12 MySQL Community Server - GPL Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> # run mysql_upgrade to check your tables, attempt to repair them if necessary, and update your grant tables if they have changed so that you can take advantage of any new capabilities D:\ushastry\MySQL\mysql-8.0.12-winx64>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. - Shutdown 8.0 instance and restart again after mysql_upgrade ran D:\ushastry\MySQL\mysql-8.0.12-winx64>bin\mysqladmin -uroot -p shutdown Enter password: - Start 8.0 Server D:\ushastry\MySQL\mysql-8.0.12-winx64>bin\mysqld --defaults-file=./my.ini - Confirmed 8.0 is up and running D:\ushastry\MySQL\mysql-8.0.12-winx64>bin\mysqladmin -uroot -p shutdown Enter password: D:\ushastry\MySQL\mysql-8.0.12-winx64>bin\mysql -uroot -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 8 Server version: 8.0.12 MySQL Community Server - GPL Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> ## Error log 2018-08-24T00:55:36.677667Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2018-08-24T00:55:36.677667Z 0 [Note] Ignoring --secure-file-priv value as server is running with --initialize(-insecure) or --bootstrap. 2018-08-24T00:55:36.678667Z 0 [Note] bin\mysqld (mysqld 5.7.21) starting as process 10492 ... 2018-08-24T00:55:36.736670Z 0 [Note] Creating the data directory D:\ushastry\MySQL\mysql-5.7.21-winx64\data\ 2018-08-24T00:55:36.787673Z 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions 2018-08-24T00:55:36.790673Z 0 [Note] InnoDB: Uses event mutexes 2018-08-24T00:55:36.791673Z 0 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier 2018-08-24T00:55:36.792673Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.3 2018-08-24T00:55:36.794673Z 0 [Note] InnoDB: Number of pools: 1 2018-08-24T00:55:36.796674Z 0 [Note] InnoDB: Not using CPU crc32 instructions 2018-08-24T00:55:36.816675Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M 2018-08-24T00:55:36.830675Z 0 [Note] InnoDB: Completed initialization of buffer pool 2018-08-24T00:55:36.854677Z 0 [Note] InnoDB: The first innodb_system data file 'ibdata1' did not exist. A new tablespace will be created! 2018-08-24T00:55:36.861677Z 0 [Note] InnoDB: Setting file '.\ibdata1' size to 12 MB. Physically writing the file full; Please wait ... 2018-08-24T00:55:37.099691Z 0 [Note] InnoDB: File '.\ibdata1' size is now 12 MB. 2018-08-24T00:55:37.127692Z 0 [Note] InnoDB: Setting log file .\ib_logfile101 size to 48 MB 2018-08-24T00:55:38.037745Z 0 [Note] InnoDB: Setting log file .\ib_logfile1 size to 48 MB 2018-08-24T00:55:38.893794Z 0 [Note] InnoDB: Renaming log file .\ib_logfile101 to .\ib_logfile0 2018-08-24T00:55:38.916795Z 0 [Warning] InnoDB: New log files created, LSN=45790 2018-08-24T00:55:38.918795Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2018-08-24T00:55:38.921795Z 0 [Note] InnoDB: Setting file '.\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2018-08-24T00:55:39.131807Z 0 [Note] InnoDB: File '.\ibtmp1' size is now 12 MB. 2018-08-24T00:55:39.138808Z 0 [Note] InnoDB: Doublewrite buffer not found: creating new 2018-08-24T00:55:39.250814Z 0 [Note] InnoDB: Doublewrite buffer created 2018-08-24T00:55:39.280816Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. 2018-08-24T00:55:39.283816Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. 2018-08-24T00:55:39.319818Z 0 [Warning] InnoDB: Creating foreign key constraint system tables. 2018-08-24T00:55:39.345819Z 0 [Note] InnoDB: Foreign key constraint system tables created 2018-08-24T00:55:39.347819Z 0 [Note] InnoDB: Creating tablespace and datafile system tables. 2018-08-24T00:55:39.351820Z 0 [Note] InnoDB: Tablespace and datafile system tables created. 2018-08-24T00:55:39.353820Z 0 [Note] InnoDB: Creating sys_virtual system tables. 2018-08-24T00:55:39.356820Z 0 [Note] InnoDB: sys_virtual table created 2018-08-24T00:55:39.360820Z 0 [Note] InnoDB: 5.7.21 started; log sequence number 0 2018-08-24T00:55:39.370821Z 0 [Note] Plugin 'FEDERATED' is disabled. 2018-08-24T00:55:39.374821Z 0 [Note] Salting uuid generator variables, current_pid: 10492, server_start_time: 1535072136, bytes_sent: 0, 2018-08-24T00:55:39.398822Z 0 [Note] Generated uuid: '6b3d4ab9-a738-11e8-89ec-bc305bc8d894', server_start_time: 1535082628, bytes_sent: 206925504 2018-08-24T00:55:39.402823Z 0 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: 6b3d4ab9-a738-11e8-89ec-bc305bc8d894. 2018-08-24T00:55:39.410823Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened. 2018-08-24T00:55:39.416823Z 1 [Note] Creating the system database 2018-08-24T00:55:39.417823Z 1 [Warning] root@localhost is created with an empty password ! Please consider switching off the --initialize-insecure option. 2018-08-24T00:55:39.451825Z 1 [Note] Creating the system tables 2018-08-24T00:55:40.723898Z 1 [Note] Filling in the system tables, part 1 2018-08-24T00:55:40.751900Z 1 [Note] Filling in the system tables, part 2 2018-08-24T00:55:40.752900Z 1 [Note] Filling in the mysql.help table 2018-08-24T00:55:41.374935Z 1 [Note] Creating user for internal session service 2018-08-24T00:55:41.377936Z 1 [Note] Creating the sys schema 2018-08-24T00:55:42.249985Z 1 [Note] Bootstrapping complete 2018-08-24T00:55:42.252986Z 0 [Note] Binlog end 2018-08-24T00:55:42.268987Z 0 [Note] InnoDB: FTS optimize thread exiting. 2018-08-24T00:55:42.334990Z 0 [Note] InnoDB: Starting shutdown... 2018-08-24T00:55:42.438996Z 0 [Note] InnoDB: Dumping buffer pool(s) to D:\ushastry\MySQL\mysql-5.7.21-winx64\data\ib_buffer_pool 2018-08-24T00:55:42.447997Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 180824 6:25:42 2018-08-24T00:55:43.093034Z 0 [Note] InnoDB: Shutdown completed; log sequence number 2551166 2018-08-24T00:55:43.096034Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2018-08-24T00:56:06.757387Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2018-08-24T00:56:06.757387Z 0 [Note] --secure-file-priv is set to NULL. Operations related to importing and exporting data are disabled 2018-08-24T00:56:06.758387Z 0 [Note] bin\mysqld (mysqld 5.7.21) starting as process 3368 ... 2018-08-24T00:56:06.788389Z 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions 2018-08-24T00:56:06.790389Z 0 [Note] InnoDB: Uses event mutexes 2018-08-24T00:56:06.791389Z 0 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier 2018-08-24T00:56:06.792389Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.3 2018-08-24T00:56:06.794389Z 0 [Note] InnoDB: Number of pools: 1 2018-08-24T00:56:06.795389Z 0 [Note] InnoDB: Not using CPU crc32 instructions 2018-08-24T00:56:06.817391Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M 2018-08-24T00:56:06.835392Z 0 [Note] InnoDB: Completed initialization of buffer pool 2018-08-24T00:56:06.949398Z 0 [Note] InnoDB: Highest supported file format is Barracuda. 2018-08-24T00:56:07.123408Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2018-08-24T00:56:07.138409Z 0 [Note] InnoDB: Setting file '.\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2018-08-24T00:56:07.364422Z 0 [Note] InnoDB: File '.\ibtmp1' size is now 12 MB. 2018-08-24T00:56:07.370422Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. 2018-08-24T00:56:07.372422Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. 2018-08-24T00:56:07.376423Z 0 [Note] InnoDB: Waiting for purge to start 2018-08-24T00:56:07.431426Z 0 [Note] InnoDB: 5.7.21 started; log sequence number 2551166 2018-08-24T00:56:07.434426Z 0 [Note] InnoDB: Loading buffer pool(s) from D:\ushastry\MySQL\mysql-5.7.21-winx64\data\ib_buffer_pool 2018-08-24T00:56:07.435426Z 0 [Note] Plugin 'FEDERATED' is disabled. 2018-08-24T00:56:07.592435Z 0 [Warning] Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private key 2018-08-24T00:56:07.596435Z 0 [Note] Server hostname (bind-address): '*'; port: 3306 2018-08-24T00:56:07.603436Z 0 [Note] IPv6 is available. 2018-08-24T00:56:07.605436Z 0 [Note] - '::' resolves to '::'; 2018-08-24T00:56:07.606436Z 0 [Note] Server socket created on IP: '::'. 2018-08-24T00:56:07.714442Z 0 [Note] InnoDB: Buffer pool(s) load completed at 180824 6:26:07 2018-08-24T00:56:08.047461Z 0 [Note] Event Scheduler: Loaded 0 events 2018-08-24T00:56:08.049461Z 0 [Note] bin\mysqld: ready for connections. Version: '5.7.21' socket: '' port: 3306 MySQL Community Server (GPL) 2018-08-24T00:56:33.202900Z 2 [Note] Access denied for user 'root'@'localhost' (using password: YES) 2018-08-24T00:57:53.223477Z 0 [Note] bin\mysqld: Normal shutdown 2018-08-24T00:57:53.226477Z 0 [Note] Giving 0 client threads a chance to die gracefully 2018-08-24T00:57:53.228477Z 0 [Note] Shutting down slave threads 2018-08-24T00:57:53.229477Z 0 [Note] Forcefully disconnecting 0 remaining clients 2018-08-24T00:57:53.231477Z 0 [Note] Event Scheduler: Purging the queue. 0 events 2018-08-24T00:57:53.233477Z 0 [Note] Binlog end 2018-08-24T00:57:53.239478Z 0 [Note] Shutting down plugin 'ngram' 2018-08-24T00:57:53.241478Z 0 [Note] Shutting down plugin 'partition' 2018-08-24T00:57:53.242478Z 0 [Note] Shutting down plugin 'BLACKHOLE' 2018-08-24T00:57:53.243478Z 0 [Note] Shutting down plugin 'ARCHIVE' 2018-08-24T00:57:53.244478Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA' 2018-08-24T00:57:53.245478Z 0 [Note] Shutting down plugin 'MRG_MYISAM' 2018-08-24T00:57:53.246478Z 0 [Note] Shutting down plugin 'MyISAM' 2018-08-24T00:57:53.247478Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL' 2018-08-24T00:57:53.248478Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES' 2018-08-24T00:57:53.249478Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES' 2018-08-24T00:57:53.250478Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS' 2018-08-24T00:57:53.252478Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN' 2018-08-24T00:57:53.253478Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS' 2018-08-24T00:57:53.254478Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS' 2018-08-24T00:57:53.255479Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES' 2018-08-24T00:57:53.256479Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS' 2018-08-24T00:57:53.257479Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES' 2018-08-24T00:57:53.259479Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE' 2018-08-24T00:57:53.260479Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE' 2018-08-24T00:57:53.261479Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG' 2018-08-24T00:57:53.262479Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED' 2018-08-24T00:57:53.263479Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED' 2018-08-24T00:57:53.264479Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD' 2018-08-24T00:57:53.266479Z 0 [Note] Shutting down plugin 'INNODB_METRICS' 2018-08-24T00:57:53.267479Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO' 2018-08-24T00:57:53.268479Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS' 2018-08-24T00:57:53.269479Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU' 2018-08-24T00:57:53.270479Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE' 2018-08-24T00:57:53.272480Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET' 2018-08-24T00:57:53.273480Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX' 2018-08-24T00:57:53.274480Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET' 2018-08-24T00:57:53.275480Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM' 2018-08-24T00:57:53.276480Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET' 2018-08-24T00:57:53.277480Z 0 [Note] Shutting down plugin 'INNODB_CMP' 2018-08-24T00:57:53.278480Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS' 2018-08-24T00:57:53.279480Z 0 [Note] Shutting down plugin 'INNODB_LOCKS' 2018-08-24T00:57:53.280480Z 0 [Note] Shutting down plugin 'INNODB_TRX' 2018-08-24T00:57:53.281480Z 0 [Note] Shutting down plugin 'InnoDB' 2018-08-24T00:57:53.282480Z 0 [Note] InnoDB: FTS optimize thread exiting. 2018-08-24T00:57:53.284480Z 0 [Note] InnoDB: Starting shutdown... 2018-08-24T00:57:53.385486Z 0 [Note] InnoDB: Dumping buffer pool(s) to D:\ushastry\MySQL\mysql-5.7.21-winx64\data\ib_buffer_pool 2018-08-24T00:57:53.393486Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 180824 6:27:53 2018-08-24T00:57:54.254536Z 0 [Note] InnoDB: Shutdown completed; log sequence number 2551194 2018-08-24T00:57:54.258536Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2018-08-24T00:57:54.260536Z 0 [Note] Shutting down plugin 'MEMORY' 2018-08-24T00:57:54.261536Z 0 [Note] Shutting down plugin 'CSV' 2018-08-24T00:57:54.262536Z 0 [Note] Shutting down plugin 'sha256_password' 2018-08-24T00:57:54.263536Z 0 [Note] Shutting down plugin 'mysql_native_password' 2018-08-24T00:57:54.265536Z 0 [Note] Shutting down plugin 'binlog' 2018-08-24T00:57:54.267536Z 0 [Note] bin\mysqld: Shutdown complete 2018-08-24T01:04:40.193754Z 0 [System] [MY-010116] [Server] D:\ushastry\MySQL\mysql-8.0.12-winx64\bin\mysqld.exe (mysqld 8.0.12) starting as process 9516 2018-08-24T01:04:59.208842Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed. 2018-08-24T01:04:59.463856Z 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-08-24T01:04:59.467857Z 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-08-24T01:04:59.573863Z 0 [Warning] [MY-010929] [Server] Storage engine 'MyISAM' does not support system tables. [mysql.user]. 2018-08-24T01:04:59.575863Z 0 [Warning] [MY-010929] [Server] Storage engine 'MyISAM' does not support system tables. [mysql.db]. 2018-08-24T01:04:59.577863Z 0 [Warning] [MY-010929] [Server] Storage engine 'MyISAM' does not support system tables. [mysql.tables_priv]. 2018-08-24T01:04:59.579863Z 0 [Warning] [MY-010929] [Server] Storage engine 'MyISAM' does not support system tables. [mysql.columns_priv]. 2018-08-24T01:04:59.581863Z 0 [Warning] [MY-010929] [Server] Storage engine 'MyISAM' does not support system tables. [mysql.procs_priv]. 2018-08-24T01:04:59.583863Z 0 [Warning] [MY-010929] [Server] Storage engine 'MyISAM' does not support system tables. [mysql.proxies_priv]. 2018-08-24T01:04:59.586863Z 0 [ERROR] [MY-013143] [Server] Column count of mysql.user is wrong. Expected 49, found 45. The table is probably corrupted 2018-08-24T01:04:59.588863Z 0 [Warning] [MY-010966] [Server] ACL table mysql.role_edges missing. Some operations may fail. 2018-08-24T01:04:59.590864Z 0 [Warning] [MY-010966] [Server] ACL table mysql.default_roles missing. Some operations may fail. 2018-08-24T01:04:59.592864Z 0 [Warning] [MY-010966] [Server] ACL table mysql.global_grants missing. Some operations may fail. 2018-08-24T01:04:59.593864Z 0 [Warning] [MY-010966] [Server] ACL table mysql.password_history missing. Some operations may fail. 2018-08-24T01:04:59.596864Z 0 [ERROR] [MY-010965] [Server] Missing system table mysql.global_grants; please run mysql_upgrade to create it. 2018-08-24T01:04:59.640866Z 0 [Warning] [MY-010727] [Server] System table 'func' is expected to be transactional. 2018-08-24T01:04:59.665868Z 0 [Warning] [MY-010405] [Repl] Info table is not ready to be used. Table 'mysql.slave_master_info' cannot be opened. 2018-08-24T01:04:59.667868Z 0 [ERROR] [MY-010422] [Repl] Error in checking mysql.slave_master_info repository info type of TABLE. 2018-08-24T01:04:59.669868Z 0 [ERROR] [MY-010415] [Repl] Error creating master info: Error checking repositories. 2018-08-24T01:04:59.671868Z 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-08-24T01:04:59.674868Z 0 [ERROR] [MY-010529] [Repl] Failed to create or recover replication info repositories. 2018-08-24T01:04:59.679869Z 0 [System] [MY-010931] [Server] D:\ushastry\MySQL\mysql-8.0.12-winx64\bin\mysqld.exe: ready for connections. Version: '8.0.12' socket: '' port: 3306 MySQL Community Server - GPL. 2018-08-24T01:06:49.904173Z 10 [Warning] [MY-010929] [Server] Storage engine 'MyISAM' does not support system tables. [mysql.user]. 2018-08-24T01:06:49.906173Z 10 [Warning] [MY-010929] [Server] Storage engine 'MyISAM' does not support system tables. [mysql.db]. 2018-08-24T01:06:49.908173Z 10 [Warning] [MY-010929] [Server] Storage engine 'MyISAM' does not support system tables. [mysql.tables_priv]. 2018-08-24T01:06:49.910173Z 10 [Warning] [MY-010929] [Server] Storage engine 'MyISAM' does not support system tables. [mysql.columns_priv]. 2018-08-24T01:06:49.912174Z 10 [Warning] [MY-010929] [Server] Storage engine 'MyISAM' does not support system tables. [mysql.procs_priv]. 2018-08-24T01:06:49.914174Z 10 [Warning] [MY-010929] [Server] Storage engine 'MyISAM' does not support system tables. [mysql.proxies_priv]. 2018-08-24T01:06:49.917174Z 10 [ERROR] [MY-013143] [Server] Column count of mysql.user is wrong. Expected 49, found 45. The table is probably corrupted 2018-08-24T01:06:56.379543Z 10 [Warning] [MY-010929] [Server] Storage engine 'MyISAM' does not support system tables. [mysql.user]. 2018-08-24T01:06:56.381544Z 10 [Warning] [MY-010929] [Server] Storage engine 'MyISAM' does not support system tables. [mysql.db]. 2018-08-24T01:06:56.383544Z 10 [Warning] [MY-010929] [Server] Storage engine 'MyISAM' does not support system tables. [mysql.tables_priv]. 2018-08-24T01:06:56.385544Z 10 [Warning] [MY-010929] [Server] Storage engine 'MyISAM' does not support system tables. [mysql.columns_priv]. 2018-08-24T01:06:56.387544Z 10 [Warning] [MY-010929] [Server] Storage engine 'MyISAM' does not support system tables. [mysql.procs_priv]. 2018-08-24T01:06:56.389544Z 10 [Warning] [MY-010929] [Server] Storage engine 'MyISAM' does not support system tables. [mysql.proxies_priv]. 2018-08-24T01:06:56.392544Z 10 [ERROR] [MY-013143] [Server] Column count of mysql.user is wrong. Expected 49, found 45. The table is probably corrupted 2018-08-24T01:08:19.033271Z 11 [System] [MY-013172] [Server] Received SHUTDOWN from user root. Shutting down mysqld (Version: 8.0.12). 2018-08-24T01:08:19.036271Z 0 [System] [MY-013105] [Server] D:\ushastry\MySQL\mysql-8.0.12-winx64\bin\mysqld.exe: Normal shutdown. 2018-08-24T01:08:20.399349Z 0 [System] [MY-010910] [Server] D:\ushastry\MySQL\mysql-8.0.12-winx64\bin\mysqld.exe: Shutdown complete (mysqld 8.0.12) MySQL Community Server - GPL. 2018-08-24T01:09:08.518809Z 0 [System] [MY-010116] [Server] D:\ushastry\MySQL\mysql-8.0.12-winx64\bin\mysqld.exe (mysqld 8.0.12) starting as process 10800 2018-08-24T01:09:13.448418Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed. 2018-08-24T01:09:13.588818Z 0 [System] [MY-010931] [Server] D:\ushastry\MySQL\mysql-8.0.12-winx64\bin\mysqld.exe: ready for connections. Version: '8.0.12' socket: '' port: 3306 MySQL Community Server - GPL.