社区
MySQL
帖子详情
mySQL无法启动服务,新手跪求大神指点
qq_25532557
2016-11-17 11:28:11
...全文
1246
4
打赏
收藏
mySQL无法启动服务,新手跪求大神指点
[图片]
复制链接
扫一扫
分享
转发到动态
举报
AI
作业
写回复
配置赞助广告
用AI写文章
4 条
回复
切换为时间正序
请发表友善的回复…
发表回复
打赏红包
致命的西瓜
2016-11-17
打赏
举报
回复
5.7总会出现这个问题 在cmd安装好MySQL之后,输入mysqld --initialize 进行初始化 然后就会发现目录下多了一个data文件夹,再启动应该就没问题了
qq_25532557
2016-11-17
打赏
举报
回复
那位大神来带带我
qq_25532557
2016-11-17
打赏
举报
回复
2016-11-17T03:20:39.705587Z 0 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it. 2016-11-17T03:20:39.706588Z 0 [Note] InnoDB: Buffer pool(s) load completed at 161117 11:20:39 2016-11-17T03:20:39.706588Z 0 [Note] Salting uuid generator variables, current_pid: 2760, server_start_time: 1479352839, bytes_sent: 0, 2016-11-17T03:20:39.713582Z 0 [Note] Generated uuid: 'd0974f95-ac74-11e6-81af-ac9e17286e46', server_start_time: 1479355599, bytes_sent: 2703222697968 2016-11-17T03:20:39.713582Z 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: d0974f95-ac74-11e6-81af-ac9e17286e46. 2016-11-17T03:20:39.763668Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened. 2016-11-17T03:20:39.764636Z 0 [Warning] Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private key 2016-11-17T03:20:39.766635Z 0 [Note] Server hostname (bind-address): '*'; port: 3306 2016-11-17T03:20:39.767630Z 0 [Note] IPv6 is available. 2016-11-17T03:20:39.767630Z 0 [Note] - '::' resolves to '::'; 2016-11-17T03:20:39.767630Z 0 [Note] Server socket created on IP: '::'. 2016-11-17T03:20:39.769622Z 0 [Warning] Failed to open optimizer cost constant tables 2016-11-17T03:20:39.770622Z 0 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist 2016-11-17T03:20:39.770622Z 0 [ERROR] Aborting 2016-11-17T03:20:39.771623Z 0 [Note] Binlog end 2016-11-17T03:20:39.771623Z 0 [Note] Shutting down plugin 'ngram' 2016-11-17T03:20:39.771623Z 0 [Note] Shutting down plugin 'partition' 2016-11-17T03:20:39.771623Z 0 [Note] Shutting down plugin 'BLACKHOLE' 2016-11-17T03:20:39.771623Z 0 [Note] Shutting down plugin 'ARCHIVE' 2016-11-17T03:20:39.772637Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA' 2016-11-17T03:20:39.772637Z 0 [Note] Shutting down plugin 'MRG_MYISAM' 2016-11-17T03:20:39.772637Z 0 [Note] Shutting down plugin 'MyISAM' 2016-11-17T03:20:39.772637Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL' 2016-11-17T03:20:39.772637Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES' 2016-11-17T03:20:39.773637Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES' 2016-11-17T03:20:39.773637Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS' 2016-11-17T03:20:39.773637Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN' 2016-11-17T03:20:39.773637Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS' 2016-11-17T03:20:39.774638Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS' 2016-11-17T03:20:39.774638Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES' 2016-11-17T03:20:39.774638Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS' 2016-11-17T03:20:39.775627Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES' 2016-11-17T03:20:39.775627Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE' 2016-11-17T03:20:39.776145Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE' 2016-11-17T03:20:39.776145Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG' 2016-11-17T03:20:39.776633Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED' 2016-11-17T03:20:39.776633Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED' 2016-11-17T03:20:39.777145Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD' 2016-11-17T03:20:39.777145Z 0 [Note] Shutting down plugin 'INNODB_METRICS' 2016-11-17T03:20:39.777650Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO' 2016-11-17T03:20:39.777650Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS' 2016-11-17T03:20:39.778145Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU' 2016-11-17T03:20:39.778145Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE' 2016-11-17T03:20:39.778646Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET' 2016-11-17T03:20:39.778646Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX' 2016-11-17T03:20:39.779146Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET' 2016-11-17T03:20:39.779146Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM' 2016-11-17T03:20:39.779647Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET' 2016-11-17T03:20:39.779647Z 0 [Note] Shutting down plugin 'INNODB_CMP' 2016-11-17T03:20:39.779647Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS' 2016-11-17T03:20:39.780147Z 0 [Note] Shutting down plugin 'INNODB_LOCKS' 2016-11-17T03:20:39.780147Z 0 [Note] Shutting down plugin 'INNODB_TRX' 2016-11-17T03:20:39.780647Z 0 [Note] Shutting down plugin 'InnoDB' 2016-11-17T03:20:39.780647Z 0 [Note] InnoDB: FTS optimize thread exiting. 2016-11-17T03:20:39.781147Z 0 [Note] InnoDB: Starting shutdown... 2016-11-17T03:20:39.881846Z 0 [Note] InnoDB: Dumping buffer pool(s) to D:\mysql\mysql-5.7.16-winx64\data\ib_buffer_pool 2016-11-17T03:20:39.884348Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 161117 11:20:39 2016-11-17T03:20:41.277176Z 0 [Note] InnoDB: Shutdown completed; log sequence number 1209980 2016-11-17T03:20:41.278189Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2016-11-17T03:20:41.278189Z 0 [Note] Shutting down plugin 'MEMORY' 2016-11-17T03:20:41.278691Z 0 [Note] Shutting down plugin 'CSV' 2016-11-17T03:20:41.278691Z 0 [Note] Shutting down plugin 'sha256_password' 2016-11-17T03:20:41.279190Z 0 [Note] Shutting down plugin 'mysql_native_password' 2016-11-17T03:20:41.279190Z 0 [Note] Shutting down plugin 'binlog' 2016-11-17T03:20:41.279691Z 0 [Note] MySQL: Shutdown complete
qq_25532557
2016-11-17
打赏
举报
回复
2016-11-17T03:20:27.318019Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2016-11-17T03:20:27.318019Z 0 [Note] --secure-file-priv is set to NULL. Operations related to importing and exporting data are disabled 2016-11-17T03:20:27.318019Z 0 [Note] mysqld (mysqld 5.7.16) starting as process 13640 ... 2016-11-17T03:20:27.328028Z 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions 2016-11-17T03:20:27.329028Z 0 [Note] InnoDB: Uses event mutexes 2016-11-17T03:20:27.329028Z 0 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier 2016-11-17T03:20:27.330028Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.3 2016-11-17T03:20:27.331029Z 0 [Note] InnoDB: Number of pools: 1 2016-11-17T03:20:27.332030Z 0 [Note] InnoDB: Not using CPU crc32 instructions 2016-11-17T03:20:27.335031Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M 2016-11-17T03:20:27.342036Z 0 [Note] InnoDB: Completed initialization of buffer pool 2016-11-17T03:20:27.356047Z 0 [Note] InnoDB: The first innodb_system data file 'ibdata1' did not exist. A new tablespace will be created! 2016-11-17T03:20:27.357047Z 0 [Note] InnoDB: Setting file '.\ibdata1' size to 12 MB. Physically writing the file full; Please wait ... 2016-11-17T03:20:27.561389Z 0 [Note] InnoDB: File '.\ibdata1' size is now 12 MB. 2016-11-17T03:20:27.574393Z 0 [Note] InnoDB: Setting log file .\ib_logfile101 size to 48 MB 2016-11-17T03:20:28.437462Z 0 [Note] InnoDB: Setting log file .\ib_logfile1 size to 48 MB 2016-11-17T03:20:29.313572Z 0 [Note] InnoDB: Renaming log file .\ib_logfile101 to .\ib_logfile0 2016-11-17T03:20:29.315558Z 0 [Warning] InnoDB: New log files created, LSN=45790 2016-11-17T03:20:29.315558Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2016-11-17T03:20:29.316567Z 0 [Note] InnoDB: Setting file '.\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2016-11-17T03:20:29.546945Z 0 [Note] InnoDB: File '.\ibtmp1' size is now 12 MB. 2016-11-17T03:20:29.547950Z 0 [Note] InnoDB: Doublewrite buffer not found: creating new 2016-11-17T03:20:29.812690Z 0 [Note] InnoDB: Doublewrite buffer created 2016-11-17T03:20:29.846699Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. 2016-11-17T03:20:29.847699Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. 2016-11-17T03:20:29.848700Z 0 [Warning] InnoDB: Creating foreign key constraint system tables. 2016-11-17T03:20:29.912058Z 0 [Note] InnoDB: Foreign key constraint system tables created 2016-11-17T03:20:29.912058Z 0 [Note] InnoDB: Creating tablespace and datafile system tables. 2016-11-17T03:20:29.967137Z 0 [Note] InnoDB: Tablespace and datafile system tables created. 2016-11-17T03:20:29.967638Z 0 [Note] InnoDB: Creating sys_virtual system tables. 2016-11-17T03:20:29.989826Z 0 [Note] InnoDB: sys_virtual table created 2016-11-17T03:20:29.989826Z 0 [Note] InnoDB: Waiting for purge to start 2016-11-17T03:20:30.041816Z 0 [Note] InnoDB: 5.7.16 started; log sequence number 0 2016-11-17T03:20:30.041816Z 0 [Note] Plugin 'FEDERATED' is disabled. mysqld: Table 'mysql.plugin' doesn't exist 2016-11-17T03:20:30.042814Z 0 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it. 2016-11-17T03:20:30.042814Z 0 [ERROR] Too many arguments (first extra is 'initialize'). 2016-11-17T03:20:30.043814Z 0 [Note] Use --verbose --help to get a list of available options! 2016-11-17T03:20:30.043814Z 0 [ERROR] Aborting 2016-11-17T03:20:30.043814Z 0 [Note] Binlog end 2016-11-17T03:20:30.044815Z 0 [Note] Shutting down plugin 'ngram' 2016-11-17T03:20:30.044815Z 0 [Note] Shutting down plugin 'partition' 2016-11-17T03:20:30.044815Z 0 [Note] Shutting down plugin 'BLACKHOLE' 2016-11-17T03:20:30.044815Z 0 [Note] Shutting down plugin 'ARCHIVE' 2016-11-17T03:20:30.045816Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA' 2016-11-17T03:20:30.045816Z 0 [Note] Shutting down plugin 'MRG_MYISAM' 2016-11-17T03:20:30.045816Z 0 [Note] Shutting down plugin 'MyISAM' 2016-11-17T03:20:30.046829Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL' 2016-11-17T03:20:30.046829Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES' 2016-11-17T03:20:30.046829Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES' 2016-11-17T03:20:30.047830Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS' 2016-11-17T03:20:30.047830Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN' 2016-11-17T03:20:30.047830Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS' 2016-11-17T03:20:30.047830Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS' 2016-11-17T03:20:30.048831Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES' 2016-11-17T03:20:30.048831Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS' 2016-11-17T03:20:30.048831Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES' 2016-11-17T03:20:30.049832Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE' 2016-11-17T03:20:30.049832Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE' 2016-11-17T03:20:30.049832Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG' 2016-11-17T03:20:30.050833Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED' 2016-11-17T03:20:30.050833Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED' 2016-11-17T03:20:30.050833Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD' 2016-11-17T03:20:30.050833Z 0 [Note] Shutting down plugin 'INNODB_METRICS' 2016-11-17T03:20:30.051833Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO' 2016-11-17T03:20:30.051833Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS' 2016-11-17T03:20:30.051833Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU' 2016-11-17T03:20:30.052834Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE' 2016-11-17T03:20:30.052834Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET' 2016-11-17T03:20:30.052834Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX' 2016-11-17T03:20:30.053835Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET' 2016-11-17T03:20:30.053835Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM' 2016-11-17T03:20:30.053835Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET' 2016-11-17T03:20:30.053835Z 0 [Note] Shutting down plugin 'INNODB_CMP' 2016-11-17T03:20:30.054835Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS' 2016-11-17T03:20:30.054835Z 0 [Note] Shutting down plugin 'INNODB_LOCKS' 2016-11-17T03:20:30.054835Z 0 [Note] Shutting down plugin 'INNODB_TRX' 2016-11-17T03:20:30.055836Z 0 [Note] Shutting down plugin 'InnoDB' 2016-11-17T03:20:30.055836Z 0 [Note] InnoDB: FTS optimize thread exiting. 2016-11-17T03:20:30.055836Z 0 [Note] InnoDB: Starting shutdown... 2016-11-17T03:20:30.157058Z 0 [Note] InnoDB: Dumping buffer pool(s) to D:\mysql\mysql-5.7.16-winx64\data\ib_buffer_pool 2016-11-17T03:20:30.158008Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 161117 11:20:30 2016-11-17T03:20:31.746457Z 0 [Note] InnoDB: Shutdown completed; log sequence number 1209961 2016-11-17T03:20:31.747453Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2016-11-17T03:20:31.747453Z 0 [Note] Shutting down plugin 'MEMORY' 2016-11-17T03:20:31.747453Z 0 [Note] Shutting down plugin 'CSV' 2016-11-17T03:20:31.748444Z 0 [Note] Shutting down plugin 'sha256_password' 2016-11-17T03:20:31.748444Z 0 [Note] Shutting down plugin 'mysql_native_password' 2016-11-17T03:20:31.748444Z 0 [Note] Shutting down plugin 'binlog' 2016-11-17T03:20:31.749454Z 0 [Note] mysqld: Shutdown complete 2016-11-17T03:20:39.086979Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2016-11-17T03:20:39.086979Z 0 [Note] --secure-file-priv is set to NULL. Operations related to importing and exporting data are disabled 2016-11-17T03:20:39.087479Z 0 [Note] MySQL (mysqld 5.7.16) starting as process 2760 ... 2016-11-17T03:20:39.094010Z 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions 2016-11-17T03:20:39.095011Z 0 [Note] InnoDB: Uses event mutexes 2016-11-17T03:20:39.095011Z 0 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier 2016-11-17T03:20:39.095011Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.3 2016-11-17T03:20:39.096011Z 0 [Note] InnoDB: Number of pools: 1 2016-11-17T03:20:39.096011Z 0 [Note] InnoDB: Not using CPU crc32 instructions 2016-11-17T03:20:39.099003Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M 2016-11-17T03:20:39.107009Z 0 [Note] InnoDB: Completed initialization of buffer pool 2016-11-17T03:20:39.319096Z 0 [Note] InnoDB: Highest supported file format is Barracuda. 2016-11-17T03:20:39.419173Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2016-11-17T03:20:39.419173Z 0 [Note] InnoDB: Setting file '.\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2016-11-17T03:20:39.637305Z 0 [Note] InnoDB: File '.\ibtmp1' size is now 12 MB. 2016-11-17T03:20:39.639301Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. 2016-11-17T03:20:39.639301Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. 2016-11-17T03:20:39.640302Z 0 [Note] InnoDB: Waiting for purge to start 2016-11-17T03:20:39.703590Z 0 [Note] InnoDB: 5.7.16 started; log sequence number 1209961 2016-11-17T03:20:39.704586Z 0 [Note] InnoDB: Loading buffer pool(s) from D:\mysql\mysql-5.7.16-winx64\data\ib_buffer_pool 2016-11-17T03:20:39.704586Z 0 [Note] Plugin 'FEDERATED' is disabled. MySQL: Table 'mysql.plugin' doesn't exist
[求助]一张表查询各班级总分前三名
最近在找练习题做,遇到一难题,束手无策了已经,现
跪求
各路
大神
指点
一二.以下是表格结构及记录.create table st(id int(4) primary key not null, name varchar(20) not null, class varchar(10), age in...
智能咖啡厅助手:人形机器人 +融合大模型,行为驱动的智能咖啡
1、自我介绍2、项目相关,难点,开发周期,学到了什么3、
MySQL
死锁场景,锁行、锁表场景4、IoC的Bean对象是否会被回收5、读写锁可以用JDK的什么集合代。蓝禾,三七互娱,顺丰,康冠科技,金证科技24春招内推①蓝禾...
webmagic采集CSDN的Java_WebDevelop页面
,
新手
跪求
大神
帮忙啊!!, 能不能读取struts2标签获得的值,然后写入数据库?, Selenium 测试用例异常,求
大神
指点
, hibernate
无法
进行查询更新操作是为什么, axis2客户端程序接收不到cxf
服务
端发来的报文, mvc+...
5.20爬虫结——Mu
”,1105611 3852329,发布双版本应用问题,1105611 3852407,图片不能展示出来哪位
大神
指点
下,2138637 3850380,承接 discuz 模板制作,插件开发,2759280 3852425,关于网站通道维护提取失败的解决方法有哪些,3127909 ...
discuz_result
",1105611 3852329,发布双版本应用问题,1105611 3852407,图片不能展示出来哪位
大神
指点
下,2138637 3850380,承接 discuz 模板制作,插件开发,2759280 3852425,关于网站通道维护提取失败的解决方法有哪些,3127909 ...
MySQL
56,912
社区成员
56,754
社区内容
发帖
与我相关
我的任务
MySQL
MySQL相关内容讨论专区
复制链接
扫一扫
分享
社区描述
MySQL相关内容讨论专区
社区管理员
加入社区
获取链接或二维码
近7日
近30日
至今
加载中
查看更多榜单
社区公告
暂无公告
试试用AI创作助手写篇文章吧
+ 用AI写文章