新手使用mysql，遇到问题了，求救！！！

烟影随梦 2016-08-21 06:13:57
刚用mysql没有几天，每次开启mysql服务都告诉我正在启动，请等一会。我百度，用了网上的方法，在任务管理器里面把mysql关了再打开就没问题了。我以为就会出现一次，可是今天使用又出现这个问题了。好烦啊。可是不知道怎么解决。难道每次使用都要这样先结束服务，再开启服务嘛？http://pan.baidu.com/s/1jI56GgI 我把我的错误日志传到百度盘了，希望各位大神帮我瞅瞅，解决问题，多谢啦！
...全文
2679 18 打赏 收藏 转发到动态 举报
写回复
用AI写文章
18 条回复
切换为时间正序
请发表友善的回复…
发表回复
tryscan 2017-07-04
  • 打赏
  • 举报
 回复
看这里（大概5.6.6版本后的变化）： 2016-08-21T09:40:50.857477Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2016-08-21T09:40:50.857477Z 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. 2016-08-21T09:40:50.857477Z 0 [Warning] 'NO_AUTO_CREATE_USER' sql mode was not set. 解决办法：在my.cnf 中设置 disable-partition-engine-check=1 sql_mode=STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
烟影随梦 2016-08-24
  • 打赏
  • 举报
 回复
引用 13 楼 zjcxc 的回复:
蓝屏表明系统有问题吧，换台电脑 试试
现在已经没有出现蓝屏了
烟影随梦 2016-08-24
  • 打赏
  • 举报
 回复
引用 14 楼 yupeigu 的回复:
[quote=引用 12 楼 H_JinXian 的回复:] [quote=引用 11 楼 yupeigu 的回复:] [quote=引用 10 楼 H_JinXian 的回复:] [quote=引用 9 楼 yupeigu 的回复:] [quote=引用 8 楼 H_JinXian 的回复:] [quote=引用 7 楼 zjcxc 的回复:] 从日志看，没什么问题嘛，那几个 Warning 都不影响正常启动
不清楚啊，是不是我的服务注册有问题？我现在已经把它删除了，准备重新解压配置，心疼，能教我配置吗，或者给个你认为不错的配置链接？[/quote] 参考这个： MySQL 5.6 for Windows 解压缩版配置安装 http://jingyan.baidu.com/article/f3ad7d0ffc061a09c3345bf0.html[/quote] 谢啦，虽然我已经装好了，只是我重启试试会不会有问题的时候出现了蓝屏，自动重启没啥问题，mysql服务开机启动成功，就不知道有没有后遗症，查看dump文件竟然没有。心里还是有点方。[/quote] 我之前都是用安装版，没有出现过什么问题，另外，用linux版，也没什么问题。[/quote] 额 我看大家大部分都是推荐使用免安装版的，所以我也就用了，只是对于这个的一些配置真心不太了解。[/quote] 再多试几次，正常情况下是不会有问题的，还有上面也提到了，如果是蓝屏，一般都是系统问题，换个电脑试试[/quote] 谢啦，也就是第一次重启蓝了一次屏幕，现在顺滑湿润，爽到爆！！！
LongRui888 2016-08-24
  • 打赏
  • 举报
 回复
引用 15 楼 H_JinXian 的回复:
[quote=引用 14 楼 yupeigu 的回复:] [quote=引用 12 楼 H_JinXian 的回复:] [quote=引用 11 楼 yupeigu 的回复:] [quote=引用 10 楼 H_JinXian 的回复:] [quote=引用 9 楼 yupeigu 的回复:] [quote=引用 8 楼 H_JinXian 的回复:] [quote=引用 7 楼 zjcxc 的回复:] 从日志看，没什么问题嘛，那几个 Warning 都不影响正常启动
不清楚啊，是不是我的服务注册有问题？我现在已经把它删除了，准备重新解压配置，心疼，能教我配置吗，或者给个你认为不错的配置链接？[/quote] 参考这个： MySQL 5.6 for Windows 解压缩版配置安装 http://jingyan.baidu.com/article/f3ad7d0ffc061a09c3345bf0.html[/quote] 谢啦，虽然我已经装好了，只是我重启试试会不会有问题的时候出现了蓝屏，自动重启没啥问题，mysql服务开机启动成功，就不知道有没有后遗症，查看dump文件竟然没有。心里还是有点方。[/quote] 我之前都是用安装版，没有出现过什么问题，另外，用linux版，也没什么问题。[/quote] 额 我看大家大部分都是推荐使用免安装版的，所以我也就用了，只是对于这个的一些配置真心不太了解。[/quote] 再多试几次，正常情况下是不会有问题的，还有上面也提到了，如果是蓝屏，一般都是系统问题，换个电脑试试[/quote] 谢啦，也就是第一次重启蓝了一次屏幕，现在顺滑湿润，爽到爆！！！[/quote] 这个 润滑湿润 。。。
LongRui888 2016-08-22
  • 打赏
  • 举报
 回复
引用 10 楼 H_JinXian 的回复:
[quote=引用 9 楼 yupeigu 的回复:] [quote=引用 8 楼 H_JinXian 的回复:] [quote=引用 7 楼 zjcxc 的回复:] 从日志看，没什么问题嘛，那几个 Warning 都不影响正常启动
不清楚啊，是不是我的服务注册有问题？我现在已经把它删除了，准备重新解压配置，心疼，能教我配置吗，或者给个你认为不错的配置链接？[/quote] 参考这个： MySQL 5.6 for Windows 解压缩版配置安装 http://jingyan.baidu.com/article/f3ad7d0ffc061a09c3345bf0.html[/quote] 谢啦，虽然我已经装好了，只是我重启试试会不会有问题的时候出现了蓝屏，自动重启没啥问题，mysql服务开机启动成功，就不知道有没有后遗症，查看dump文件竟然没有。心里还是有点方。[/quote] 我之前都是用安装版，没有出现过什么问题，另外，用linux版，也没什么问题。
烟影随梦 2016-08-22
  • 打赏
  • 举报
 回复
引用 9 楼 yupeigu 的回复:
[quote=引用 8 楼 H_JinXian 的回复:]
[quote=引用 7 楼 zjcxc 的回复:]
从日志看，没什么问题嘛，那几个 Warning 都不影响正常启动

不清楚啊，是不是我的服务注册有问题？我现在已经把它删除了，准备重新解压配置，心疼，能教我配置吗，或者给个你认为不错的配置链接？[/quote]

参考这个：

MySQL 5.6 for Windows 解压缩版配置安装
http://jingyan.baidu.com/article/f3ad7d0ffc061a09c3345bf0.html[/quote]
谢啦，虽然我已经装好了，只是我重启试试会不会有问题的时候出现了蓝屏，自动重启没啥问题，mysql服务开机启动成功，就不知道有没有后遗症，查看dump文件竟然没有。心里还是有点方。
LongRui888 2016-08-22
  • 打赏
  • 举报
 回复
引用 8 楼 H_JinXian 的回复:
[quote=引用 7 楼 zjcxc 的回复:] 从日志看，没什么问题嘛，那几个 Warning 都不影响正常启动
不清楚啊，是不是我的服务注册有问题？我现在已经把它删除了，准备重新解压配置，心疼，能教我配置吗，或者给个你认为不错的配置链接？[/quote] 参考这个： MySQL 5.6 for Windows 解压缩版配置安装 http://jingyan.baidu.com/article/f3ad7d0ffc061a09c3345bf0.html
烟影随梦 2016-08-22
  • 打赏
  • 举报
 回复
引用 7 楼 zjcxc 的回复:
从日志看，没什么问题嘛，那几个 Warning 都不影响正常启动
不清楚啊，是不是我的服务注册有问题？我现在已经把它删除了，准备重新解压配置，心疼，能教我配置吗，或者给个你认为不错的配置链接？
zjcxc 2016-08-22
  • 打赏
  • 举报
 回复
从日志看，没什么问题嘛，那几个 Warning 都不影响正常启动
烟影随梦 2016-08-22
  • 打赏
  • 举报
 回复
引用 4 楼 yupeigu 的回复:
你是在windows上安装的mysql把。

你看看在 服务里 mysql服务的设置，是否是自动开启，状态是否正常。

我不是安装的mysql，是解压版的，不过我看服务是自启动的，昨天改成了手动，可是今天手动启动一样卡住，一样只能从任务管理器关闭，然后启动服务。我这个问题是不是只能把解压的包删除，重新安装？
烟影随梦 2016-08-22
  • 打赏
  • 举报
 回复
我不是安装的mysql，是解压版的，不过我看服务是自启动的，昨天改成了手动，可是今天手动启动一样卡住，一样只能从任务管理器关闭，然后启动服务。我这个问题是不是只能把解压的包删除，重新安装？
LongRui888 2016-08-22
  • 打赏
  • 举报
 回复
引用 12 楼 H_JinXian 的回复:
[quote=引用 11 楼 yupeigu 的回复:] [quote=引用 10 楼 H_JinXian 的回复:] [quote=引用 9 楼 yupeigu 的回复:] [quote=引用 8 楼 H_JinXian 的回复:] [quote=引用 7 楼 zjcxc 的回复:] 从日志看，没什么问题嘛，那几个 Warning 都不影响正常启动
不清楚啊，是不是我的服务注册有问题？我现在已经把它删除了，准备重新解压配置，心疼，能教我配置吗，或者给个你认为不错的配置链接？[/quote] 参考这个： MySQL 5.6 for Windows 解压缩版配置安装 http://jingyan.baidu.com/article/f3ad7d0ffc061a09c3345bf0.html[/quote] 谢啦，虽然我已经装好了，只是我重启试试会不会有问题的时候出现了蓝屏，自动重启没啥问题，mysql服务开机启动成功，就不知道有没有后遗症，查看dump文件竟然没有。心里还是有点方。[/quote] 我之前都是用安装版，没有出现过什么问题，另外，用linux版，也没什么问题。[/quote] 额 我看大家大部分都是推荐使用免安装版的，所以我也就用了，只是对于这个的一些配置真心不太了解。[/quote] 再多试几次，正常情况下是不会有问题的，还有上面也提到了，如果是蓝屏，一般都是系统问题，换个电脑试试
zjcxc 2016-08-22
  • 打赏
  • 举报
 回复
蓝屏表明系统有问题吧，换台电脑 试试
烟影随梦 2016-08-22
  • 打赏
  • 举报
 回复
引用 11 楼 yupeigu 的回复:
[quote=引用 10 楼 H_JinXian 的回复:] [quote=引用 9 楼 yupeigu 的回复:] [quote=引用 8 楼 H_JinXian 的回复:] [quote=引用 7 楼 zjcxc 的回复:] 从日志看，没什么问题嘛，那几个 Warning 都不影响正常启动
不清楚啊，是不是我的服务注册有问题？我现在已经把它删除了，准备重新解压配置，心疼，能教我配置吗，或者给个你认为不错的配置链接？[/quote] 参考这个： MySQL 5.6 for Windows 解压缩版配置安装 http://jingyan.baidu.com/article/f3ad7d0ffc061a09c3345bf0.html[/quote] 谢啦，虽然我已经装好了，只是我重启试试会不会有问题的时候出现了蓝屏，自动重启没啥问题，mysql服务开机启动成功，就不知道有没有后遗症，查看dump文件竟然没有。心里还是有点方。[/quote] 我之前都是用安装版，没有出现过什么问题，另外，用linux版，也没什么问题。[/quote] 额 我看大家大部分都是推荐使用免安装版的，所以我也就用了，只是对于这个的一些配置真心不太了解。
LongRui888 2016-08-21
  • 打赏
  • 举报
 回复
你是在windows上安装的mysql把。 你看看在 服务里 mysql服务的设置，是否是自动开启，状态是否正常。
烟影随梦 2016-08-21
  • 打赏
  • 举报
 回复
错误日志的下半部分： 2016-08-21T09:38:15.678173Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET' 2016-08-21T09:38:15.679174Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX' 2016-08-21T09:38:15.679174Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET' 2016-08-21T09:38:15.679174Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM' 2016-08-21T09:38:15.679174Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET' 2016-08-21T09:38:15.679174Z 0 [Note] Shutting down plugin 'INNODB_CMP' 2016-08-21T09:38:15.680174Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS' 2016-08-21T09:38:15.680174Z 0 [Note] Shutting down plugin 'INNODB_LOCKS' 2016-08-21T09:38:15.680174Z 0 [Note] Shutting down plugin 'INNODB_TRX' 2016-08-21T09:38:15.680174Z 0 [Note] Shutting down plugin 'InnoDB' 2016-08-21T09:38:15.681173Z 0 [Note] InnoDB: FTS optimize thread exiting. 2016-08-21T09:38:15.681173Z 0 [Note] InnoDB: Starting shutdown... 2016-08-21T09:38:15.782412Z 0 [Note] InnoDB: Dumping buffer pool(s) to E:\mysql-5.7.14-winx64\data\ib_buffer_pool 2016-08-21T09:38:15.785379Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 160821 17:38:15 2016-08-21T09:38:16.920998Z 0 [Note] InnoDB: Shutdown completed; log sequence number 2533806 2016-08-21T09:38:16.922000Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2016-08-21T09:38:16.922000Z 0 [Note] Shutting down plugin 'MEMORY' 2016-08-21T09:38:16.922000Z 0 [Note] Shutting down plugin 'CSV' 2016-08-21T09:38:16.923001Z 0 [Note] Shutting down plugin 'sha256_password' 2016-08-21T09:38:16.923001Z 0 [Note] Shutting down plugin 'mysql_native_password' 2016-08-21T09:38:16.923001Z 0 [Note] Shutting down plugin 'binlog' 2016-08-21T09:38:16.924001Z 0 [Note] MySQL: Shutdown complete 2016-08-21T09:40:50.857477Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2016-08-21T09:40:50.857477Z 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. 2016-08-21T09:40:50.857477Z 0 [Warning] 'NO_AUTO_CREATE_USER' sql mode was not set. 2016-08-21T09:40:50.857477Z 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-08-21T09:40:50.857477Z 0 [Note] MySQL (mysqld 5.7.14) starting as process 188200 ... 2016-08-21T09:40:50.857477Z 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions 2016-08-21T09:40:50.857477Z 0 [Note] InnoDB: Uses event mutexes 2016-08-21T09:40:50.857477Z 0 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier 2016-08-21T09:40:50.857477Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.3 2016-08-21T09:40:50.873105Z 0 [Note] InnoDB: Number of pools: 1 2016-08-21T09:40:50.873105Z 0 [Note] InnoDB: Not using CPU crc32 instructions 2016-08-21T09:40:50.873105Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M 2016-08-21T09:40:50.873105Z 0 [Note] InnoDB: Completed initialization of buffer pool 2016-08-21T09:40:50.924273Z 0 [Note] InnoDB: Highest supported file format is Barracuda. 2016-08-21T09:40:50.992637Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2016-08-21T09:40:50.992637Z 0 [Note] InnoDB: Setting file '.\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2016-08-21T09:40:51.022657Z 0 [Note] InnoDB: File '.\ibtmp1' size is now 12 MB. 2016-08-21T09:40:51.030664Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. 2016-08-21T09:40:51.031680Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. 2016-08-21T09:40:51.031680Z 0 [Note] InnoDB: Waiting for purge to start 2016-08-21T09:40:51.082812Z 0 [Note] InnoDB: 5.7.14 started; log sequence number 2533806 2016-08-21T09:40:51.083768Z 0 [Note] InnoDB: Loading buffer pool(s) from E:\mysql-5.7.14-winx64\data\ib_buffer_pool 2016-08-21T09:40:51.083768Z 0 [Note] Plugin 'FEDERATED' is disabled. 2016-08-21T09:40:51.091770Z 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-08-21T09:40:51.093784Z 0 [Note] Server hostname (bind-address): '*'; port: 3306 2016-08-21T09:40:51.094769Z 0 [Note] IPv6 is available. 2016-08-21T09:40:51.095769Z 0 [Note] - '::' resolves to '::'; 2016-08-21T09:40:51.095769Z 0 [Note] Server socket created on IP: '::'. 2016-08-21T09:40:51.106778Z 0 [Note] InnoDB: Buffer pool(s) load completed at 160821 17:40:51 2016-08-21T09:40:51.125790Z 0 [Note] Event Scheduler: Loaded 0 events 2016-08-21T09:40:51.125790Z 0 [Note] MySQL: ready for connections. Version: '5.7.14' socket: '' port: 3306 MySQL Community Server (GPL) 2016-08-21T09:48:19.224017Z 0 [Note] MySQL: Normal shutdown 2016-08-21T09:48:19.224017Z 0 [Note] Giving 0 client threads a chance to die gracefully 2016-08-21T09:48:19.224017Z 0 [Note] Shutting down slave threads 2016-08-21T09:48:19.224017Z 0 [Note] Forcefully disconnecting 0 remaining clients 2016-08-21T09:48:19.224017Z 0 [Note] Event Scheduler: Purging the queue. 0 events 2016-08-21T09:48:19.224017Z 0 [Note] Binlog end 2016-08-21T09:48:19.224017Z 0 [Note] Shutting down plugin 'ngram' 2016-08-21T09:48:19.224017Z 0 [Note] Shutting down plugin 'partition' 2016-08-21T09:48:19.224017Z 0 [Note] Shutting down plugin 'BLACKHOLE' 2016-08-21T09:48:19.224017Z 0 [Note] Shutting down plugin 'ARCHIVE' 2016-08-21T09:48:19.224017Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA' 2016-08-21T09:48:19.224017Z 0 [Note] Shutting down plugin 'MRG_MYISAM' 2016-08-21T09:48:19.224017Z 0 [Note] Shutting down plugin 'MyISAM' 2016-08-21T09:48:19.224017Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL' 2016-08-21T09:48:19.224017Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES' 2016-08-21T09:48:19.224017Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES' 2016-08-21T09:48:19.224017Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS' 2016-08-21T09:48:19.224017Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN' 2016-08-21T09:48:19.224017Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS' 2016-08-21T09:48:19.224017Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS' 2016-08-21T09:48:19.224017Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES' 2016-08-21T09:48:19.224017Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS' 2016-08-21T09:48:19.224017Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES' 2016-08-21T09:48:19.224017Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE' 2016-08-21T09:48:19.224017Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE' 2016-08-21T09:48:19.224017Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG' 2016-08-21T09:48:19.224017Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED' 2016-08-21T09:48:19.224017Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED' 2016-08-21T09:48:19.224017Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD' 2016-08-21T09:48:19.224017Z 0 [Note] Shutting down plugin 'INNODB_METRICS' 2016-08-21T09:48:19.224017Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO' 2016-08-21T09:48:19.224017Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS' 2016-08-21T09:48:19.224017Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU' 2016-08-21T09:48:19.224017Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE' 2016-08-21T09:48:19.239642Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET' 2016-08-21T09:48:19.239642Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX' 2016-08-21T09:48:19.239642Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET' 2016-08-21T09:48:19.239642Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM' 2016-08-21T09:48:19.239642Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET' 2016-08-21T09:48:19.239642Z 0 [Note] Shutting down plugin 'INNODB_CMP' 2016-08-21T09:48:19.239642Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS' 2016-08-21T09:48:19.239642Z 0 [Note] Shutting down plugin 'INNODB_LOCKS' 2016-08-21T09:48:19.239642Z 0 [Note] Shutting down plugin 'INNODB_TRX' 2016-08-21T09:48:19.239642Z 0 [Note] Shutting down plugin 'InnoDB' 2016-08-21T09:48:19.239642Z 0 [Note] InnoDB: FTS optimize thread exiting. 2016-08-21T09:48:19.239642Z 0 [Note] InnoDB: Starting shutdown... 2016-08-21T09:48:19.349019Z 0 [Note] InnoDB: Dumping buffer pool(s) to E:\mysql-5.7.14-winx64\data\ib_buffer_pool 2016-08-21T09:48:19.349019Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 160821 17:48:19 2016-08-21T09:48:20.744674Z 0 [Note] InnoDB: Shutdown completed; log sequence number 2533834 2016-08-21T09:48:20.744674Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2016-08-21T09:48:20.744674Z 0 [Note] Shutting down plugin 'MEMORY' 2016-08-21T09:48:20.744674Z 0 [Note] Shutting down plugin 'CSV' 2016-08-21T09:48:20.744674Z 0 [Note] Shutting down plugin 'sha256_password' 2016-08-21T09:48:20.744674Z 0 [Note] Shutting down plugin 'mysql_native_password' 2016-08-21T09:48:20.744674Z 0 [Note] Shutting down plugin 'binlog' 2016-08-21T09:48:20.744674Z 0 [Note] MySQL: Shutdown complete
烟影随梦 2016-08-21
  • 打赏
  • 举报
 回复
我今天的错误日志：上半部分 2016-08-21T09:37:20.097891Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2016-08-21T09:37:20.098891Z 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. 2016-08-21T09:37:20.098891Z 0 [Warning] 'NO_AUTO_CREATE_USER' sql mode was not set. 2016-08-21T09:37:20.098891Z 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-08-21T09:37:20.099901Z 0 [Note] MySQL (mysqld 5.7.14) starting as process 187856 ... 2016-08-21T09:37:20.156932Z 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions 2016-08-21T09:37:20.156932Z 0 [Note] InnoDB: Uses event mutexes 2016-08-21T09:37:20.157933Z 0 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier 2016-08-21T09:37:20.157933Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.3 2016-08-21T09:37:20.163937Z 0 [Note] InnoDB: Number of pools: 1 2016-08-21T09:37:20.168959Z 0 [Note] InnoDB: Not using CPU crc32 instructions 2016-08-21T09:37:20.172945Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M 2016-08-21T09:37:20.179949Z 0 [Note] InnoDB: Completed initialization of buffer pool 2016-08-21T09:37:20.232986Z 0 [Note] InnoDB: Highest supported file format is Barracuda. 2016-08-21T09:37:20.414114Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2016-08-21T09:37:20.414114Z 0 [Note] InnoDB: Setting file '.\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2016-08-21T09:37:20.443135Z 0 [Note] InnoDB: File '.\ibtmp1' size is now 12 MB. 2016-08-21T09:37:20.450140Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. 2016-08-21T09:37:20.451140Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. 2016-08-21T09:37:20.452141Z 0 [Note] InnoDB: Waiting for purge to start 2016-08-21T09:37:20.503183Z 0 [Note] InnoDB: 5.7.14 started; log sequence number 2533750 2016-08-21T09:37:20.504178Z 0 [Note] InnoDB: Loading buffer pool(s) from E:\mysql-5.7.14-winx64\data\ib_buffer_pool 2016-08-21T09:37:20.506181Z 0 [Note] Plugin 'FEDERATED' is disabled. 2016-08-21T09:37:20.532215Z 0 [Note] InnoDB: Buffer pool(s) load completed at 160821 17:37:20 2016-08-21T09:37:20.542254Z 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-08-21T09:37:20.548208Z 0 [Note] Server hostname (bind-address): '*'; port: 3306 2016-08-21T09:37:20.549209Z 0 [Note] IPv6 is available. 2016-08-21T09:37:20.549209Z 0 [Note] - '::' resolves to '::'; 2016-08-21T09:37:20.550210Z 0 [Note] Server socket created on IP: '::'. 2016-08-21T09:37:21.326775Z 0 [Note] Event Scheduler: Loaded 0 events 2016-08-21T09:37:21.326775Z 0 [Note] MySQL: ready for connections. Version: '5.7.14' socket: '' port: 3306 MySQL Community Server (GPL) 2016-08-21T09:38:02.065247Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2016-08-21T09:38:02.065247Z 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. 2016-08-21T09:38:02.065247Z 0 [Warning] 'NO_AUTO_CREATE_USER' sql mode was not set. 2016-08-21T09:38:02.065247Z 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-08-21T09:38:02.065247Z 0 [Note] MySQL (mysqld 5.7.14) starting as process 185384 ... 2016-08-21T09:38:02.079257Z 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions 2016-08-21T09:38:02.079257Z 0 [Note] InnoDB: Uses event mutexes 2016-08-21T09:38:02.080258Z 0 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier 2016-08-21T09:38:02.080258Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.3 2016-08-21T09:38:02.080258Z 0 [Note] InnoDB: Number of pools: 1 2016-08-21T09:38:02.081258Z 0 [Note] InnoDB: Not using CPU crc32 instructions 2016-08-21T09:38:02.083260Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M 2016-08-21T09:38:02.089264Z 0 [Note] InnoDB: Completed initialization of buffer pool 2016-08-21T09:38:02.116284Z 0 [Note] InnoDB: Highest supported file format is Barracuda. 2016-08-21T09:38:02.119299Z 0 [Note] InnoDB: Log scan progressed past the checkpoint lsn 2533769 2016-08-21T09:38:02.119299Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 2533778 2016-08-21T09:38:02.122289Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 2533778 2016-08-21T09:38:02.122289Z 0 [Note] InnoDB: Database was not shutdown normally! 2016-08-21T09:38:02.122289Z 0 [Note] InnoDB: Starting crash recovery. 2016-08-21T09:38:02.298544Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2016-08-21T09:38:02.298544Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2016-08-21T09:38:02.299545Z 0 [Note] InnoDB: Setting file '.\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2016-08-21T09:38:02.363591Z 0 [Note] InnoDB: File '.\ibtmp1' size is now 12 MB. 2016-08-21T09:38:02.373599Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. 2016-08-21T09:38:02.374599Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. 2016-08-21T09:38:02.374599Z 0 [Note] InnoDB: Waiting for purge to start 2016-08-21T09:38:02.426635Z 0 [Note] InnoDB: 5.7.14 started; log sequence number 2533778 2016-08-21T09:38:02.427636Z 0 [Note] InnoDB: Loading buffer pool(s) from E:\mysql-5.7.14-winx64\data\ib_buffer_pool 2016-08-21T09:38:02.427636Z 0 [Note] Plugin 'FEDERATED' is disabled. 2016-08-21T09:38:02.438643Z 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-08-21T09:38:02.440645Z 0 [Note] Server hostname (bind-address): '*'; port: 3306 2016-08-21T09:38:02.442648Z 0 [Note] IPv6 is available. 2016-08-21T09:38:02.442648Z 0 [Note] - '::' resolves to '::'; 2016-08-21T09:38:02.443649Z 0 [Note] Server socket created on IP: '::'. 2016-08-21T09:38:02.449651Z 0 [Note] InnoDB: Buffer pool(s) load completed at 160821 17:38:02 2016-08-21T09:38:02.481674Z 0 [Note] Event Scheduler: Loaded 0 events 2016-08-21T09:38:02.481674Z 0 [Note] MySQL: ready for connections. Version: '5.7.14' socket: '' port: 3306 MySQL Community Server (GPL) 2016-08-21T09:38:15.668164Z 0 [Note] MySQL: Normal shutdown 2016-08-21T09:38:15.669165Z 0 [Note] Giving 0 client threads a chance to die gracefully 2016-08-21T09:38:15.669165Z 0 [Note] Shutting down slave threads 2016-08-21T09:38:15.670166Z 0 [Note] Forcefully disconnecting 0 remaining clients 2016-08-21T09:38:15.670166Z 0 [Note] Event Scheduler: Purging the queue. 0 events 2016-08-21T09:38:15.671166Z 0 [Note] Binlog end 2016-08-21T09:38:15.672175Z 0 [Note] Shutting down plugin 'ngram' 2016-08-21T09:38:15.673169Z 0 [Note] Shutting down plugin 'partition' 2016-08-21T09:38:15.673169Z 0 [Note] Shutting down plugin 'BLACKHOLE' 2016-08-21T09:38:15.673169Z 0 [Note] Shutting down plugin 'ARCHIVE' 2016-08-21T09:38:15.673169Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA' 2016-08-21T09:38:15.673169Z 0 [Note] Shutting down plugin 'MRG_MYISAM' 2016-08-21T09:38:15.674171Z 0 [Note] Shutting down plugin 'MyISAM' 2016-08-21T09:38:15.674171Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL' 2016-08-21T09:38:15.674171Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES' 2016-08-21T09:38:15.674171Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES' 2016-08-21T09:38:15.674171Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS' 2016-08-21T09:38:15.675171Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN' 2016-08-21T09:38:15.675171Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS' 2016-08-21T09:38:15.675171Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS' 2016-08-21T09:38:15.675171Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES' 2016-08-21T09:38:15.676171Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS' 2016-08-21T09:38:15.676171Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES' 2016-08-21T09:38:15.676171Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE' 2016-08-21T09:38:15.676171Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE' 2016-08-21T09:38:15.676171Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG' 2016-08-21T09:38:15.677172Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED' 2016-08-21T09:38:15.677172Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED' 2016-08-21T09:38:15.677172Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD' 2016-08-21T09:38:15.677172Z 0 [Note] Shutting down plugin 'INNODB_METRICS' 2016-08-21T09:38:15.677172Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO' 2016-08-21T09:38:15.678173Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS' 2016-08-21T09:38:15.678173Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU' 2016-08-21T09:38:15.678173Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
烟影随梦 2016-08-21
  • 打赏
  • 举报
 回复
。。。没人嘛，我好慌
mysql插入长字符串_求助! php mysql insert 长字符串不能插入问题.
语句是这样的:$sql = "INSERT INTO `{$table->column_list_page}` set nID='{$_REQUEST['NodeID']}',Title='{$_REQUEST['Title']}',Author='{$_REQUEST['Author']}',Content='{$_REQUEST['Content']}',Note='{$_REQUEST...
Mac下配置PHP＋MySql环境【生产环境】
由于最近需要布置mantis用来进行bug追踪，在此记录其过程。 由于PHP apache环境在Mac OS上是自带的，所以不需要另处下安装包，只需要简单配置一下即可。 首先打开终端输入命令： sudo vim /etc/apache2/httpd.conf 其中有一行是这样的 #LoadModule php5_module libexec/apache2/libphp5
悄悄告诉你，从小白逆袭成技术大佬，你还差这步，2024年最新mysqldba面试题及答案
在开头跟大家分享的时候我就说，面试我是没有做好准备的，全靠平时的积累，确实有点临时抱佛脚了，以至于我自己还是挺懊恼的。（准备好了或许可以拿个40k，没做准备只有30k+，你们懂那种感觉吗）如何准备面试？1、前期铺垫（技术沉积）程序员面试其实是对于技术的一次摸底考试，你的技术牛逼，那你就是大爷。大厂对于技术的要求主要体现在：基础，原理，深入研究源码，广度，实战五个方面，也只有将原理理论结合实战才能把技术点吃透。
放弃付费版的Navicat吧，这6款开源的数据库客户端一样很香，收藏收藏！
在数据库管理的世界里，Navicat一直是许多开发者和管理员心中的“老大哥”。Navicat确实有它的过人之处。作为一款商业软件，它提供了直观的图形界面、强大的数据导入导出功能，以及对多种数据库（MySQL、PostgreSQL、SQLite等）的广泛支持。无论是编写SQL查询，还是管理表结构，甚至生成数据库关系图（ER图），Navicat都能让你轻松上手。特别是对于新手来说，它的“傻瓜式”操作简直是救命稻草。但凡事都有两面性。Navicat的高昂价格是最大的“痛点”。
SUN Solaris　问题小结
SUN服务器可能遇到的问题总结(一) 1） Q：现在遇到这样一个问题，telnet一台SUN机时报下面的错误： No utmpx entry. You must exec "login" from the lowest level "shell". 我做了下面的处理后： cd /var/adm mv utmpx utmpxbak touch utmpx telnet 恢复了正常，可在该机...
MySQL

57,064

社区成员

56,759

社区内容

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

加载中

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

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

+ 用AI写文章