mySQL无法启动服务，新手跪求大神指点

qq_25532557 2016-11-17 11:28:11
...全文
1212 4 打赏 收藏 转发到动态 举报
写回复
用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
MySQL 管理利器 mysql-utilities
Re：MySQL 管理利器 mysql-utilities ===================================== # mysql-utilitiesa 概念 MySQL 作为一款非常流行的开源数据库，支持它的工具越来越多，对于使用者来讲，选择一款好的管理工具，对于...
[求助]一张表查询各班级总分前三名
新手一枚,使用mysql 5.7.21.最近在找练习题做,遇到一难题,束手无策了已经,现跪求各路大神指点一二.以下是表格结构及记录.create table st(id int(4) primary key not null,                        name varchar(20) not null,         class varchar(10), age in...
智能咖啡厅助手：人形机器人 +融合大模型，行为驱动的智能咖啡
哈喽大家好，我是Chowley，QALog创始人，测试开发工程师，我又来开坑了～本篇是《「QALog」校招测试八股—数据库》系列的第一篇，春招高峰期，给大家带来。不得不说 OD在简历。1、自我介绍2、项目相关，难点，开发周期，学到了什么3、MySQL死锁场景，锁行、锁表场景4、IoC的Bean对象是否会被回收5、读写锁可以用JDK的什么集合代。蓝禾，三七互娱，顺丰，康冠科技，金证科技24春招内推①蓝禾【岗位】运营类、设计类、研发类，供应链类，职能等【一键内推】https://lanhevip.jobs。
webmagic采集CSDN的Java_WebDevelop页面
使用webmagic采集博客类的网站示例
5.20爬虫结——Mu
3852724,最新版墨镜风格模板发布了，有需要的朋友可以进来看看,2759280 3856589,官方手机模板在哪安装,3140684 3856347,手机触摸屏被劫持跳转其它网站,3112842 3856562,终于知道DZ官网为什么没落了,3112900 3856535,主题自带的二级导航怎么修改啊,2578089 3856505,以前有农场这些插件能安装，现在没了吗？,1515035 3856513,请问这个网站用的是什么应用程序,3140310 3856515,萌新想问一下，能否可以实现现在主流素
MySQL

56,678

社区成员

56,708

社区内容

发帖
与我相关
我的任务
社区描述
MySQL相关内容讨论专区
社区管理员
  • MySQL
加入社区
  • 近7日
  • 近30日
  • 至今

加载中

查看更多榜单
社区公告
暂无公告

试试用AI创作助手写篇文章吧

+ 用AI写文章