哪位大神帮帮忙！刚搭建的论坛老出问题，一直弄不好，快崩溃了！！！

自己刚用Discuz X3.4刚搭建一个论坛，搭建的环境是：Windows Server2012 R2 IIS + PHP 7.2.3 + Mysql 5.7.21.0 + Discuz X3.4 ，论坛搭建正常，但每隔一段时间，就会出现Discuz! Database Error (0) notconnect错误（详见图），论坛无法登陆。重新启动操作系统后，论坛又恢复正常，但隔不长的时间又出现同样的错误，论坛又不能使用，度娘了很多资料，始终不知问题所在，自己感觉快崩溃了，麻烦各位大神能帮帮忙！谢谢！！！

检查mysql错误日志哦

mysql日志已上传，麻烦帮分析下错误，感谢！

2018-03-20T14:36:14.256603Z 0 [Warning] option 'read_buffer_size': unsigned value 0 adjusted to 8192
2018-03-20T14:36:14.256704Z 0 [Warning] option 'read_rnd_buffer_size': unsigned value 0 adjusted to 1
2018-03-20T14:36:14.256782Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2018-03-20T14:36:14.256800Z 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.
2018-03-20T14:36:14.259467Z 0 [Note] C:\Program Files\MySQL\MySQL Server 5.7\bin\mysqld.exe (mysqld 5.7.21-log) starting as process 2820 ...
2018-03-20T14:36:14.274688Z 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2018-03-20T14:36:14.275307Z 0 [Note] InnoDB: Uses event mutexes
2018-03-20T14:36:14.275666Z 0 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier
2018-03-20T14:36:14.276149Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.3
2018-03-20T14:36:14.276565Z 0 [Note] InnoDB: Adjusting innodb_buffer_pool_instances from 8 to 1 since innodb_buffer_pool_size is less than 1024 MiB
2018-03-20T14:36:14.277622Z 0 [Note] InnoDB: Number of pools: 1
2018-03-20T14:36:14.278141Z 0 [Note] InnoDB: Not using CPU crc32 instructions
2018-03-20T14:36:14.280810Z 0 [Note] InnoDB: Initializing buffer pool, total size = 8M, instances = 1, chunk size = 8M
2018-03-20T14:36:14.282379Z 0 [Note] InnoDB: Completed initialization of buffer pool
2018-03-20T14:36:14.320430Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2018-03-20T14:36:14.393123Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2018-03-20T14:36:14.394004Z 0 [Note] InnoDB: Setting file '.\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2018-03-20T14:36:14.427633Z 0 [Note] InnoDB: File '.\ibtmp1' size is now 12 MB.
2018-03-20T14:36:14.430379Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2018-03-20T14:36:14.431017Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2018-03-20T14:36:14.431812Z 0 [Note] InnoDB: Waiting for purge to start
2018-03-20T14:36:14.490638Z 0 [Note] InnoDB: 5.7.21 started; log sequence number 2551166
2018-03-20T14:36:14.491512Z 0 [Note] InnoDB: Loading buffer pool(s) from C:\ProgramData\MySQL\MySQL Server 5.7\Data\ib_buffer_pool
2018-03-20T14:36:14.491637Z 0 [Note] Plugin 'FEDERATED' is disabled.
2018-03-20T14:36:14.507663Z 0 [Warning] Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private key
2018-03-20T14:36:14.508552Z 0 [Note] Server hostname (bind-address): '*'; port: 3306
2018-03-20T14:36:14.509246Z 0 [Note] IPv6 is available.
2018-03-20T14:36:14.509623Z 0 [Note]   - '::' resolves to '::';
2018-03-20T14:36:14.510059Z 0 [Note] Server socket created on IP: '::'.
2018-03-20T14:36:14.527531Z 0 [Note] InnoDB: Buffer pool(s) load completed at 180320 22:36:14
2018-03-20T14:36:14.565366Z 0 [Note] Event Scheduler: Loaded 0 events
2018-03-20T14:36:14.566047Z 0 [Note] C:\Program Files\MySQL\MySQL Server 5.7\bin\mysqld.exe: ready for connections.
Version: '5.7.21-log'  socket: ''  port: 3306  MySQL Community Server (GPL)
2018-03-20T14:36:15.539607Z 2 [Note] Access denied for user ''@'localhost' (using password: NO)
2018-03-20T14:41:50.995370Z 0 [Note] C:\Program Files\MySQL\MySQL Server 5.7\bin\mysqld.exe: Normal shutdown
2018-03-20T14:41:51.008384Z 0 [Note] Giving 0 client threads a chance to die gracefully
2018-03-20T14:41:51.008610Z 0 [Note] Shutting down slave threads
2018-03-20T14:41:51.008781Z 0 [Note] Forcefully disconnecting 0 remaining clients
2018-03-20T14:41:51.008980Z 0 [Note] Event Scheduler: Purging the queue. 0 events
2018-03-20T14:41:51.009555Z 0 [Note] Binlog end
2018-03-20T14:41:51.011276Z 0 [Note] Shutting down plugin 'ngram'
2018-03-20T14:41:51.011455Z 0 [Note] Shutting down plugin 'partition'
2018-03-20T14:41:51.011661Z 0 [Note] Shutting down plugin 'BLACKHOLE'
2018-03-20T14:41:51.011826Z 0 [Note] Shutting down plugin 'ARCHIVE'
2018-03-20T14:41:51.011982Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2018-03-20T14:41:51.012189Z 0 [Note] Shutting down plugin 'MRG_MYISAM'
2018-03-20T14:41:51.012361Z 0 [Note] Shutting down plugin 'MyISAM'
2018-03-20T14:41:51.016186Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL'
2018-03-20T14:41:51.016390Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2018-03-20T14:41:51.016618Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2018-03-20T14:41:51.016811Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2018-03-20T14:41:51.017003Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2018-03-20T14:41:51.017186Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2018-03-20T14:41:51.017364Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2018-03-20T14:41:51.017545Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2018-03-20T14:41:51.017727Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2018-03-20T14:41:51.017913Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2018-03-20T14:41:51.018108Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2018-03-20T14:41:51.018293Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2018-03-20T14:41:51.019227Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2018-03-20T14:41:51.019407Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2018-03-20T14:41:51.019598Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2018-03-20T14:41:51.019776Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2018-03-20T14:41:51.019974Z 0 [Note] Shutting down plugin 'INNODB_METRICS'
2018-03-20T14:41:51.020234Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO'
2018-03-20T14:41:51.020641Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2018-03-20T14:41:51.021565Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2018-03-20T14:41:51.021758Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2018-03-20T14:41:51.022560Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2018-03-20T14:41:51.022761Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2018-03-20T14:41:51.022944Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2018-03-20T14:41:51.023124Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM'
2018-03-20T14:41:51.023291Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2018-03-20T14:41:51.023466Z 0 [Note] Shutting down plugin 'INNODB_CMP'
2018-03-20T14:41:51.023629Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2018-03-20T14:41:51.023804Z 0 [Note] Shutting down plugin 'INNODB_LOCKS'
2018-03-20T14:41:51.023969Z 0 [Note] Shutting down plugin 'INNODB_TRX'
2018-03-20T14:41:51.024129Z 0 [Note] Shutting down plugin 'InnoDB'
2018-03-20T14:41:51.062004Z 0 [Note] InnoDB: FTS optimize thread exiting.
2018-03-20T14:41:51.063267Z 0 [Note] InnoDB: Starting shutdown...
2018-03-20T14:41:51.169645Z 0 [Note] InnoDB: Dumping buffer pool(s) to C:\ProgramData\MySQL\MySQL Server 5.7\Data\ib_buffer_pool
2018-03-20T14:41:51.170462Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 180320 22:41:51
2018-03-20T14:41:51.834237Z 0 [Note] InnoDB: Shutdown completed; log sequence number 10879981
2018-03-20T14:41:51.834610Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2018-03-20T14:41:51.834830Z 0 [Note] Shutting down plugin 'MEMORY'
2018-03-20T14:41:51.834985Z 0 [Note] Shutting down plugin 'CSV'
2018-03-20T14:41:51.835131Z 0 [Note] Shutting down plugin 'sha256_password'
2018-03-20T14:41:51.835303Z 0 [Note] Shutting down plugin 'mysql_native_password'
2018-03-20T14:41:51.835624Z 0 [Note] Shutting down plugin 'binlog'
2018-03-20T14:41:51.840311Z 0 [Note] C:\Program Files\MySQL\MySQL Server 5.7\bin\mysqld.exe: Shutdown complete

从新安装mysql

无题_YeOXV 发表于 2018-3-28 15:33
从新安装mysql

谢谢您的建议。最后确认一下，真的需要重装mysql吗？不是设置的问题？重装mysql后，discuz还需要重装吗？再次感谢！！！

crx349 发表于 2018-3-28 14:48
检查mysql错误日志哦

mysql错误日志已贴到问题贴上了，麻烦帮分析指导一下，谢谢！！！

runer17 发表于 2018-3-28 15:49
谢谢您的建议。最后确认一下，真的需要重装mysql吗？不是设置的问题？重装mysql后，discuz还需要重装吗？ ...

mysql从新安装！！！！！！！！！

无题_YeOXV 发表于 2018-3-28 16:38
你qq多少

我的qq：2********6

runer17 发表于 2018-3-28 15:51
mysql错误日志已贴到问题贴上了，麻烦帮分析指导一下，谢谢！！！

重装下 mysql 5.6 看看