Re: Lost connection MySQL server at 'reading initial'
Posted by: CE Stanley
Date: October 09, 2016 01:44PM
Date: October 09, 2016 01:44PM
I guess no one is reading my posts.
Below is more information. I am new to MySQL and have never got it running on my PC.
C:\Program Files\MySQL\MySQL Server 5.7\bin>mysqld.exe --log_error_verbosity=3 --defaults-file="C:\Program Files\MySQL\MySQL Server 5.7\my.ini" --standalone --console
2016-10-09T18:48:07.200622Z 0 [Warning] option 'max_allowed_packet': unsigned value 4294967296 adjusted to 1073741824
2016-10-09T18:48:07.200622Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2016-10-09T18:48:07.200622Z 0 [Warning] Insecure configuration for --secure-file-priv: Current value does not restrict location of generated files. Consider setting it to a valid, non-empty path.
2016-10-09T18:48:07.201623Z 0 [Note] mysqld.exe (mysqld 5.7.15) starting as process 12196 ...
2016-10-09T18:48:07.213625Z 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-10-09T18:48:07.214625Z 0 [Note] InnoDB: Uses event mutexes
2016-10-09T18:48:07.214625Z 0 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier
2016-10-09T18:48:07.214625Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-10-09T18:48:07.215625Z 0 [Note] InnoDB: Number of pools: 1
2016-10-09T18:48:07.215625Z 0 [Note] InnoDB: Not using CPU crc32 instructions
2016-10-09T18:48:07.220627Z 0 [Note] InnoDB: Initializing buffer pool, total size = 47M, instances = 1, chunk size = 47M
2016-10-09T18:48:07.224628Z 0 [Note] InnoDB: Completed initialization of buffer pool
2016-10-09T18:48:07.258662Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2016-10-09T18:48:07.314724Z 0 [ERROR] InnoDB: Operating system error number 2 in a file operation.
2016-10-09T18:48:07.314724Z 0 [Note] InnoDB: Some operating system error numbers are described at http://dev.mysql.com/doc/refman/5.7/en/operating-system-error-codes.html
2016-10-09T18:48:07.314724Z 0 [ERROR] InnoDB: Cannot open datafile for read-only: '.\mysql\engine_cost.ibd' OS error: 71
2016-10-09T18:48:07.315725Z 0 [ERROR] InnoDB: Could not find a valid tablespace file for `mysql/engine_cost`. Please refer to http://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting-datadict.html for how to resolve the issue.
2016-10-09T18:48:07.315725Z 0 [Warning] InnoDB: Ignoring tablespace `mysql/engine_cost` because it could not be opened.
2016-10-09T18:48:07.315725Z 0 [ERROR] InnoDB: Operating system error number 2 in a file operation.
2016-10-09T18:48:07.316726Z 0 [Note] InnoDB: Some operating system error numbers are described at http://dev.mysql.com/doc/refman/5.7/en/operating-system-error-codes.html
2016-10-09T18:48:07.316726Z 0 [ERROR] InnoDB: Cannot open datafile for read-only: '.\mysql\gtid_executed.ibd' OS error: 71
2016-10-09T18:48:07.316726Z 0 [ERROR] InnoDB: Could not find a valid tablespace file for `mysql/gtid_executed`. Please refer to http://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting-datadict.html for how to resolve the issue.
2016-10-09T18:48:07.316726Z 0 [Warning] InnoDB: Ignoring tablespace `mysql/gtid_executed` because it could not be opened.
2016-10-09T18:48:07.317726Z 0 [ERROR] InnoDB: Operating system error number 2 in a file operation.
2016-10-09T18:48:07.317726Z 0 [Note] InnoDB: Some operating system error numbers are described at http://dev.mysql.com/doc/refman/5.7/en/operating-system-error-codes.html
2016-10-09T18:48:07.317726Z 0 [ERROR] InnoDB: Cannot open datafile for read-only: '.\mysql\help_category.ibd' OS error: 71
2016-10-09T18:48:07.317726Z 0 [ERROR] InnoDB: Could not find a valid tablespace file for `mysql/help_category`. Please refer to http://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting-datadict.html for how to resolve the issue.
2016-10-09T18:48:07.318726Z 0 [Warning] InnoDB: Ignoring tablespace `mysql/help_category` because it could not be opened.
2016-10-09T18:48:07.318726Z 0 [ERROR] InnoDB: Operating system error number 2 in a file operation.
2016-10-09T18:48:07.318726Z 0 [Note] InnoDB: Some operating system error numbers are described at http://dev.mysql.com/doc/refman/5.7/en/operating-system-error-codes.html
2016-10-09T18:48:07.318726Z 0 [ERROR] InnoDB: Cannot open datafile for read-only: '.\mysql\help_keyword.ibd' OS error: 71
2016-10-09T18:48:07.319728Z 0 [ERROR] InnoDB: Could not find a valid tablespace file for `mysql/help_keyword`. Please refer to http://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting-datadict.html for how to resolve the issue.
2016-10-09T18:48:07.319728Z 0 [Warning] InnoDB: Ignoring tablespace `mysql/help_keyword` because it could not be opened.
2016-10-09T18:48:07.319728Z 0 [ERROR] InnoDB: Operating system error number 2 in a file operation.
2016-10-09T18:48:07.319728Z 0 [Note] InnoDB: Some operating system error numbers are described at http://dev.mysql.com/doc/refman/5.7/en/operating-system-error-codes.html
2016-10-09T18:48:07.320726Z 0 [ERROR] InnoDB: Cannot open datafile for read-only: '.\mysql\help_relation.ibd' OS error: 71
2016-10-09T18:48:07.320726Z 0 [ERROR] InnoDB: Could not find a valid tablespace file for `mysql/help_relation`. Please refer to http://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting-datadict.html for how to resolve the issue.
2016-10-09T18:48:07.320726Z 0 [Warning] InnoDB: Ignoring tablespace `mysql/help_relation` because it could not be opened.
2016-10-09T18:48:07.321727Z 0 [ERROR] InnoDB: Operating system error number 2 in a file operation.
2016-10-09T18:48:07.321727Z 0 [Note] InnoDB: Some operating system error numbers are described at http://dev.mysql.com/doc/refman/5.7/en/operating-system-error-codes.html
2016-10-09T18:48:07.321727Z 0 [ERROR] InnoDB: Cannot open datafile for read-only: '.\mysql\help_topic.ibd' OS error: 71
2016-10-09T18:48:07.321727Z 0 [ERROR] InnoDB: Could not find a valid tablespace file for `mysql/help_topic`. Please refer to http://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting-datadict.html for how to resolve the issue.
2016-10-09T18:48:07.321727Z 0 [Warning] InnoDB: Ignoring tablespace `mysql/help_topic` because it could not be opened.
2016-10-09T18:48:07.322727Z 0 [ERROR] InnoDB: Operating system error number 2 in a file operation.
2016-10-09T18:48:07.322727Z 0 [Note] InnoDB: Some operating system error numbers are described at http://dev.mysql.com/doc/refman/5.7/en/operating-system-error-codes.html
2016-10-09T18:48:07.322727Z 0 [ERROR] InnoDB: Cannot open datafile for read-only: '.\mysql\innodb_index_stats.ibd' OS error: 71
2016-10-09T18:48:07.323727Z 0 [ERROR] InnoDB: Could not find a valid tablespace file for `mysql/innodb_index_stats`. Please refer to http://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting-datadict.html for how to resolve the issue.
2016-10-09T18:48:07.325730Z 0 [Warning] InnoDB: Ignoring tablespace `mysql/innodb_index_stats` because it could not be opened.
2016-10-09T18:48:07.326730Z 0 [ERROR] InnoDB: Operating system error number 2 in a file operation.
2016-10-09T18:48:07.328222Z 0 [Note] InnoDB: Some operating system error numbers are described at http://dev.mysql.com/doc/refman/5.7/en/operating-system-error-codes.html
2016-10-09T18:48:07.329227Z 0 [ERROR] InnoDB: Cannot open datafile for read-only: '.\mysql\innodb_table_stats.ibd' OS error: 71
2016-10-09T18:48:07.330565Z 0 [ERROR] InnoDB: Could not find a valid tablespace file for `mysql/innodb_table_stats`. Please refer to http://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting-datadict.html for how to resolve the issue.
2016-10-09T18:48:07.331699Z 0 [Warning] InnoDB: Ignoring tablespace `mysql/innodb_table_stats` because it could not be opened.
2016-10-09T18:48:07.332703Z 0 [ERROR] InnoDB: Operating system error number 2 in a file operation.
2016-10-09T18:48:07.333706Z 0 [Note] InnoDB: Some operating system error numbers are described at http://dev.mysql.com/doc/refman/5.7/en/operating-system-error-codes.html
2016-10-09T18:48:07.336703Z 0 [ERROR] InnoDB: Cannot open datafile for read-only: '.\mysql\plugin.ibd' OS error: 71
2016-10-09T18:48:07.338702Z 0 [ERROR] InnoDB: Could not find a valid tablespace file for `mysql/plugin`. Please refer to http://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting-datadict.html for how to resolve the issue.
2016-10-09T18:48:07.339705Z 0 [Warning] InnoDB: Ignoring tablespace `mysql/plugin` because it could not be opened.
2016-10-09T18:48:07.340705Z 0 [ERROR] InnoDB: Operating system error number 2 in a file operation.
2016-10-09T18:48:07.341705Z 0 [Note] InnoDB: Some operating system error numbers are described at http://dev.mysql.com/doc/refman/5.7/en/operating-system-error-codes.html
2016-10-09T18:48:07.342706Z 0 [ERROR] InnoDB: Cannot open datafile for read-only: '.\mysql\server_cost.ibd' OS error: 71
2016-10-09T18:48:07.344705Z 0 [ERROR] InnoDB: Could not find a valid tablespace file for `mysql/server_cost`. Please refer to http://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting-datadict.html for how to resolve the issue.
2016-10-09T18:48:07.347706Z 0 [Warning] InnoDB: Ignoring tablespace `mysql/server_cost` because it could not be opened.
2016-10-09T18:48:07.348707Z 0 [ERROR] InnoDB: Operating system error number 2 in a file operation.
2016-10-09T18:48:07.349707Z 0 [Note] InnoDB: Some operating system error numbers are described at http://dev.mysql.com/doc/refman/5.7/en/operating-system-error-codes.html
2016-10-09T18:48:07.351705Z 0 [ERROR] InnoDB: Cannot open datafile for read-only: '.\mysql\servers.ibd' OS error: 71
2016-10-09T18:48:07.352707Z 0 [ERROR] InnoDB: Could not find a valid tablespace file for `mysql/servers`. Please refer to http://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting-datadict.html for how to resolve the issue.
2016-10-09T18:48:07.353707Z 0 [Warning] InnoDB: Ignoring tablespace `mysql/servers` because it could not be opened.
2016-10-09T18:48:07.354708Z 0 [ERROR] InnoDB: Operating system error number 2 in a file operation.
2016-10-09T18:48:07.356706Z 0 [Note] InnoDB: Some operating system error numbers are described at http://dev.mysql.com/doc/refman/5.7/en/operating-system-error-codes.html
2016-10-09T18:48:07.359706Z 0 [ERROR] InnoDB: Cannot open datafile for read-only: '.\mysql\slave_master_info.ibd' OS error: 71
2016-10-09T18:48:07.360709Z 0 [ERROR] InnoDB: Could not find a valid tablespace file for `mysql/slave_master_info`. Please refer to http://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting-datadict.html for how to resolve the issue.
2016-10-09T18:48:07.361709Z 0 [Warning] InnoDB: Ignoring tablespace `mysql/slave_master_info` because it could not be opened.
2016-10-09T18:48:07.362709Z 0 [ERROR] InnoDB: Operating system error number 2 in a file operation.
2016-10-09T18:48:07.364148Z 0 [Note] InnoDB: Some operating system error numbers are described at http://dev.mysql.com/doc/refman/5.7/en/operating-system-error-codes.html
2016-10-09T18:48:07.365150Z 0 [ERROR] InnoDB: Cannot open datafile for read-only: '.\mysql\slave_relay_log_info.ibd' OS error: 71
2016-10-09T18:48:07.366150Z 0 [ERROR] InnoDB: Could not find a valid tablespace file for `mysql/slave_relay_log_info`. Please refer to http://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting-datadict.html for how to resolve the issue.
2016-10-09T18:48:07.368150Z 0 [Warning] InnoDB: Ignoring tablespace `mysql/slave_relay_log_info` because it could not be opened.
2016-10-09T18:48:07.371151Z 0 [ERROR] InnoDB: Operating system error number 2 in a file operation.
2016-10-09T18:48:07.372151Z 0 [Note] InnoDB: Some operating system error numbers are described at http://dev.mysql.com/doc/refman/5.7/en/operating-system-error-codes.html
2016-10-09T18:48:07.373152Z 0 [ERROR] InnoDB: Cannot open datafile for read-only: '.\mysql\slave_worker_info.ibd' OS error: 71
2016-10-09T18:48:07.374548Z 0 [ERROR] InnoDB: Could not find a valid tablespace file for `mysql/slave_worker_info`. Please refer to http://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting-datadict.html for how to resolve the issue.
2016-10-09T18:48:07.375550Z 0 [Warning] InnoDB: Ignoring tablespace `mysql/slave_worker_info` because it could not be opened.
2016-10-09T18:48:07.377082Z 0 [ERROR] InnoDB: Operating system error number 2 in a file operation.
2016-10-09T18:48:07.378087Z 0 [Note] InnoDB: Some operating system error numbers are described at http://dev.mysql.com/doc/refman/5.7/en/operating-system-error-codes.html
2016-10-09T18:48:07.381085Z 0 [ERROR] InnoDB: Cannot open datafile for read-only: '.\mysql\time_zone.ibd' OS error: 71
2016-10-09T18:48:07.382088Z 0 [ERROR] InnoDB: Could not find a valid tablespace file for `mysql/time_zone`. Please refer to http://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting-datadict.html for how to resolve the issue.
2016-10-09T18:48:07.383088Z 0 [Warning] InnoDB: Ignoring tablespace `mysql/time_zone` because it could not be opened.
2016-10-09T18:48:07.384088Z 0 [ERROR] InnoDB: Operating system error number 2 in a file operation.
2016-10-09T18:48:07.385088Z 0 [Note] InnoDB: Some operating system error numbers are described at http://dev.mysql.com/doc/refman/5.7/en/operating-system-error-codes.html
2016-10-09T18:48:07.386088Z 0 [ERROR] InnoDB: Cannot open datafile for read-only: '.\mysql\time_zone_leap_second.ibd' OS error: 71
2016-10-09T18:48:07.387089Z 0 [ERROR] InnoDB: Could not find a valid tablespace file for `mysql/time_zone_leap_second`. Please refer to http://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting-datadict.html for how to resolve the issue.
2016-10-09T18:48:07.388089Z 0 [Warning] InnoDB: Ignoring tablespace `mysql/time_zone_leap_second` because it could not be opened.
2016-10-09T18:48:07.390087Z 0 [ERROR] InnoDB: Operating system error number 2 in a file operation.
2016-10-09T18:48:07.393088Z 0 [Note] InnoDB: Some operating system error numbers are described at http://dev.mysql.com/doc/refman/5.7/en/operating-system-error-codes.html
2016-10-09T18:48:07.394088Z 0 [ERROR] InnoDB: Cannot open datafile for read-only: '.\mysql\time_zone_name.ibd' OS error: 71
2016-10-09T18:48:07.395089Z 0 [ERROR] InnoDB: Could not find a valid tablespace file for `mysql/time_zone_name`. Please refer to http://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting-datadict.html for how to resolve the issue.
2016-10-09T18:48:07.396090Z 0 [Warning] InnoDB: Ignoring tablespace `mysql/time_zone_name` because it could not be opened.
2016-10-09T18:48:07.397088Z 0 [ERROR] InnoDB: Operating system error number 2 in a file operation.
2016-10-09T18:48:07.398091Z 0 [Note] InnoDB: Some operating system error numbers are described at http://dev.mysql.com/doc/refman/5.7/en/operating-system-error-codes.html
2016-10-09T18:48:07.399091Z 0 [ERROR] InnoDB: Cannot open datafile for read-only: '.\mysql\time_zone_transition.ibd' OS error: 71
2016-10-09T18:48:07.400091Z 0 [ERROR] InnoDB: Could not find a valid tablespace file for `mysql/time_zone_transition`. Please refer to http://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting-datadict.html for how to resolve the issue.
2016-10-09T18:48:07.403091Z 0 [Warning] InnoDB: Ignoring tablespace `mysql/time_zone_transition` because it could not be opened.
2016-10-09T18:48:07.404092Z 0 [ERROR] InnoDB: Operating system error number 2 in a file operation.
2016-10-09T18:48:07.405092Z 0 [Note] InnoDB: Some operating system error numbers are described at http://dev.mysql.com/doc/refman/5.7/en/operating-system-error-codes.html
2016-10-09T18:48:07.406093Z 0 [ERROR] InnoDB: Cannot open datafile for read-only: '.\mysql\time_zone_transition_type.ibd' OS error: 71
2016-10-09T18:48:07.408091Z 0 [ERROR] InnoDB: Could not find a valid tablespace file for `mysql/time_zone_transition_type`. Please refer to http://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting-datadict.html for how to resolve the issue.
2016-10-09T18:48:07.409091Z 0 [Warning] InnoDB: Ignoring tablespace `mysql/time_zone_transition_type` because it could not be opened.
2016-10-09T18:48:07.410095Z 0 [ERROR] InnoDB: Operating system error number 2 in a file operation.
2016-10-09T18:48:07.411094Z 0 [Note] InnoDB: Some operating system error numbers are described at http://dev.mysql.com/doc/refman/5.7/en/operating-system-error-codes.html
2016-10-09T18:48:07.414126Z 0 [ERROR] InnoDB: Cannot open datafile for read-only: '.\sys\sys_config.ibd' OS error: 71
2016-10-09T18:48:07.415094Z 0 [ERROR] InnoDB: Could not find a valid tablespace file for `sys/sys_config`. Please refer to http://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting-datadict.html for how to resolve the issue.
2016-10-09T18:48:07.416095Z 0 [Warning] InnoDB: Ignoring tablespace `sys/sys_config` because it could not be opened.
2016-10-09T18:48:07.418093Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2016-10-09T18:48:07.419093Z 0 [Note] InnoDB: Setting file '.\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2016-10-09T18:48:07.490236Z 0 [Note] InnoDB: File '.\ibtmp1' size is now 12 MB.
2016-10-09T18:48:07.493469Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2016-10-09T18:48:07.494467Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2016-10-09T18:48:07.496272Z 0 [Note] InnoDB: Waiting for purge to start
2016-10-09T18:48:07.499277Z 0 [ERROR] InnoDB: Failed to find tablespace for table `mysql`.`innodb_index_stats` in the cache. Attempting to load the tablespace with space id 14
2016-10-09T18:48:07.499277Z 0 [ERROR] InnoDB: Operating system error number 2 in a file operation.
2016-10-09T18:48:07.502277Z 0 [Note] InnoDB: Some operating system error numbers are described at http://dev.mysql.com/doc/refman/5.7/en/operating-system-error-codes.html
2016-10-09T18:48:07.503278Z 0 [ERROR] InnoDB: Cannot open datafile for read-only: '.\mysql\innodb_index_stats.ibd' OS error: 71
2016-10-09T18:48:07.505279Z 0 [ERROR] InnoDB: Could not find a valid tablespace file for `mysql/innodb_index_stats`. Please refer to http://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting-datadict.html for how to resolve the issue.
2016-10-09T18:48:07.506279Z 0 [ERROR] InnoDB: Failed to find tablespace for table `mysql`.`innodb_table_stats` in the cache. Attempting to load the tablespace with space id 13
2016-10-09T18:48:07.507279Z 0 [ERROR] InnoDB: Operating system error number 2 in a file operation.
2016-10-09T18:48:07.509277Z 0 [Note] InnoDB: Some operating system error numbers are described at http://dev.mysql.com/doc/refman/5.7/en/operating-system-error-codes.html
2016-10-09T18:48:07.510277Z 0 [ERROR] InnoDB: Cannot open datafile for read-only: '.\mysql\innodb_table_stats.ibd' OS error: 71
2016-10-09T18:48:07.513281Z 0 [ERROR] InnoDB: Could not find a valid tablespace file for `mysql/innodb_table_stats`. Please refer to http://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting-datadict.html for how to resolve the issue.
2016-10-09T18:48:07.548206Z 0 [Note] InnoDB: 5.7.15 started; log sequence number 2529691
2016-10-09T18:48:07.549209Z 0 [Note] Plugin 'FEDERATED' is disabled.
2016-10-09T18:48:07.550213Z 0 [Note] InnoDB: Loading buffer pool(s) from C:\Program Files\MySQL\MySQL Server 5.7\Data\ib_buffer_pool
2016-10-09T18:48:07.553209Z 0 [Note] InnoDB: Buffer pool(s) load completed at 161009 11:48:07
2016-10-09T18:48:07.556210Z 0 [ERROR] InnoDB: Failed to find tablespace for table `mysql`.`plugin` in the cache. Attempting to load the tablespace with space id 2
2016-10-09T18:48:07.556210Z 0 [ERROR] InnoDB: Operating system error number 2 in a file operation.
2016-10-09T18:48:07.558210Z 0 [Note] InnoDB: Some operating system error numbers are described at http://dev.mysql.com/doc/refman/5.7/en/operating-system-error-codes.html
2016-10-09T18:48:07.561211Z 0 [ERROR] InnoDB: Cannot open datafile for read-only: '.\mysql\plugin.ibd' OS error: 71
2016-10-09T18:48:07.562213Z 0 [ERROR] InnoDB: Could not find a valid tablespace file for `mysql/plugin`. Please refer to http://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting-datadict.html for how to resolve the issue.
2016-10-09T18:48:07.563214Z 0 [Warning] InnoDB: Cannot calculate statistics for table `mysql`.`plugin` because the .ibd file is missing. Please refer to http://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting.html for how to resolve the issue.
mysqld: Tablespace is missing for table `mysql`.`plugin`.
2016-10-09T18:48:07.566211Z 0 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
2016-10-09T18:48:07.567214Z 0 [ERROR] unknown variable 'time-wait=120'
2016-10-09T18:48:07.568216Z 0 [ERROR] Aborting
2016-10-09T18:48:07.571215Z 0 [Note] Binlog end
2016-10-09T18:48:07.572216Z 0 [Note] Shutting down plugin 'ngram'
2016-10-09T18:48:07.573216Z 0 [Note] Shutting down plugin 'partition'
2016-10-09T18:48:07.574505Z 0 [Note] Shutting down plugin 'BLACKHOLE'
2016-10-09T18:48:07.575509Z 0 [Note] Shutting down plugin 'ARCHIVE'
2016-10-09T18:48:07.577611Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2016-10-09T18:48:07.578616Z 0 [Note] Shutting down plugin 'MRG_MYISAM'
2016-10-09T18:48:07.581629Z 0 [Note] Shutting down plugin 'MyISAM'
2016-10-09T18:48:07.582634Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL'
2016-10-09T18:48:07.583634Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2016-10-09T18:48:07.584633Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2016-10-09T18:48:07.585634Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2016-10-09T18:48:07.586634Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2016-10-09T18:48:07.587635Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2016-10-09T18:48:07.588635Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2016-10-09T18:48:07.591633Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2016-10-09T18:48:07.592636Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2016-10-09T18:48:07.594634Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2016-10-09T18:48:07.595634Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2016-10-09T18:48:07.596636Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2016-10-09T18:48:07.597636Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2016-10-09T18:48:07.598637Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2016-10-09T18:48:07.599637Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2016-10-09T18:48:07.602637Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2016-10-09T18:48:07.603638Z 0 [Note] Shutting down plugin 'INNODB_METRICS'
2016-10-09T18:48:07.604638Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO'
2016-10-09T18:48:07.606025Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2016-10-09T18:48:07.607029Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2016-10-09T18:48:07.608029Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2016-10-09T18:48:07.609028Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2016-10-09T18:48:07.610027Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2016-10-09T18:48:07.613030Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2016-10-09T18:48:07.614030Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM'
2016-10-09T18:48:07.615030Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2016-10-09T18:48:07.616031Z 0 [Note] Shutting down plugin 'INNODB_CMP'
2016-10-09T18:48:07.617031Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2016-10-09T18:48:07.618031Z 0 [Note] Shutting down plugin 'INNODB_LOCKS'
2016-10-09T18:48:07.619031Z 0 [Note] Shutting down plugin 'INNODB_TRX'
2016-10-09T18:48:07.621029Z 0 [Note] Shutting down plugin 'InnoDB'
2016-10-09T18:48:07.622032Z 0 [Note] InnoDB: FTS optimize thread exiting.
2016-10-09T18:48:07.625033Z 0 [Note] InnoDB: Starting shutdown...
2016-10-09T18:48:07.726668Z 0 [Note] InnoDB: Dumping buffer pool(s) to C:\Program Files\MySQL\MySQL Server 5.7\Data\ib_buffer_pool
2016-10-09T18:48:07.729201Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 161009 11:48:07
2016-10-09T18:48:08.840324Z 0 [Note] InnoDB: Shutdown completed; log sequence number 2529710
2016-10-09T18:48:08.841328Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2016-10-09T18:48:08.843328Z 0 [Note] Shutting down plugin 'MEMORY'
2016-10-09T18:48:08.845771Z 0 [Note] Shutting down plugin 'CSV'
2016-10-09T18:48:08.846774Z 0 [Note] Shutting down plugin 'sha256_password'
2016-10-09T18:48:08.848004Z 0 [Note] Shutting down plugin 'mysql_native_password'
2016-10-09T18:48:08.849007Z 0 [Note] Shutting down plugin 'binlog'
2016-10-09T18:48:08.850006Z 0 [Note] mysqld.exe: Shutdown complete
C:\Program Files\MySQL\MySQL Server 5.7\bin>
This is after uninstalling and reinstalling MySQL on a Windows 10 PC.
The first error seems to imply a file is missing or was not installed.
Below is more information. I am new to MySQL and have never got it running on my PC.
C:\Program Files\MySQL\MySQL Server 5.7\bin>mysqld.exe --log_error_verbosity=3 --defaults-file="C:\Program Files\MySQL\MySQL Server 5.7\my.ini" --standalone --console
2016-10-09T18:48:07.200622Z 0 [Warning] option 'max_allowed_packet': unsigned value 4294967296 adjusted to 1073741824
2016-10-09T18:48:07.200622Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2016-10-09T18:48:07.200622Z 0 [Warning] Insecure configuration for --secure-file-priv: Current value does not restrict location of generated files. Consider setting it to a valid, non-empty path.
2016-10-09T18:48:07.201623Z 0 [Note] mysqld.exe (mysqld 5.7.15) starting as process 12196 ...
2016-10-09T18:48:07.213625Z 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-10-09T18:48:07.214625Z 0 [Note] InnoDB: Uses event mutexes
2016-10-09T18:48:07.214625Z 0 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier
2016-10-09T18:48:07.214625Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-10-09T18:48:07.215625Z 0 [Note] InnoDB: Number of pools: 1
2016-10-09T18:48:07.215625Z 0 [Note] InnoDB: Not using CPU crc32 instructions
2016-10-09T18:48:07.220627Z 0 [Note] InnoDB: Initializing buffer pool, total size = 47M, instances = 1, chunk size = 47M
2016-10-09T18:48:07.224628Z 0 [Note] InnoDB: Completed initialization of buffer pool
2016-10-09T18:48:07.258662Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2016-10-09T18:48:07.314724Z 0 [ERROR] InnoDB: Operating system error number 2 in a file operation.
2016-10-09T18:48:07.314724Z 0 [Note] InnoDB: Some operating system error numbers are described at http://dev.mysql.com/doc/refman/5.7/en/operating-system-error-codes.html
2016-10-09T18:48:07.314724Z 0 [ERROR] InnoDB: Cannot open datafile for read-only: '.\mysql\engine_cost.ibd' OS error: 71
2016-10-09T18:48:07.315725Z 0 [ERROR] InnoDB: Could not find a valid tablespace file for `mysql/engine_cost`. Please refer to http://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting-datadict.html for how to resolve the issue.
2016-10-09T18:48:07.315725Z 0 [Warning] InnoDB: Ignoring tablespace `mysql/engine_cost` because it could not be opened.
2016-10-09T18:48:07.315725Z 0 [ERROR] InnoDB: Operating system error number 2 in a file operation.
2016-10-09T18:48:07.316726Z 0 [Note] InnoDB: Some operating system error numbers are described at http://dev.mysql.com/doc/refman/5.7/en/operating-system-error-codes.html
2016-10-09T18:48:07.316726Z 0 [ERROR] InnoDB: Cannot open datafile for read-only: '.\mysql\gtid_executed.ibd' OS error: 71
2016-10-09T18:48:07.316726Z 0 [ERROR] InnoDB: Could not find a valid tablespace file for `mysql/gtid_executed`. Please refer to http://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting-datadict.html for how to resolve the issue.
2016-10-09T18:48:07.316726Z 0 [Warning] InnoDB: Ignoring tablespace `mysql/gtid_executed` because it could not be opened.
2016-10-09T18:48:07.317726Z 0 [ERROR] InnoDB: Operating system error number 2 in a file operation.
2016-10-09T18:48:07.317726Z 0 [Note] InnoDB: Some operating system error numbers are described at http://dev.mysql.com/doc/refman/5.7/en/operating-system-error-codes.html
2016-10-09T18:48:07.317726Z 0 [ERROR] InnoDB: Cannot open datafile for read-only: '.\mysql\help_category.ibd' OS error: 71
2016-10-09T18:48:07.317726Z 0 [ERROR] InnoDB: Could not find a valid tablespace file for `mysql/help_category`. Please refer to http://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting-datadict.html for how to resolve the issue.
2016-10-09T18:48:07.318726Z 0 [Warning] InnoDB: Ignoring tablespace `mysql/help_category` because it could not be opened.
2016-10-09T18:48:07.318726Z 0 [ERROR] InnoDB: Operating system error number 2 in a file operation.
2016-10-09T18:48:07.318726Z 0 [Note] InnoDB: Some operating system error numbers are described at http://dev.mysql.com/doc/refman/5.7/en/operating-system-error-codes.html
2016-10-09T18:48:07.318726Z 0 [ERROR] InnoDB: Cannot open datafile for read-only: '.\mysql\help_keyword.ibd' OS error: 71
2016-10-09T18:48:07.319728Z 0 [ERROR] InnoDB: Could not find a valid tablespace file for `mysql/help_keyword`. Please refer to http://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting-datadict.html for how to resolve the issue.
2016-10-09T18:48:07.319728Z 0 [Warning] InnoDB: Ignoring tablespace `mysql/help_keyword` because it could not be opened.
2016-10-09T18:48:07.319728Z 0 [ERROR] InnoDB: Operating system error number 2 in a file operation.
2016-10-09T18:48:07.319728Z 0 [Note] InnoDB: Some operating system error numbers are described at http://dev.mysql.com/doc/refman/5.7/en/operating-system-error-codes.html
2016-10-09T18:48:07.320726Z 0 [ERROR] InnoDB: Cannot open datafile for read-only: '.\mysql\help_relation.ibd' OS error: 71
2016-10-09T18:48:07.320726Z 0 [ERROR] InnoDB: Could not find a valid tablespace file for `mysql/help_relation`. Please refer to http://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting-datadict.html for how to resolve the issue.
2016-10-09T18:48:07.320726Z 0 [Warning] InnoDB: Ignoring tablespace `mysql/help_relation` because it could not be opened.
2016-10-09T18:48:07.321727Z 0 [ERROR] InnoDB: Operating system error number 2 in a file operation.
2016-10-09T18:48:07.321727Z 0 [Note] InnoDB: Some operating system error numbers are described at http://dev.mysql.com/doc/refman/5.7/en/operating-system-error-codes.html
2016-10-09T18:48:07.321727Z 0 [ERROR] InnoDB: Cannot open datafile for read-only: '.\mysql\help_topic.ibd' OS error: 71
2016-10-09T18:48:07.321727Z 0 [ERROR] InnoDB: Could not find a valid tablespace file for `mysql/help_topic`. Please refer to http://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting-datadict.html for how to resolve the issue.
2016-10-09T18:48:07.321727Z 0 [Warning] InnoDB: Ignoring tablespace `mysql/help_topic` because it could not be opened.
2016-10-09T18:48:07.322727Z 0 [ERROR] InnoDB: Operating system error number 2 in a file operation.
2016-10-09T18:48:07.322727Z 0 [Note] InnoDB: Some operating system error numbers are described at http://dev.mysql.com/doc/refman/5.7/en/operating-system-error-codes.html
2016-10-09T18:48:07.322727Z 0 [ERROR] InnoDB: Cannot open datafile for read-only: '.\mysql\innodb_index_stats.ibd' OS error: 71
2016-10-09T18:48:07.323727Z 0 [ERROR] InnoDB: Could not find a valid tablespace file for `mysql/innodb_index_stats`. Please refer to http://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting-datadict.html for how to resolve the issue.
2016-10-09T18:48:07.325730Z 0 [Warning] InnoDB: Ignoring tablespace `mysql/innodb_index_stats` because it could not be opened.
2016-10-09T18:48:07.326730Z 0 [ERROR] InnoDB: Operating system error number 2 in a file operation.
2016-10-09T18:48:07.328222Z 0 [Note] InnoDB: Some operating system error numbers are described at http://dev.mysql.com/doc/refman/5.7/en/operating-system-error-codes.html
2016-10-09T18:48:07.329227Z 0 [ERROR] InnoDB: Cannot open datafile for read-only: '.\mysql\innodb_table_stats.ibd' OS error: 71
2016-10-09T18:48:07.330565Z 0 [ERROR] InnoDB: Could not find a valid tablespace file for `mysql/innodb_table_stats`. Please refer to http://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting-datadict.html for how to resolve the issue.
2016-10-09T18:48:07.331699Z 0 [Warning] InnoDB: Ignoring tablespace `mysql/innodb_table_stats` because it could not be opened.
2016-10-09T18:48:07.332703Z 0 [ERROR] InnoDB: Operating system error number 2 in a file operation.
2016-10-09T18:48:07.333706Z 0 [Note] InnoDB: Some operating system error numbers are described at http://dev.mysql.com/doc/refman/5.7/en/operating-system-error-codes.html
2016-10-09T18:48:07.336703Z 0 [ERROR] InnoDB: Cannot open datafile for read-only: '.\mysql\plugin.ibd' OS error: 71
2016-10-09T18:48:07.338702Z 0 [ERROR] InnoDB: Could not find a valid tablespace file for `mysql/plugin`. Please refer to http://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting-datadict.html for how to resolve the issue.
2016-10-09T18:48:07.339705Z 0 [Warning] InnoDB: Ignoring tablespace `mysql/plugin` because it could not be opened.
2016-10-09T18:48:07.340705Z 0 [ERROR] InnoDB: Operating system error number 2 in a file operation.
2016-10-09T18:48:07.341705Z 0 [Note] InnoDB: Some operating system error numbers are described at http://dev.mysql.com/doc/refman/5.7/en/operating-system-error-codes.html
2016-10-09T18:48:07.342706Z 0 [ERROR] InnoDB: Cannot open datafile for read-only: '.\mysql\server_cost.ibd' OS error: 71
2016-10-09T18:48:07.344705Z 0 [ERROR] InnoDB: Could not find a valid tablespace file for `mysql/server_cost`. Please refer to http://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting-datadict.html for how to resolve the issue.
2016-10-09T18:48:07.347706Z 0 [Warning] InnoDB: Ignoring tablespace `mysql/server_cost` because it could not be opened.
2016-10-09T18:48:07.348707Z 0 [ERROR] InnoDB: Operating system error number 2 in a file operation.
2016-10-09T18:48:07.349707Z 0 [Note] InnoDB: Some operating system error numbers are described at http://dev.mysql.com/doc/refman/5.7/en/operating-system-error-codes.html
2016-10-09T18:48:07.351705Z 0 [ERROR] InnoDB: Cannot open datafile for read-only: '.\mysql\servers.ibd' OS error: 71
2016-10-09T18:48:07.352707Z 0 [ERROR] InnoDB: Could not find a valid tablespace file for `mysql/servers`. Please refer to http://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting-datadict.html for how to resolve the issue.
2016-10-09T18:48:07.353707Z 0 [Warning] InnoDB: Ignoring tablespace `mysql/servers` because it could not be opened.
2016-10-09T18:48:07.354708Z 0 [ERROR] InnoDB: Operating system error number 2 in a file operation.
2016-10-09T18:48:07.356706Z 0 [Note] InnoDB: Some operating system error numbers are described at http://dev.mysql.com/doc/refman/5.7/en/operating-system-error-codes.html
2016-10-09T18:48:07.359706Z 0 [ERROR] InnoDB: Cannot open datafile for read-only: '.\mysql\slave_master_info.ibd' OS error: 71
2016-10-09T18:48:07.360709Z 0 [ERROR] InnoDB: Could not find a valid tablespace file for `mysql/slave_master_info`. Please refer to http://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting-datadict.html for how to resolve the issue.
2016-10-09T18:48:07.361709Z 0 [Warning] InnoDB: Ignoring tablespace `mysql/slave_master_info` because it could not be opened.
2016-10-09T18:48:07.362709Z 0 [ERROR] InnoDB: Operating system error number 2 in a file operation.
2016-10-09T18:48:07.364148Z 0 [Note] InnoDB: Some operating system error numbers are described at http://dev.mysql.com/doc/refman/5.7/en/operating-system-error-codes.html
2016-10-09T18:48:07.365150Z 0 [ERROR] InnoDB: Cannot open datafile for read-only: '.\mysql\slave_relay_log_info.ibd' OS error: 71
2016-10-09T18:48:07.366150Z 0 [ERROR] InnoDB: Could not find a valid tablespace file for `mysql/slave_relay_log_info`. Please refer to http://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting-datadict.html for how to resolve the issue.
2016-10-09T18:48:07.368150Z 0 [Warning] InnoDB: Ignoring tablespace `mysql/slave_relay_log_info` because it could not be opened.
2016-10-09T18:48:07.371151Z 0 [ERROR] InnoDB: Operating system error number 2 in a file operation.
2016-10-09T18:48:07.372151Z 0 [Note] InnoDB: Some operating system error numbers are described at http://dev.mysql.com/doc/refman/5.7/en/operating-system-error-codes.html
2016-10-09T18:48:07.373152Z 0 [ERROR] InnoDB: Cannot open datafile for read-only: '.\mysql\slave_worker_info.ibd' OS error: 71
2016-10-09T18:48:07.374548Z 0 [ERROR] InnoDB: Could not find a valid tablespace file for `mysql/slave_worker_info`. Please refer to http://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting-datadict.html for how to resolve the issue.
2016-10-09T18:48:07.375550Z 0 [Warning] InnoDB: Ignoring tablespace `mysql/slave_worker_info` because it could not be opened.
2016-10-09T18:48:07.377082Z 0 [ERROR] InnoDB: Operating system error number 2 in a file operation.
2016-10-09T18:48:07.378087Z 0 [Note] InnoDB: Some operating system error numbers are described at http://dev.mysql.com/doc/refman/5.7/en/operating-system-error-codes.html
2016-10-09T18:48:07.381085Z 0 [ERROR] InnoDB: Cannot open datafile for read-only: '.\mysql\time_zone.ibd' OS error: 71
2016-10-09T18:48:07.382088Z 0 [ERROR] InnoDB: Could not find a valid tablespace file for `mysql/time_zone`. Please refer to http://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting-datadict.html for how to resolve the issue.
2016-10-09T18:48:07.383088Z 0 [Warning] InnoDB: Ignoring tablespace `mysql/time_zone` because it could not be opened.
2016-10-09T18:48:07.384088Z 0 [ERROR] InnoDB: Operating system error number 2 in a file operation.
2016-10-09T18:48:07.385088Z 0 [Note] InnoDB: Some operating system error numbers are described at http://dev.mysql.com/doc/refman/5.7/en/operating-system-error-codes.html
2016-10-09T18:48:07.386088Z 0 [ERROR] InnoDB: Cannot open datafile for read-only: '.\mysql\time_zone_leap_second.ibd' OS error: 71
2016-10-09T18:48:07.387089Z 0 [ERROR] InnoDB: Could not find a valid tablespace file for `mysql/time_zone_leap_second`. Please refer to http://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting-datadict.html for how to resolve the issue.
2016-10-09T18:48:07.388089Z 0 [Warning] InnoDB: Ignoring tablespace `mysql/time_zone_leap_second` because it could not be opened.
2016-10-09T18:48:07.390087Z 0 [ERROR] InnoDB: Operating system error number 2 in a file operation.
2016-10-09T18:48:07.393088Z 0 [Note] InnoDB: Some operating system error numbers are described at http://dev.mysql.com/doc/refman/5.7/en/operating-system-error-codes.html
2016-10-09T18:48:07.394088Z 0 [ERROR] InnoDB: Cannot open datafile for read-only: '.\mysql\time_zone_name.ibd' OS error: 71
2016-10-09T18:48:07.395089Z 0 [ERROR] InnoDB: Could not find a valid tablespace file for `mysql/time_zone_name`. Please refer to http://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting-datadict.html for how to resolve the issue.
2016-10-09T18:48:07.396090Z 0 [Warning] InnoDB: Ignoring tablespace `mysql/time_zone_name` because it could not be opened.
2016-10-09T18:48:07.397088Z 0 [ERROR] InnoDB: Operating system error number 2 in a file operation.
2016-10-09T18:48:07.398091Z 0 [Note] InnoDB: Some operating system error numbers are described at http://dev.mysql.com/doc/refman/5.7/en/operating-system-error-codes.html
2016-10-09T18:48:07.399091Z 0 [ERROR] InnoDB: Cannot open datafile for read-only: '.\mysql\time_zone_transition.ibd' OS error: 71
2016-10-09T18:48:07.400091Z 0 [ERROR] InnoDB: Could not find a valid tablespace file for `mysql/time_zone_transition`. Please refer to http://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting-datadict.html for how to resolve the issue.
2016-10-09T18:48:07.403091Z 0 [Warning] InnoDB: Ignoring tablespace `mysql/time_zone_transition` because it could not be opened.
2016-10-09T18:48:07.404092Z 0 [ERROR] InnoDB: Operating system error number 2 in a file operation.
2016-10-09T18:48:07.405092Z 0 [Note] InnoDB: Some operating system error numbers are described at http://dev.mysql.com/doc/refman/5.7/en/operating-system-error-codes.html
2016-10-09T18:48:07.406093Z 0 [ERROR] InnoDB: Cannot open datafile for read-only: '.\mysql\time_zone_transition_type.ibd' OS error: 71
2016-10-09T18:48:07.408091Z 0 [ERROR] InnoDB: Could not find a valid tablespace file for `mysql/time_zone_transition_type`. Please refer to http://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting-datadict.html for how to resolve the issue.
2016-10-09T18:48:07.409091Z 0 [Warning] InnoDB: Ignoring tablespace `mysql/time_zone_transition_type` because it could not be opened.
2016-10-09T18:48:07.410095Z 0 [ERROR] InnoDB: Operating system error number 2 in a file operation.
2016-10-09T18:48:07.411094Z 0 [Note] InnoDB: Some operating system error numbers are described at http://dev.mysql.com/doc/refman/5.7/en/operating-system-error-codes.html
2016-10-09T18:48:07.414126Z 0 [ERROR] InnoDB: Cannot open datafile for read-only: '.\sys\sys_config.ibd' OS error: 71
2016-10-09T18:48:07.415094Z 0 [ERROR] InnoDB: Could not find a valid tablespace file for `sys/sys_config`. Please refer to http://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting-datadict.html for how to resolve the issue.
2016-10-09T18:48:07.416095Z 0 [Warning] InnoDB: Ignoring tablespace `sys/sys_config` because it could not be opened.
2016-10-09T18:48:07.418093Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2016-10-09T18:48:07.419093Z 0 [Note] InnoDB: Setting file '.\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2016-10-09T18:48:07.490236Z 0 [Note] InnoDB: File '.\ibtmp1' size is now 12 MB.
2016-10-09T18:48:07.493469Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2016-10-09T18:48:07.494467Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2016-10-09T18:48:07.496272Z 0 [Note] InnoDB: Waiting for purge to start
2016-10-09T18:48:07.499277Z 0 [ERROR] InnoDB: Failed to find tablespace for table `mysql`.`innodb_index_stats` in the cache. Attempting to load the tablespace with space id 14
2016-10-09T18:48:07.499277Z 0 [ERROR] InnoDB: Operating system error number 2 in a file operation.
2016-10-09T18:48:07.502277Z 0 [Note] InnoDB: Some operating system error numbers are described at http://dev.mysql.com/doc/refman/5.7/en/operating-system-error-codes.html
2016-10-09T18:48:07.503278Z 0 [ERROR] InnoDB: Cannot open datafile for read-only: '.\mysql\innodb_index_stats.ibd' OS error: 71
2016-10-09T18:48:07.505279Z 0 [ERROR] InnoDB: Could not find a valid tablespace file for `mysql/innodb_index_stats`. Please refer to http://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting-datadict.html for how to resolve the issue.
2016-10-09T18:48:07.506279Z 0 [ERROR] InnoDB: Failed to find tablespace for table `mysql`.`innodb_table_stats` in the cache. Attempting to load the tablespace with space id 13
2016-10-09T18:48:07.507279Z 0 [ERROR] InnoDB: Operating system error number 2 in a file operation.
2016-10-09T18:48:07.509277Z 0 [Note] InnoDB: Some operating system error numbers are described at http://dev.mysql.com/doc/refman/5.7/en/operating-system-error-codes.html
2016-10-09T18:48:07.510277Z 0 [ERROR] InnoDB: Cannot open datafile for read-only: '.\mysql\innodb_table_stats.ibd' OS error: 71
2016-10-09T18:48:07.513281Z 0 [ERROR] InnoDB: Could not find a valid tablespace file for `mysql/innodb_table_stats`. Please refer to http://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting-datadict.html for how to resolve the issue.
2016-10-09T18:48:07.548206Z 0 [Note] InnoDB: 5.7.15 started; log sequence number 2529691
2016-10-09T18:48:07.549209Z 0 [Note] Plugin 'FEDERATED' is disabled.
2016-10-09T18:48:07.550213Z 0 [Note] InnoDB: Loading buffer pool(s) from C:\Program Files\MySQL\MySQL Server 5.7\Data\ib_buffer_pool
2016-10-09T18:48:07.553209Z 0 [Note] InnoDB: Buffer pool(s) load completed at 161009 11:48:07
2016-10-09T18:48:07.556210Z 0 [ERROR] InnoDB: Failed to find tablespace for table `mysql`.`plugin` in the cache. Attempting to load the tablespace with space id 2
2016-10-09T18:48:07.556210Z 0 [ERROR] InnoDB: Operating system error number 2 in a file operation.
2016-10-09T18:48:07.558210Z 0 [Note] InnoDB: Some operating system error numbers are described at http://dev.mysql.com/doc/refman/5.7/en/operating-system-error-codes.html
2016-10-09T18:48:07.561211Z 0 [ERROR] InnoDB: Cannot open datafile for read-only: '.\mysql\plugin.ibd' OS error: 71
2016-10-09T18:48:07.562213Z 0 [ERROR] InnoDB: Could not find a valid tablespace file for `mysql/plugin`. Please refer to http://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting-datadict.html for how to resolve the issue.
2016-10-09T18:48:07.563214Z 0 [Warning] InnoDB: Cannot calculate statistics for table `mysql`.`plugin` because the .ibd file is missing. Please refer to http://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting.html for how to resolve the issue.
mysqld: Tablespace is missing for table `mysql`.`plugin`.
2016-10-09T18:48:07.566211Z 0 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
2016-10-09T18:48:07.567214Z 0 [ERROR] unknown variable 'time-wait=120'
2016-10-09T18:48:07.568216Z 0 [ERROR] Aborting
2016-10-09T18:48:07.571215Z 0 [Note] Binlog end
2016-10-09T18:48:07.572216Z 0 [Note] Shutting down plugin 'ngram'
2016-10-09T18:48:07.573216Z 0 [Note] Shutting down plugin 'partition'
2016-10-09T18:48:07.574505Z 0 [Note] Shutting down plugin 'BLACKHOLE'
2016-10-09T18:48:07.575509Z 0 [Note] Shutting down plugin 'ARCHIVE'
2016-10-09T18:48:07.577611Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2016-10-09T18:48:07.578616Z 0 [Note] Shutting down plugin 'MRG_MYISAM'
2016-10-09T18:48:07.581629Z 0 [Note] Shutting down plugin 'MyISAM'
2016-10-09T18:48:07.582634Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL'
2016-10-09T18:48:07.583634Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2016-10-09T18:48:07.584633Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2016-10-09T18:48:07.585634Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2016-10-09T18:48:07.586634Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2016-10-09T18:48:07.587635Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2016-10-09T18:48:07.588635Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2016-10-09T18:48:07.591633Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2016-10-09T18:48:07.592636Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2016-10-09T18:48:07.594634Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2016-10-09T18:48:07.595634Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2016-10-09T18:48:07.596636Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2016-10-09T18:48:07.597636Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2016-10-09T18:48:07.598637Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2016-10-09T18:48:07.599637Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2016-10-09T18:48:07.602637Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2016-10-09T18:48:07.603638Z 0 [Note] Shutting down plugin 'INNODB_METRICS'
2016-10-09T18:48:07.604638Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO'
2016-10-09T18:48:07.606025Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2016-10-09T18:48:07.607029Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2016-10-09T18:48:07.608029Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2016-10-09T18:48:07.609028Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2016-10-09T18:48:07.610027Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2016-10-09T18:48:07.613030Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2016-10-09T18:48:07.614030Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM'
2016-10-09T18:48:07.615030Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2016-10-09T18:48:07.616031Z 0 [Note] Shutting down plugin 'INNODB_CMP'
2016-10-09T18:48:07.617031Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2016-10-09T18:48:07.618031Z 0 [Note] Shutting down plugin 'INNODB_LOCKS'
2016-10-09T18:48:07.619031Z 0 [Note] Shutting down plugin 'INNODB_TRX'
2016-10-09T18:48:07.621029Z 0 [Note] Shutting down plugin 'InnoDB'
2016-10-09T18:48:07.622032Z 0 [Note] InnoDB: FTS optimize thread exiting.
2016-10-09T18:48:07.625033Z 0 [Note] InnoDB: Starting shutdown...
2016-10-09T18:48:07.726668Z 0 [Note] InnoDB: Dumping buffer pool(s) to C:\Program Files\MySQL\MySQL Server 5.7\Data\ib_buffer_pool
2016-10-09T18:48:07.729201Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 161009 11:48:07
2016-10-09T18:48:08.840324Z 0 [Note] InnoDB: Shutdown completed; log sequence number 2529710
2016-10-09T18:48:08.841328Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2016-10-09T18:48:08.843328Z 0 [Note] Shutting down plugin 'MEMORY'
2016-10-09T18:48:08.845771Z 0 [Note] Shutting down plugin 'CSV'
2016-10-09T18:48:08.846774Z 0 [Note] Shutting down plugin 'sha256_password'
2016-10-09T18:48:08.848004Z 0 [Note] Shutting down plugin 'mysql_native_password'
2016-10-09T18:48:08.849007Z 0 [Note] Shutting down plugin 'binlog'
2016-10-09T18:48:08.850006Z 0 [Note] mysqld.exe: Shutdown complete
C:\Program Files\MySQL\MySQL Server 5.7\bin>
This is after uninstalling and reinstalling MySQL on a Windows 10 PC.
The first error seems to imply a file is missing or was not installed.
Subject
Views
Written By
Posted
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.