操作系统是WINDOWS 8.1 64位版
MYSQL是mysql-5.7.10-winx64
首先系统服务一定是有的,本人也重装过,重启过,都没用,关键是这个”mysql.user”的表是个什么玩意不清楚。 。
net start mysql
MySQL 服务正在启动 .
MySQL 服务无法启动。
服务没有报告任何错误。
请键入 NET HELPMSG 3534 以获得更多的帮助。
然后本人看了一下系统日志一个错误:
Fatal error: Can”t open and lock privilege tables: Table “mysql.user” doesn”t existFor more information, see Help and Support Center at http://www.mysql.com.
大致意思是说找不到权限表,问一下该怎么样处理?
还有一个警告:
Failed to open optimizer cost constant tables
For more information, see Help and Support Center at http://www.mysql.com.
#my.ini 配置如下:
[client]
port=3306
default-character-set=utf8
[mysqld]
# 设置为MYSQL的安装目录
basedir=D:\Program Files\mysql
# 设置为MYSQL的数据目录
datadir=D:\Program Files\mysql\data
port=3306
character_set_server=utf8
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
[WinMySQLAdmin]
D:\Program Files\mysql\bin\mysqld.exe
err文件:
2015-12-16T08:18:15.868050Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use –explicit_defaults_for_timestamp server option (see documentation for more details).
2015-12-16T08:18:15.868050Z 0 [Warning] “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.
2015-12-16T08:18:15.868050Z 0 [Warning] “NO_AUTO_CREATE_USER” sql mode was not set.
2015-12-16T08:18:15.868050Z 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.
2015-12-16T08:18:15.869051Z 0 [Note] D:\Program Files\mysql\bin\mysqld (mysqld 5.7.10) starting as process 9608 …
2015-12-16T08:18:15.881060Z 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2015-12-16T08:18:15.881060Z 0 [Note] InnoDB: Uses event mutexes
2015-12-16T08:18:15.882073Z 0 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier
2015-12-16T08:18:15.882073Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-12-16T08:18:15.883062Z 0 [Note] InnoDB: Number of pools: 1
2015-12-16T08:18:15.883062Z 0 [Note] InnoDB: Not using CPU crc32 instructions
2015-12-16T08:18:15.932094Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2015-12-16T08:18:15.940100Z 0 [Note] InnoDB: Completed initialization of buffer pool
2015-12-16T08:18:15.969121Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2015-12-16T08:18:16.003145Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2015-12-16T08:18:16.003145Z 0 [Note] InnoDB: Setting file “.\ibtmp1” size to 12 MB. Physically writing the file full; Please wait …
2015-12-16T08:18:16.035167Z 0 [Note] InnoDB: File “.\ibtmp1” size is now 12 MB.
2015-12-16T08:18:16.041172Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2015-12-16T08:18:16.042173Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2015-12-16T08:18:16.042173Z 0 [Note] InnoDB: Waiting for purge to start
2015-12-16T08:18:16.093749Z 0 [Note] InnoDB: 5.7.10 started; log sequence number 1209999
2015-12-16T08:18:16.094751Z 0 [Note] InnoDB: not started
2015-12-16T08:18:16.094751Z 0 [Note] InnoDB: Loading buffer pool(s) from D:\Program Files\mysql\data\ib_buffer_pool
2015-12-16T08:18:16.094751Z 0 [Note] Plugin “FEDERATED” is disabled.
mysqld: Table “mysql.plugin” doesn”t exist
2015-12-16T08:18:16.095752Z 0 [ERROR] Can”t open the mysql.plugin table. Please run mysql_upgrade to create it.
2015-12-16T08:18:16.096752Z 0 [Warning] Gtid table is not ready to be used. Table “mysql.gtid_executed” cannot be opened.
2015-12-16T08:18:16.096752Z 0 [Note] InnoDB: Buffer pool(s) load completed at 151216 16:18:16
2015-12-16T08:18:16.097752Z 0 [Warning] Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private key
2015-12-16T08:18:16.097752Z 0 [Note] Server hostname (bind-address): “*”; port: 3306
2015-12-16T08:18:16.098753Z 0 [Note] IPv6 is available.
2015-12-16T08:18:16.098753Z 0 [Note] – “::” resolves to “::”;
2015-12-16T08:18:16.098753Z 0 [Note] Server socket created on IP: “::”.
2015-12-16T08:18:16.101768Z 0 [Warning] Failed to open optimizer cost constant tables
2015-12-16T08:18:16.102768Z 0 [ERROR] Fatal error: Can”t open and lock privilege tables: Table “mysql.user” doesn”t exist
2015-12-16T08:18:16.103769Z 0 [ERROR] Aborting
2015-12-16T08:18:16.103769Z 0 [Note] Binlog end
2015-12-16T08:18:16.103769Z 0 [Note] Shutting down plugin “ngram”
2015-12-16T08:18:16.103769Z 0 [Note] Shutting down plugin “partition”
2015-12-16T08:18:16.104769Z 0 [Note] Shutting down plugin “BLACKHOLE”
2015-12-16T08:18:16.104769Z 0 [Note] Shutting down plugin “ARCHIVE”
2015-12-16T08:18:16.104769Z 0 [Note] Shutting down plugin “PERFORMANCE_SCHEMA”
2015-12-16T08:18:16.104769Z 0 [Note] Shutting down plugin “MRG_MYISAM”
2015-12-16T08:18:16.105770Z 0 [Note] Shutting down plugin “MyISAM”
2015-12-16T08:18:16.105770Z 0 [Note] Shutting down plugin “INNODB_SYS_VIRTUAL”
2015-12-16T08:18:16.105770Z 0 [Note] Shutting down plugin “INNODB_SYS_DATAFILES”
2015-12-16T08:18:16.105770Z 0 [Note] Shutting down plugin “INNODB_SYS_TABLESPACES”
2015-12-16T08:18:16.105770Z 0 [Note] Shutting down plugin “INNODB_SYS_FOREIGN_COLS”
2015-12-16T08:18:16.106771Z 0 [Note] Shutting down plugin “INNODB_SYS_FOREIGN”
2015-12-16T08:18:16.106771Z 0 [Note] Shutting down plugin “INNODB_SYS_FIELDS”
2015-12-16T08:18:16.106771Z 0 [Note] Shutting down plugin “INNODB_SYS_COLUMNS”
2015-12-16T08:18:16.106771Z 0 [Note] Shutting down plugin “INNODB_SYS_INDEXES”
2015-12-16T08:18:16.107772Z 0 [Note] Shutting down plugin “INNODB_SYS_TABLESTATS”
2015-12-16T08:18:16.107772Z 0 [Note] Shutting down plugin “INNODB_SYS_TABLES”
2015-12-16T08:18:16.107772Z 0 [Note] Shutting down plugin “INNODB_FT_INDEX_TABLE”
2015-12-16T08:18:16.107772Z 0 [Note] Shutting down plugin “INNODB_FT_INDEX_CACHE”
2015-12-16T08:18:16.108773Z 0 [Note] Shutting down plugin “INNODB_FT_CONFIG”
2015-12-16T08:18:16.108773Z 0 [Note] Shutting down plugin “INNODB_FT_BEING_DELETED”
2015-12-16T08:18:16.108773Z 0 [Note] Shutting down plugin “INNODB_FT_DELETED”
2015-12-16T08:18:16.108773Z 0 [Note] Shutting down plugin “INNODB_FT_DEFAULT_STOPWORD”
2015-12-16T08:18:16.108773Z 0 [Note] Shutting down plugin “INNODB_METRICS”
2015-12-16T08:18:16.109771Z 0 [Note] Shutting down plugin “INNODB_TEMP_TABLE_INFO”
2015-12-16T08:18:16.109771Z 0 [Note] Shutting down plugin “INNODB_BUFFER_POOL_STATS”
2015-12-16T08:18:16.109771Z 0 [Note] Shutting down plugin “INNODB_BUFFER_PAGE_LRU”
2015-12-16T08:18:16.109771Z 0 [Note] Shutting down plugin “INNODB_BUFFER_PAGE”
2015-12-16T08:18:16.110771Z 0 [Note] Shutting down plugin “INNODB_CMP_PER_INDEX_RESET”
2015-12-16T08:18:16.110771Z 0 [Note] Shutting down plugin “INNODB_CMP_PER_INDEX”
2015-12-16T08:18:16.110771Z 0 [Note] Shutting down plugin “INNODB_CMPMEM_RESET”
2015-12-16T08:18:16.110771Z 0 [Note] Shutting down plugin “INNODB_CMPMEM”
2015-12-16T08:18:16.111772Z 0 [Note] Shutting down plugin “INNODB_CMP_RESET”
2015-12-16T08:18:16.111772Z 0 [Note] Shutting down plugin “INNODB_CMP”
2015-12-16T08:18:16.111772Z 0 [Note] Shutting down plugin “INNODB_LOCK_WAITS”
2015-12-16T08:18:16.111772Z 0 [Note] Shutting down plugin “INNODB_LOCKS”
2015-12-16T08:18:16.111772Z 0 [Note] Shutting down plugin “INNODB_TRX”
2015-12-16T08:18:16.112772Z 0 [Note] Shutting down plugin “InnoDB”
2015-12-16T08:18:16.112772Z 0 [Note] InnoDB: FTS optimize thread exiting.
2015-12-16T08:18:16.112772Z 0 [Note] InnoDB: Starting shutdown…
2015-12-16T08:18:16.214441Z 0 [Note] InnoDB: Dumping buffer pool(s) to D:\Program Files\mysql\data\ib_buffer_pool
2015-12-16T08:18:16.220477Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 151216 16:18:16
2015-12-16T08:18:17.450757Z 0 [Note] InnoDB: Shutdown completed; log sequence number 1210018
2015-12-16T08:18:17.451758Z 0 [Note] InnoDB: Removed temporary tablespace data file: “ibtmp1”
2015-12-16T08:18:17.451758Z 0 [Note] Shutting down plugin “MEMORY”
2015-12-16T08:18:17.451758Z 0 [Note] Shutting down plugin “CSV”
2015-12-16T08:18:17.452758Z 0 [Note] Shutting down plugin “sha256_password”
2015-12-16T08:18:17.452758Z 0 [Note] Shutting down plugin “mysql_native_password”
2015-12-16T08:18:17.452758Z 0 [Note] Shutting down plugin “binlog”
2015-12-16T08:18:17.453759Z 0 [Note] D:\Program Files\mysql\bin\mysqld: Shutdown complete
MYSQL是mysql-5.7.10-winx64
首先系统服务一定是有的,本人也重装过,重启过,都没用,关键是这个”mysql.user”的表是个什么玩意不清楚。 。
net start mysql
MySQL 服务正在启动 .
MySQL 服务无法启动。
服务没有报告任何错误。
请键入 NET HELPMSG 3534 以获得更多的帮助。
然后本人看了一下系统日志一个错误:
Fatal error: Can”t open and lock privilege tables: Table “mysql.user” doesn”t existFor more information, see Help and Support Center at http://www.mysql.com.
大致意思是说找不到权限表,问一下该怎么样处理?
还有一个警告:
Failed to open optimizer cost constant tables
For more information, see Help and Support Center at http://www.mysql.com.
#my.ini 配置如下:
[client]
port=3306
default-character-set=utf8
[mysqld]
# 设置为MYSQL的安装目录
basedir=D:\Program Files\mysql
# 设置为MYSQL的数据目录
datadir=D:\Program Files\mysql\data
port=3306
character_set_server=utf8
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
[WinMySQLAdmin]
D:\Program Files\mysql\bin\mysqld.exe
err文件:
2015-12-16T08:18:15.868050Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use –explicit_defaults_for_timestamp server option (see documentation for more details).
2015-12-16T08:18:15.868050Z 0 [Warning] “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.
2015-12-16T08:18:15.868050Z 0 [Warning] “NO_AUTO_CREATE_USER” sql mode was not set.
2015-12-16T08:18:15.868050Z 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.
2015-12-16T08:18:15.869051Z 0 [Note] D:\Program Files\mysql\bin\mysqld (mysqld 5.7.10) starting as process 9608 …
2015-12-16T08:18:15.881060Z 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2015-12-16T08:18:15.881060Z 0 [Note] InnoDB: Uses event mutexes
2015-12-16T08:18:15.882073Z 0 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier
2015-12-16T08:18:15.882073Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-12-16T08:18:15.883062Z 0 [Note] InnoDB: Number of pools: 1
2015-12-16T08:18:15.883062Z 0 [Note] InnoDB: Not using CPU crc32 instructions
2015-12-16T08:18:15.932094Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2015-12-16T08:18:15.940100Z 0 [Note] InnoDB: Completed initialization of buffer pool
2015-12-16T08:18:15.969121Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2015-12-16T08:18:16.003145Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2015-12-16T08:18:16.003145Z 0 [Note] InnoDB: Setting file “.\ibtmp1” size to 12 MB. Physically writing the file full; Please wait …
2015-12-16T08:18:16.035167Z 0 [Note] InnoDB: File “.\ibtmp1” size is now 12 MB.
2015-12-16T08:18:16.041172Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2015-12-16T08:18:16.042173Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2015-12-16T08:18:16.042173Z 0 [Note] InnoDB: Waiting for purge to start
2015-12-16T08:18:16.093749Z 0 [Note] InnoDB: 5.7.10 started; log sequence number 1209999
2015-12-16T08:18:16.094751Z 0 [Note] InnoDB: not started
2015-12-16T08:18:16.094751Z 0 [Note] InnoDB: Loading buffer pool(s) from D:\Program Files\mysql\data\ib_buffer_pool
2015-12-16T08:18:16.094751Z 0 [Note] Plugin “FEDERATED” is disabled.
mysqld: Table “mysql.plugin” doesn”t exist
2015-12-16T08:18:16.095752Z 0 [ERROR] Can”t open the mysql.plugin table. Please run mysql_upgrade to create it.
2015-12-16T08:18:16.096752Z 0 [Warning] Gtid table is not ready to be used. Table “mysql.gtid_executed” cannot be opened.
2015-12-16T08:18:16.096752Z 0 [Note] InnoDB: Buffer pool(s) load completed at 151216 16:18:16
2015-12-16T08:18:16.097752Z 0 [Warning] Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private key
2015-12-16T08:18:16.097752Z 0 [Note] Server hostname (bind-address): “*”; port: 3306
2015-12-16T08:18:16.098753Z 0 [Note] IPv6 is available.
2015-12-16T08:18:16.098753Z 0 [Note] – “::” resolves to “::”;
2015-12-16T08:18:16.098753Z 0 [Note] Server socket created on IP: “::”.
2015-12-16T08:18:16.101768Z 0 [Warning] Failed to open optimizer cost constant tables
2015-12-16T08:18:16.102768Z 0 [ERROR] Fatal error: Can”t open and lock privilege tables: Table “mysql.user” doesn”t exist
2015-12-16T08:18:16.103769Z 0 [ERROR] Aborting
2015-12-16T08:18:16.103769Z 0 [Note] Binlog end
2015-12-16T08:18:16.103769Z 0 [Note] Shutting down plugin “ngram”
2015-12-16T08:18:16.103769Z 0 [Note] Shutting down plugin “partition”
2015-12-16T08:18:16.104769Z 0 [Note] Shutting down plugin “BLACKHOLE”
2015-12-16T08:18:16.104769Z 0 [Note] Shutting down plugin “ARCHIVE”
2015-12-16T08:18:16.104769Z 0 [Note] Shutting down plugin “PERFORMANCE_SCHEMA”
2015-12-16T08:18:16.104769Z 0 [Note] Shutting down plugin “MRG_MYISAM”
2015-12-16T08:18:16.105770Z 0 [Note] Shutting down plugin “MyISAM”
2015-12-16T08:18:16.105770Z 0 [Note] Shutting down plugin “INNODB_SYS_VIRTUAL”
2015-12-16T08:18:16.105770Z 0 [Note] Shutting down plugin “INNODB_SYS_DATAFILES”
2015-12-16T08:18:16.105770Z 0 [Note] Shutting down plugin “INNODB_SYS_TABLESPACES”
2015-12-16T08:18:16.105770Z 0 [Note] Shutting down plugin “INNODB_SYS_FOREIGN_COLS”
2015-12-16T08:18:16.106771Z 0 [Note] Shutting down plugin “INNODB_SYS_FOREIGN”
2015-12-16T08:18:16.106771Z 0 [Note] Shutting down plugin “INNODB_SYS_FIELDS”
2015-12-16T08:18:16.106771Z 0 [Note] Shutting down plugin “INNODB_SYS_COLUMNS”
2015-12-16T08:18:16.106771Z 0 [Note] Shutting down plugin “INNODB_SYS_INDEXES”
2015-12-16T08:18:16.107772Z 0 [Note] Shutting down plugin “INNODB_SYS_TABLESTATS”
2015-12-16T08:18:16.107772Z 0 [Note] Shutting down plugin “INNODB_SYS_TABLES”
2015-12-16T08:18:16.107772Z 0 [Note] Shutting down plugin “INNODB_FT_INDEX_TABLE”
2015-12-16T08:18:16.107772Z 0 [Note] Shutting down plugin “INNODB_FT_INDEX_CACHE”
2015-12-16T08:18:16.108773Z 0 [Note] Shutting down plugin “INNODB_FT_CONFIG”
2015-12-16T08:18:16.108773Z 0 [Note] Shutting down plugin “INNODB_FT_BEING_DELETED”
2015-12-16T08:18:16.108773Z 0 [Note] Shutting down plugin “INNODB_FT_DELETED”
2015-12-16T08:18:16.108773Z 0 [Note] Shutting down plugin “INNODB_FT_DEFAULT_STOPWORD”
2015-12-16T08:18:16.108773Z 0 [Note] Shutting down plugin “INNODB_METRICS”
2015-12-16T08:18:16.109771Z 0 [Note] Shutting down plugin “INNODB_TEMP_TABLE_INFO”
2015-12-16T08:18:16.109771Z 0 [Note] Shutting down plugin “INNODB_BUFFER_POOL_STATS”
2015-12-16T08:18:16.109771Z 0 [Note] Shutting down plugin “INNODB_BUFFER_PAGE_LRU”
2015-12-16T08:18:16.109771Z 0 [Note] Shutting down plugin “INNODB_BUFFER_PAGE”
2015-12-16T08:18:16.110771Z 0 [Note] Shutting down plugin “INNODB_CMP_PER_INDEX_RESET”
2015-12-16T08:18:16.110771Z 0 [Note] Shutting down plugin “INNODB_CMP_PER_INDEX”
2015-12-16T08:18:16.110771Z 0 [Note] Shutting down plugin “INNODB_CMPMEM_RESET”
2015-12-16T08:18:16.110771Z 0 [Note] Shutting down plugin “INNODB_CMPMEM”
2015-12-16T08:18:16.111772Z 0 [Note] Shutting down plugin “INNODB_CMP_RESET”
2015-12-16T08:18:16.111772Z 0 [Note] Shutting down plugin “INNODB_CMP”
2015-12-16T08:18:16.111772Z 0 [Note] Shutting down plugin “INNODB_LOCK_WAITS”
2015-12-16T08:18:16.111772Z 0 [Note] Shutting down plugin “INNODB_LOCKS”
2015-12-16T08:18:16.111772Z 0 [Note] Shutting down plugin “INNODB_TRX”
2015-12-16T08:18:16.112772Z 0 [Note] Shutting down plugin “InnoDB”
2015-12-16T08:18:16.112772Z 0 [Note] InnoDB: FTS optimize thread exiting.
2015-12-16T08:18:16.112772Z 0 [Note] InnoDB: Starting shutdown…
2015-12-16T08:18:16.214441Z 0 [Note] InnoDB: Dumping buffer pool(s) to D:\Program Files\mysql\data\ib_buffer_pool
2015-12-16T08:18:16.220477Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 151216 16:18:16
2015-12-16T08:18:17.450757Z 0 [Note] InnoDB: Shutdown completed; log sequence number 1210018
2015-12-16T08:18:17.451758Z 0 [Note] InnoDB: Removed temporary tablespace data file: “ibtmp1”
2015-12-16T08:18:17.451758Z 0 [Note] Shutting down plugin “MEMORY”
2015-12-16T08:18:17.451758Z 0 [Note] Shutting down plugin “CSV”
2015-12-16T08:18:17.452758Z 0 [Note] Shutting down plugin “sha256_password”
2015-12-16T08:18:17.452758Z 0 [Note] Shutting down plugin “mysql_native_password”
2015-12-16T08:18:17.452758Z 0 [Note] Shutting down plugin “binlog”
2015-12-16T08:18:17.453759Z 0 [Note] D:\Program Files\mysql\bin\mysqld: Shutdown complete
解决方案
20
虽然是5.7.9的,但应该能帮到你
http://jingyan.baidu.com/article/0f5fb0991636376d8234ea7a.html
http://jingyan.baidu.com/article/0f5fb0991636376d8234ea7a.html