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

wilson小顺 2016-04-22 10:59:49

配置完后打不开，还有服务里的MYSQL也打不开，这是为啥呢？网上好多办法都不行。。。。
...全文
589 16 打赏 收藏 转发到动态 举报
写回复
用AI写文章
16 条回复
切换为时间正序
请发表友善的回复…
发表回复
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核心技术
第3章数据库函数大全：MySQL中有上百种函数之多，使用函数可以快速的解决我们很多开发问题，但是由于我们掌握的函数不够多，往往没有办法实际应用，本章节重点是让你掌握更多好用而你不知道的函数使用。第4章数据库...
SUN Solaris　问题小结
1） Q：现在遇到这样一个问题，telnet一台SUN机时报下面的错误： No utmpx entry. You must exec "login" from the lowest level "shell". 我做了下面的处理后： cd /var/adm mv utmpx utmpxbak touch utmpx ...
WEB开发文档2 总结
http://blog.donews.com/lvjiyong/archive/2006/06/29/931071.aspx怎样将后台生成的在内存中的图象显示到客户端Microsoft IE WebControls下载...显示数据下载中文名文件时保存文件名乱码问题关于用ASP.net绘图的问题...
postfix邮件系统完整版
http://www.kuqin.com/article/14mail/553326.html[原创] postfix邮件系统完整版来源 chinaunix.net 酷勤网整理redhat9+postfix+cyrus-sasl+mysql+postfixadmin+courier-imap+courier-
CSDN回帖得分大全（近两年）
请教一个关于栈的问题。c语言版 [C/C++ C语言] √ 求VC制作ISO镜像文件方法 [VC/MFC ATL/ActiveX/COM] √ 数据库错误，实在没办法了，求助解答！谢谢 [VC/MFC 数据库] √ 有...
MySQL

56,679

社区成员

56,709

社区内容

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

加载中

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

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

+ 用AI写文章