本人第一次接触MYSQL,有个新手问题请教各位大侠~

2016-04-22 10:59:49 746 阅读 AI 写同款 · GEO 优化AI 选题数据监测一键分发 ›

wilson小顺墨衍会员 · AI 创作全网分发关注 + 加入社区

【49】Camunda8-Self-Managed部署之Docker方式围绕camunda8 self-managed，介绍了基于Docker部署相关服务的过程。阅读详情

配置完后打不开，还有服务里的MYSQL也打不开，这是为啥呢？网上好多办法都不行。。。。

...全文

基于STM32的智能交通灯管理系统设计本项目基于STM32微控制器设计了一个智能交通灯管理系统，通过多个传感器模块实现对交通灯的智能化控制。项目涉及硬件电路设计、传感器数据采集和逻辑控制实现，适用于城市交通路口或小区路口。该基于STM32的智能交通灯系统通过超声波传感器实现了流量监测，结合LED和蜂鸣器实现了自动交通信号控制，适用于城市或社区路口。基于STM32CubeMX生成的框架，编写红绿灯切换、流量监测和蜂鸣器控制的代码。以下为主循环，通过不断读取传感器数据，结合交通灯和蜂鸣器模块实现智能交通灯控制。阅读详情

wilson小顺

MySQL 57,062 成员 56,759 内容

+ 关注 + 加入社区

切换为时间正序

qq_34751291 2016-05-04

打赏
举报

引用 2 楼 wilson小顺的回复:

还是不行

你要先找到mysql程序的位置才行

gikod 2016-04-25

打赏
举报

引用 14 楼 wilsonXiaoShun 的回复:

[quote=引用 12 楼 gikod 的回复:] 问题是下面这段，你的文件不全或者权限不对。如果只是新安装的做实验，说明安装过程不正常，卸载，删除干净重新安装最省事。如果有兴趣挑战，可以用mysqld --initialize初始化一套新的database文件。

[/quote] 我说的很清楚啊。你即使initialize以后，依然权限不对或文件不全，所以叫做挑战。这时候如果愿意继续挑战，就可以逐次检查文件是否存在，是否有恰当权限。比如，把现在的整个目录重命名，再卸载/安装一遍mysql，接着比较所有文件到底是否齐全、大小和内容是否一致、权限是否不同等等，就可以找到根本原因。如果懒得做研究，那么就重新安装，如果重新安装也搞不定，那么就重新安装windows再安装mysql。

wilson小顺 2016-04-23

打赏
举报

[quote=引用 12 楼 gikod 的回复:]
问题是下面这段，你的文件不全或者权限不对。
如果只是新安装的做实验，说明安装过程不正常，卸载，删除干净重新安装最省事。
如果有兴趣挑战，可以用mysqld --initialize初始化一套新的database文件。

[code=text]
2016-04-22T09:03:26.225033Z 0 [Note] InnoDB: Loading buffer pool(s) from E:\mysql\mysql-5.7.12-winx64\data\ib_buffer_pool
MySQL: Table 'mysql.plugin' doesn't exist
2016-04-22T09:03:26.229034Z 0 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
2016-04-22T09:03:26.234034Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2016-04-22T09:03:26.236034Z 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-04-22T09:03:26.238034Z 0 [Note] Server hostname (bind-address): '*'; port: 3306
2016-04-22T09:03:26.241034Z 0 [Note] IPv6 is available.
2016-04-22T09:03:26.242034Z 0 [Note] - '::' resolves to '::';
2016-04-22T09:03:26.244035Z 0 [Note] InnoDB: Buffer pool(s) load completed at 160422 17:03:26
2016-04-22T09:03:26.245035Z 0 [Note] Server socket created on IP: '::'.
2016-04-22T09:03:26.248035Z 0 [Warning] Failed to open optimizer cost constant tables

2016-04-22T09:03:26.252035Z 0 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist
2016-04-22T09:03:26.255035Z 0 [ERROR] Aborting
2016-04-23T00:45:08.773577Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2016-04-23T00:45:08.773577Z 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-04-23T00:45:08.954588Z 0 [Note] MySQL (mysqld 5.7.12) starting as process 7928 ...
2016-04-23T00:45:08.980589Z 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-04-23T00:45:08.985589Z 0 [Note] InnoDB: Uses event mutexes
2016-04-23T00:45:08.988590Z 0 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier
2016-04-23T00:45:08.997590Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-04-23T00:45:08.999590Z 0 [Note] InnoDB: Number of pools: 1
2016-04-23T00:45:09.000590Z 0 [Note] InnoDB: Not using CPU crc32 instructions
2016-04-23T00:45:09.090595Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2016-04-23T00:45:09.123597Z 0 [Note] InnoDB: Completed initialization of buffer pool
2016-04-23T00:45:09.251605Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2016-04-23T00:45:09.471617Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2016-04-23T00:45:09.472617Z 0 [Note] InnoDB: Setting file '.\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2016-04-23T00:45:09.726632Z 0 [Note] InnoDB: File '.\ibtmp1' size is now 12 MB.
2016-04-23T00:45:09.764634Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2016-04-23T00:45:09.773634Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2016-04-23T00:45:09.775635Z 0 [Note] InnoDB: Waiting for purge to start
2016-04-23T00:45:09.830638Z 0 [Note] InnoDB: 5.7.12 started; log sequence number 1210518
2016-04-23T00:45:09.844638Z 0 [Note] Plugin 'FEDERATED' is disabled.
2016-04-23T00:45:09.848639Z 0 [Note] InnoDB: Loading buffer pool(s) from E:\mysql\mysql-5.7.12-winx64\data\ib_buffer_pool
MySQL: Table 'mysql.plugin' doesn't exist
2016-04-23T00:45:09.854639Z 0 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
2016-04-23T00:45:09.943644Z 0 [Note] InnoDB: Buffer pool(s) load completed at 160423 8:45:09
2016-04-23T00:45:09.983646Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2016-04-23T00:45:10.006648Z 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-04-23T00:45:10.009648Z 0 [Note] Server hostname (bind-address): '*'; port: 3306
2016-04-23T00:45:10.014648Z 0 [Note] IPv6 is available.
2016-04-23T00:45:10.015648Z 0 [Note] - '::' resolves to '::';
2016-04-23T00:45:10.016648Z 0 [Note] Server socket created on IP: '::'.
2016-04-23T00:45:10.023649Z 0 [Warning] Failed to open optimizer cost constant tables

2016-04-23T00:45:10.026649Z 0 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist
2016-04-23T00:45:10.028649Z 0 [ERROR] Aborting

2016-04-23T00:45:10.029649Z 0 [Note] Binlog end
2016-04-23T00:45:10.029649Z 0 [Note] Shutting down plugin 'ngram'
2016-04-23T00:45:10.030649Z 0 [Note] Shutting down plugin 'partition'
2016-04-23T00:45:10.030649Z 0 [Note] Shutting down plugin 'BLACKHOLE'
2016-04-23T00:45:10.031649Z 0 [Note] Shutting down plugin 'ARCHIVE'
2016-04-23T00:45:10.031649Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2016-04-23T00:45:10.032649Z 0 [Note] Shutting down plugin 'MRG_MYISAM'
2016-04-23T00:45:10.033649Z 0 [Note] Shutting down plugin 'MyISAM'
2016-04-23T00:45:10.033649Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL'
2016-04-23T00:45:10.034649Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2016-04-23T00:45:10.035649Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2016-04-23T00:45:10.036649Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2016-04-23T00:45:10.036649Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2016-04-23T00:45:10.037650Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2016-04-23T00:45:10.038650Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2016-04-23T00:45:10.038650Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2016-04-23T00:45:10.039650Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2016-04-23T00:45:10.040650Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2016-04-23T00:45:10.040650Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2016-04-23T00:45:10.041650Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2016-04-23T00:45:10.042650Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2016-04-23T00:45:10.042650Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2016-04-23T00:45:10.043650Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2016-04-23T00:45:10.045650Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2016-04-23T00:45:10.045650Z 0 [Note] Shutting down plugin 'INNODB_METRICS'
2016-04-23T00:45:10.048650Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO'
2016-04-23T00:45:10.048650Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2016-04-23T00:45:10.049650Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2016-04-23T00:45:10.051650Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2016-04-23T00:45:10.051650Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2016-04-23T00:45:10.058651Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2016-04-23T00:45:10.058651Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2016-04-23T00:45:10.059651Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM'
2016-04-23T00:45:10.059651Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2016-04-23T00:45:10.060651Z 0 [Note] Shutting down plugin 'INNODB_CMP'
2016-04-23T00:45:10.060651Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2016-04-23T00:45:10.062651Z 0 [Note] Shutting down plugin 'INNODB_LOCKS'
2016-04-23T00:45:10.063651Z 0 [Note] Shutting down plugin 'INNODB_TRX'
2016-04-23T00:45:10.063651Z 0 [Note] Shutting down plugin 'InnoDB'
2016-04-23T00:45:10.064651Z 0 [Note] InnoDB: FTS optimize thread exiting.
2016-04-23T00:45:10.065651Z 0 [Note] InnoDB: Starting shutdown...
2016-04-23T00:45:10.166657Z 0 [Note] InnoDB: Dumping buffer pool(s) to E:\mysql\mysql-5.7.12-winx64\data\ib_buffer_pool
2016-04-23T00:45:10.172657Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 160423 8:45:10
2016-04-23T00:45:11.514734Z 0 [Note] InnoDB: Shutdown completed; log sequence number 1210537
2016-04-23T00:45:11.515734Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2016-04-23T00:45:11.522734Z 0 [Note] Shutting down plugin 'MEMORY'
2016-04-23T00:45:11.523735Z 0 [Note] Shutting down plugin 'CSV'
2016-04-23T00:45:11.523735Z 0 [Note] Shutting down plugin 'sha256_password'
2016-04-23T00:45:11.524735Z 0 [Note] Shutting down plugin 'mysql_native_password'
2016-04-23T00:45:11.525735Z 0 [Note] Shutting down plugin 'binlog'
2016-04-23T00:45:11.525735Z 0 [Note] MySQL: Shutdown complete

init之后还是打不开

wilson小顺 2016-04-22

打赏
举报

还是不行

qq_34751291 2016-04-22

打赏
举报

mysql -u用户名 -p密码试一下如果还不行的话开启root远程

ACMAIN_CHM 2016-04-22

打赏
举报

建议重新安装MYSQL

gikod 2016-04-22

打赏
举报

问题是下面这段，你的文件不全或者权限不对。如果只是新安装的做实验，说明安装过程不正常，卸载，删除干净重新安装最省事。如果有兴趣挑战，可以用mysqld --initialize初始化一套新的database文件。


2016-04-22T09:03:26.225033Z 0 [Note] InnoDB: Loading buffer pool(s) from E:\mysql\mysql-5.7.12-winx64\data\ib_buffer_pool
MySQL: Table 'mysql.plugin' doesn't exist
2016-04-22T09:03:26.229034Z 0 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
2016-04-22T09:03:26.234034Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2016-04-22T09:03:26.236034Z 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-04-22T09:03:26.238034Z 0 [Note] Server hostname (bind-address): '*'; port: 3306
2016-04-22T09:03:26.241034Z 0 [Note] IPv6 is available.
2016-04-22T09:03:26.242034Z 0 [Note]   - '::' resolves to '::';
2016-04-22T09:03:26.244035Z 0 [Note] InnoDB: Buffer pool(s) load completed at 160422 17:03:26
2016-04-22T09:03:26.245035Z 0 [Note] Server socket created on IP: '::'.
2016-04-22T09:03:26.248035Z 0 [Warning] Failed to open optimizer cost constant tables

2016-04-22T09:03:26.252035Z 0 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist
2016-04-22T09:03:26.255035Z 0 [ERROR] Aborting

wilson小顺 2016-04-22

打赏
举报

引用 8 楼 qq423399099 的回复:

远程指的是访问同一个网段下的某台服务器。。。

所以我远程访问也没用..........我本地就是上不去，你是否能帮我看一下上面的LOG

wilson小顺 2016-04-22

打赏
举报

引用 9 楼 ACMAIN_CHM 的回复:

检查一下MYSQL的错误日志，贴出其中最新的日志以供分析。可以百度一下 MYSQL错误日志以知道在哪如何找到。

2016-04-22T09:03:25.524995Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2016-04-22T09:03:25.524995Z 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-04-22T09:03:25.527995Z 0 [Note] MySQL (mysqld 5.7.12) starting as process 4784 ... 2016-04-22T09:03:25.543996Z 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions 2016-04-22T09:03:25.544996Z 0 [Note] InnoDB: Uses event mutexes 2016-04-22T09:03:25.546996Z 0 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier 2016-04-22T09:03:25.547996Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.3 2016-04-22T09:03:25.548996Z 0 [Note] InnoDB: Number of pools: 1 2016-04-22T09:03:25.549997Z 0 [Note] InnoDB: Not using CPU crc32 instructions 2016-04-22T09:03:25.655003Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M 2016-04-22T09:03:25.674004Z 0 [Note] InnoDB: Completed initialization of buffer pool 2016-04-22T09:03:25.793009Z 0 [Note] InnoDB: Highest supported file format is Barracuda. 2016-04-22T09:03:25.908015Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2016-04-22T09:03:25.910015Z 0 [Note] InnoDB: Setting file '.\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2016-04-22T09:03:26.145029Z 0 [Note] InnoDB: File '.\ibtmp1' size is now 12 MB. 2016-04-22T09:03:26.160030Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. 2016-04-22T09:03:26.163030Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. 2016-04-22T09:03:26.165030Z 0 [Note] InnoDB: Waiting for purge to start 2016-04-22T09:03:26.219033Z 0 [Note] InnoDB: 5.7.12 started; log sequence number 1210423 2016-04-22T09:03:26.223033Z 0 [Note] Plugin 'FEDERATED' is disabled. 2016-04-22T09:03:26.225033Z 0 [Note] InnoDB: Loading buffer pool(s) from E:\mysql\mysql-5.7.12-winx64\data\ib_buffer_pool MySQL: Table 'mysql.plugin' doesn't exist 2016-04-22T09:03:26.229034Z 0 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it. 2016-04-22T09:03:26.234034Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened. 2016-04-22T09:03:26.236034Z 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-04-22T09:03:26.238034Z 0 [Note] Server hostname (bind-address): '*'; port: 3306 2016-04-22T09:03:26.241034Z 0 [Note] IPv6 is available. 2016-04-22T09:03:26.242034Z 0 [Note] - '::' resolves to '::'; 2016-04-22T09:03:26.244035Z 0 [Note] InnoDB: Buffer pool(s) load completed at 160422 17:03:26 2016-04-22T09:03:26.245035Z 0 [Note] Server socket created on IP: '::'. 2016-04-22T09:03:26.248035Z 0 [Warning] Failed to open optimizer cost constant tables 2016-04-22T09:03:26.252035Z 0 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist 2016-04-22T09:03:26.255035Z 0 [ERROR] Aborting 2016-04-22T09:03:26.255035Z 0 [Note] Binlog end 2016-04-22T09:03:26.255035Z 0 [Note] Shutting down plugin 'ngram' 2016-04-22T09:03:26.256035Z 0 [Note] Shutting down plugin 'partition' 2016-04-22T09:03:26.256035Z 0 [Note] Shutting down plugin 'BLACKHOLE' 2016-04-22T09:03:26.257035Z 0 [Note] Shutting down plugin 'ARCHIVE' 2016-04-22T09:03:26.257035Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA' 2016-04-22T09:03:26.258035Z 0 [Note] Shutting down plugin 'MRG_MYISAM' 2016-04-22T09:03:26.258035Z 0 [Note] Shutting down plugin 'MyISAM' 2016-04-22T09:03:26.259035Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL' 2016-04-22T09:03:26.260035Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES' 2016-04-22T09:03:26.260035Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES' 2016-04-22T09:03:26.261036Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS' 2016-04-22T09:03:26.261036Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN' 2016-04-22T09:03:26.262036Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS' 2016-04-22T09:03:26.262036Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS' 2016-04-22T09:03:26.263036Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES' 2016-04-22T09:03:26.264036Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS' 2016-04-22T09:03:26.264036Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES' 2016-04-22T09:03:26.265036Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE' 2016-04-22T09:03:26.265036Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE' 2016-04-22T09:03:26.266036Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG' 2016-04-22T09:03:26.267036Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED' 2016-04-22T09:03:26.267036Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED' 2016-04-22T09:03:26.268036Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD' 2016-04-22T09:03:26.269036Z 0 [Note] Shutting down plugin 'INNODB_METRICS' 2016-04-22T09:03:26.269036Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO' 2016-04-22T09:03:26.270036Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS' 2016-04-22T09:03:26.271036Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU' 2016-04-22T09:03:26.272036Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE' 2016-04-22T09:03:26.272036Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET' 2016-04-22T09:03:26.273036Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX' 2016-04-22T09:03:26.273036Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET' 2016-04-22T09:03:26.274036Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM' 2016-04-22T09:03:26.275036Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET' 2016-04-22T09:03:26.275036Z 0 [Note] Shutting down plugin 'INNODB_CMP' 2016-04-22T09:03:26.276036Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS' 2016-04-22T09:03:26.276036Z 0 [Note] Shutting down plugin 'INNODB_LOCKS' 2016-04-22T09:03:26.277036Z 0 [Note] Shutting down plugin 'INNODB_TRX' 2016-04-22T09:03:26.277036Z 0 [Note] Shutting down plugin 'InnoDB' 2016-04-22T09:03:26.278036Z 0 [Note] InnoDB: FTS optimize thread exiting. 2016-04-22T09:03:26.283037Z 0 [Note] InnoDB: Starting shutdown... 2016-04-22T09:03:26.384043Z 0 [Note] InnoDB: Dumping buffer pool(s) to E:\mysql\mysql-5.7.12-winx64\data\ib_buffer_pool 2016-04-22T09:03:26.389043Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 160422 17:03:26 2016-04-22T09:03:27.685114Z 0 [Note] InnoDB: Shutdown completed; log sequence number 1210442 2016-04-22T09:03:27.687114Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2016-04-22T09:03:27.687114Z 0 [Note] Shutting down plugin 'MEMORY' 2016-04-22T09:03:27.687114Z 0 [Note] Shutting down plugin 'CSV' 2016-04-22T09:03:27.687114Z 0 [Note] Shutting down plugin 'sha256_password' 2016-04-22T09:03:27.687114Z 0 [Note] Shutting down plugin 'mysql_native_password' 2016-04-22T09:03:27.687114Z 0 [Note] Shutting down plugin 'binlog' 2016-04-22T09:03:27.687114Z 0 [Note] MySQL: Shutdown complete 麻烦大家看一下LOG啥原因

ACMAIN_CHM 2016-04-22

打赏
举报

检查一下MYSQL的错误日志，贴出其中最新的日志以供分析。可以百度一下 MYSQL错误日志以知道在哪如何找到。

小灸舞 2016-04-22

打赏
举报

远程指的是访问同一个网段下的某台服务器。。。

wilson小顺 2016-04-22

打赏
举报

引用 5 楼 qq423399099 的回复:

不知道楼主是要登录本机还是远程的如果是本机：(我本机的MYSQL的ROOT默认是没有密码的，要登录本机的话记得要有mysqld.exe的进程启动着)
mysql -u root -p
如果是远程
mysql -h 192.168.1.7 -u cj123 -p

因为本地我登录会提示无法启动MYSQL服务，远程的话，意思是连用外网IP连接吗？

wilson小顺 2016-04-22

打赏
举报

引用 4 楼 gikod 的回复:

看看你的mysql的log和err文件，在mysql的或者data目录下。里面有奇怪的地方就贴上来吧。

是哪个？

小灸舞 2016-04-22

打赏
举报

不知道楼主是要登录本机还是远程的
如果是本机：(我本机的MYSQL的ROOT默认是没有密码的，要登录本机的话记得要有mysqld.exe的进程启动着)

mysql -u root -p

如果是远程

mysql -h 192.168.1.7 -u cj123 -p

gikod 2016-04-22

打赏
举报

看看你的mysql的log和err文件，在mysql的或者data目录下。里面有奇怪的地方就贴上来吧。

wilson小顺 2016-04-22

打赏
举报

引用 1 楼 qq_34751291 的回复:

mysql -u用户名 -p密码试一下如果还不行的话开启root远程

远程登录的话，不是要输入HOST吗？

本人第一次接触MYSQL,有个新手问题请教各位大侠~

相关推荐