版本mysql 5.6.21.1
新手,下午正常操作学习修改root的密码,然后弄过最近不响应的goagent跟google chrome一下,重启后mysql就死活不动,
the the service mysql56 failed the most recent status change request with the message
the service mysql56 was not found in the Windows services
if problem persists please restart mysql notifier
用configure instance强行启动OK,但是,无法改变状态
删除两个ib_logfile的方法尝试过,未果,求解。
err日志
2014-11-30 16:47:14 1360 [Note] Giving 0 client threads a chance to die gracefully
2014-11-30 16:47:14 1360 [Note] Event Scheduler: Purging the queue. 0 events
2014-11-30 16:47:15 1360 [Note] Shutting down slave threads
2014-11-30 16:47:15 1360 [Note] Forcefully disconnecting 0 remaining clients
2014-11-30 16:47:17 1360 [Note] Binlog end
2014-11-30 16:47:32 1360 [Note] Shutting down plugin 'partition'
2014-11-30 16:47:32 1360 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2014-11-30 16:47:33 1360 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2014-11-30 16:47:33 1360 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2014-11-30 16:47:33 1360 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2014-11-30 16:47:33 1360 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2014-11-30 16:47:33 1360 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2014-11-30 16:47:33 1360 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2014-11-30 16:47:33 1360 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2014-11-30 16:47:33 1360 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2014-11-30 16:47:33 1360 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2014-11-30 16:47:33 1360 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2014-11-30 16:47:33 1360 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2014-11-30 16:47:33 1360 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2014-11-30 16:47:33 1360 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2014-11-30 16:47:33 1360 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2014-11-30 16:47:33 1360 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2014-11-30 16:47:33 1360 [Note] Shutting down plugin 'INNODB_METRICS'
2014-11-30 16:47:33 1360 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2014-11-30 16:47:33 1360 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2014-11-30 16:47:33 1360 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2014-11-30 16:47:33 1360 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2014-11-30 16:47:33 1360 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2014-11-30 16:47:33 1360 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2014-11-30 16:47:33 1360 [Note] Shutting down plugin 'INNODB_CMPMEM'
2014-11-30 16:47:33 1360 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2014-11-30 16:47:33 1360 [Note] Shutting down plugin 'INNODB_CMP'
2014-11-30 16:47:33 1360 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2014-11-30 16:47:33 1360 [Note] Shutting down plugin 'INNODB_LOCKS'
2014-11-30 16:47:33 1360 [Note] Shutting down plugin 'INNODB_TRX'
2014-11-30 16:47:33 1360 [Note] Shutting down plugin 'InnoDB'
2014-11-30 16:47:33 1360 [Note] InnoDB: FTS optimize thread exiting.
2014-11-30 16:47:34 1360 [Note] InnoDB: Starting shutdown...
2014-11-30 16:47:55 1360 [Note] InnoDB: Shutdown completed; log sequence number 8980090
2014-11-30 16:47:55 1360 [Note] Shutting down plugin 'BLACKHOLE'
2014-11-30 16:47:55 1360 [Note] Shutting down plugin 'ARCHIVE'
2014-11-30 16:47:55 1360 [Note] Shutting down plugin 'MRG_MYISAM'
2014-11-30 16:47:55 1360 [Note] Shutting down plugin 'MyISAM'
2014-11-30 16:47:56 1360 [Note] Shutting down plugin 'MEMORY'
2014-11-30 16:47:56 1360 [Note] Shutting down plugin 'CSV'
2014-11-30 16:47:56 1360 [Note] Shutting down plugin 'sha256_password'
2014-11-30 16:47:56 1360 [Note] Shutting down plugin 'mysql_old_password'
2014-11-30 16:47:56 1360 [Note] Shutting down plugin 'mysql_native_password'
2014-11-30 16:47:56 1360 [Note] Shutting down plugin 'binlog'
2014-11-30 16:47:56 1360 [Note] C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqld.exe: Shutdown complete2014-11-30 23:59:30 9108 [Note] Plugin 'FEDERATED' is disabled.
2014-11-30 23:59:31 2080 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator.
2014-11-30 23:59:31 9108 [Note] InnoDB: Using atomics to ref count buffer pool pages
2014-11-30 23:59:31 9108 [Note] InnoDB: The InnoDB memory heap is disabled
2014-11-30 23:59:31 9108 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2014-11-30 23:59:31 9108 [Note] InnoDB: Memory barrier is not used
2014-11-30 23:59:31 9108 [Note] InnoDB: Compressed tables use zlib 1.2.3
2014-11-30 23:59:31 9108 [Note] InnoDB: Not using CPU crc32 instructions
2014-11-30 23:59:31 9108 [Note] InnoDB: Initializing buffer pool, size = 91.0M
2014-11-30 23:59:31 9108 [Note] InnoDB: Completed initialization of buffer pool
2014-11-30 23:59:31 9108 [Note] InnoDB: Highest supported file format is Barracuda.
2014-12-01 00:00:29 9108 [Note] InnoDB: 128 rollback segment(s) are active.
2014-12-01 00:00:29 9108 [Note] InnoDB: Waiting for purge to start
2014-12-01 00:00:29 9108 [Note] InnoDB: 5.6.21 started; log sequence number 8980090
2014-12-01 00:00:30 9108 [Note] Server hostname (bind-address): '*'; port: 3306
2014-12-01 00:00:30 9108 [Note] IPv6 is available.
2014-12-01 00:00:30 9108 [Note] - '::' resolves to '::';
2014-12-01 00:00:30 9108 [Note] Server socket created on IP: '::'.
2014-12-01 00:00:35 9108 [Note] Event Scheduler: Loaded 0 events
2014-12-01 00:00:35 9108 [Note] C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqld.exe: ready for connections.
Version: '5.6.21-log' socket: '' port: 3306 MySQL Community Server (GPL)
2014-12-01 00:00:41 9108 [Note] C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqld.exe: Normal shutdown2014-12-01 00:00:41 9108 [Note] Giving 1 client threads a chance to die gracefully
2014-12-01 00:00:41 9108 [Note] Event Scheduler: Purging the queue. 0 events
2014-12-01 00:00:41 9108 [Note] Shutting down slave threads
2014-12-01 00:00:43 9108 [Note] Forcefully disconnecting 1 remaining clients
2014-12-01 00:00:43 9108 [Warning] C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqld.exe: Forcing close of thread 2 user: 'root'2014-12-01 00:00:43 9108 [Note] Binlog end
2014-12-01 00:00:43 9108 [Note] Shutting down plugin 'partition'
2014-12-01 00:00:43 9108 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2014-12-01 00:00:43 9108 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2014-12-01 00:00:43 9108 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2014-12-01 00:00:43 9108 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2014-12-01 00:00:43 9108 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2014-12-01 00:00:43 9108 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2014-12-01 00:00:43 9108 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2014-12-01 00:00:43 9108 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2014-12-01 00:00:43 9108 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2014-12-01 00:00:43 9108 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2014-12-01 00:00:43 9108 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2014-12-01 00:00:43 9108 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2014-12-01 00:00:43 9108 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2014-12-01 00:00:43 9108 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2014-12-01 00:00:43 9108 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2014-12-01 00:00:43 9108 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2014-12-01 00:00:43 9108 [Note] Shutting down plugin 'INNODB_METRICS'
2014-12-01 00:00:43 9108 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2014-12-01 00:00:43 9108 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2014-12-01 00:00:43 9108 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2014-12-01 00:00:43 9108 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2014-12-01 00:00:43 9108 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2014-12-01 00:00:43 9108 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2014-12-01 00:00:43 9108 [Note] Shutting down plugin 'INNODB_CMPMEM'
2014-12-01 00:00:43 9108 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2014-12-01 00:00:43 9108 [Note] Shutting down plugin 'INNODB_CMP'
2014-12-01 00:00:43 9108 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2014-12-01 00:00:43 9108 [Note] Shutting down plugin 'INNODB_LOCKS'
2014-12-01 00:00:43 9108 [Note] Shutting down plugin 'INNODB_TRX'
2014-12-01 00:00:43 9108 [Note] Shutting down plugin 'InnoDB'
2014-12-01 00:00:43 9108 [Note] InnoDB: FTS optimize thread exiting.
2014-12-01 00:00:43 9108 [Note] InnoDB: Starting shutdown...
2014-12-01 00:00:44 9108 [Note] InnoDB: Shutdown completed; log sequence number 8980100
2014-12-01 00:00:44 9108 [Note] Shutting down plugin 'BLACKHOLE'
2014-12-01 00:00:44 9108 [Note] Shutting down plugin 'ARCHIVE'
2014-12-01 00:00:44 9108 [Note] Shutting down plugin 'MRG_MYISAM'
2014-12-01 00:00:44 9108 [Note] Shutting down plugin 'MyISAM'
2014-12-01 00:00:44 9108 [Note] Shutting down plugin 'MEMORY'
2014-12-01 00:00:44 9108 [Note] Shutting down plugin 'CSV'
2014-12-01 00:00:44 9108 [Note] Shutting down plugin 'sha256_password'
2014-12-01 00:00:44 9108 [Note] Shutting down plugin 'mysql_old_password'
2014-12-01 00:00:44 9108 [Note] Shutting down plugin 'mysql_native_password'
2014-12-01 00:00:44 9108 [Note] Shutting down plugin 'binlog'
2014-12-01 00:00:44 9108 [Note] C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqld.exe: Shutdown complete
新手,下午正常操作学习修改root的密码,然后弄过最近不响应的goagent跟google chrome一下,重启后mysql就死活不动,
the the service mysql56 failed the most recent status change request with the message
the service mysql56 was not found in the Windows services
if problem persists please restart mysql notifier
用configure instance强行启动OK,但是,无法改变状态
删除两个ib_logfile的方法尝试过,未果,求解。
err日志
2014-11-30 16:47:14 1360 [Note] Giving 0 client threads a chance to die gracefully
2014-11-30 16:47:14 1360 [Note] Event Scheduler: Purging the queue. 0 events
2014-11-30 16:47:15 1360 [Note] Shutting down slave threads
2014-11-30 16:47:15 1360 [Note] Forcefully disconnecting 0 remaining clients
2014-11-30 16:47:17 1360 [Note] Binlog end
2014-11-30 16:47:32 1360 [Note] Shutting down plugin 'partition'
2014-11-30 16:47:32 1360 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2014-11-30 16:47:33 1360 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2014-11-30 16:47:33 1360 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2014-11-30 16:47:33 1360 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2014-11-30 16:47:33 1360 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2014-11-30 16:47:33 1360 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2014-11-30 16:47:33 1360 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2014-11-30 16:47:33 1360 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2014-11-30 16:47:33 1360 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2014-11-30 16:47:33 1360 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2014-11-30 16:47:33 1360 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2014-11-30 16:47:33 1360 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2014-11-30 16:47:33 1360 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2014-11-30 16:47:33 1360 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2014-11-30 16:47:33 1360 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2014-11-30 16:47:33 1360 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2014-11-30 16:47:33 1360 [Note] Shutting down plugin 'INNODB_METRICS'
2014-11-30 16:47:33 1360 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2014-11-30 16:47:33 1360 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2014-11-30 16:47:33 1360 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2014-11-30 16:47:33 1360 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2014-11-30 16:47:33 1360 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2014-11-30 16:47:33 1360 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2014-11-30 16:47:33 1360 [Note] Shutting down plugin 'INNODB_CMPMEM'
2014-11-30 16:47:33 1360 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2014-11-30 16:47:33 1360 [Note] Shutting down plugin 'INNODB_CMP'
2014-11-30 16:47:33 1360 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2014-11-30 16:47:33 1360 [Note] Shutting down plugin 'INNODB_LOCKS'
2014-11-30 16:47:33 1360 [Note] Shutting down plugin 'INNODB_TRX'
2014-11-30 16:47:33 1360 [Note] Shutting down plugin 'InnoDB'
2014-11-30 16:47:33 1360 [Note] InnoDB: FTS optimize thread exiting.
2014-11-30 16:47:34 1360 [Note] InnoDB: Starting shutdown...
2014-11-30 16:47:55 1360 [Note] InnoDB: Shutdown completed; log sequence number 8980090
2014-11-30 16:47:55 1360 [Note] Shutting down plugin 'BLACKHOLE'
2014-11-30 16:47:55 1360 [Note] Shutting down plugin 'ARCHIVE'
2014-11-30 16:47:55 1360 [Note] Shutting down plugin 'MRG_MYISAM'
2014-11-30 16:47:55 1360 [Note] Shutting down plugin 'MyISAM'
2014-11-30 16:47:56 1360 [Note] Shutting down plugin 'MEMORY'
2014-11-30 16:47:56 1360 [Note] Shutting down plugin 'CSV'
2014-11-30 16:47:56 1360 [Note] Shutting down plugin 'sha256_password'
2014-11-30 16:47:56 1360 [Note] Shutting down plugin 'mysql_old_password'
2014-11-30 16:47:56 1360 [Note] Shutting down plugin 'mysql_native_password'
2014-11-30 16:47:56 1360 [Note] Shutting down plugin 'binlog'
2014-11-30 16:47:56 1360 [Note] C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqld.exe: Shutdown complete2014-11-30 23:59:30 9108 [Note] Plugin 'FEDERATED' is disabled.
2014-11-30 23:59:31 2080 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator.
2014-11-30 23:59:31 9108 [Note] InnoDB: Using atomics to ref count buffer pool pages
2014-11-30 23:59:31 9108 [Note] InnoDB: The InnoDB memory heap is disabled
2014-11-30 23:59:31 9108 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2014-11-30 23:59:31 9108 [Note] InnoDB: Memory barrier is not used
2014-11-30 23:59:31 9108 [Note] InnoDB: Compressed tables use zlib 1.2.3
2014-11-30 23:59:31 9108 [Note] InnoDB: Not using CPU crc32 instructions
2014-11-30 23:59:31 9108 [Note] InnoDB: Initializing buffer pool, size = 91.0M
2014-11-30 23:59:31 9108 [Note] InnoDB: Completed initialization of buffer pool
2014-11-30 23:59:31 9108 [Note] InnoDB: Highest supported file format is Barracuda.
2014-12-01 00:00:29 9108 [Note] InnoDB: 128 rollback segment(s) are active.
2014-12-01 00:00:29 9108 [Note] InnoDB: Waiting for purge to start
2014-12-01 00:00:29 9108 [Note] InnoDB: 5.6.21 started; log sequence number 8980090
2014-12-01 00:00:30 9108 [Note] Server hostname (bind-address): '*'; port: 3306
2014-12-01 00:00:30 9108 [Note] IPv6 is available.
2014-12-01 00:00:30 9108 [Note] - '::' resolves to '::';
2014-12-01 00:00:30 9108 [Note] Server socket created on IP: '::'.
2014-12-01 00:00:35 9108 [Note] Event Scheduler: Loaded 0 events
2014-12-01 00:00:35 9108 [Note] C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqld.exe: ready for connections.
Version: '5.6.21-log' socket: '' port: 3306 MySQL Community Server (GPL)
2014-12-01 00:00:41 9108 [Note] C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqld.exe: Normal shutdown2014-12-01 00:00:41 9108 [Note] Giving 1 client threads a chance to die gracefully
2014-12-01 00:00:41 9108 [Note] Event Scheduler: Purging the queue. 0 events
2014-12-01 00:00:41 9108 [Note] Shutting down slave threads
2014-12-01 00:00:43 9108 [Note] Forcefully disconnecting 1 remaining clients
2014-12-01 00:00:43 9108 [Warning] C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqld.exe: Forcing close of thread 2 user: 'root'2014-12-01 00:00:43 9108 [Note] Binlog end
2014-12-01 00:00:43 9108 [Note] Shutting down plugin 'partition'
2014-12-01 00:00:43 9108 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2014-12-01 00:00:43 9108 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2014-12-01 00:00:43 9108 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2014-12-01 00:00:43 9108 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2014-12-01 00:00:43 9108 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2014-12-01 00:00:43 9108 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2014-12-01 00:00:43 9108 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2014-12-01 00:00:43 9108 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2014-12-01 00:00:43 9108 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2014-12-01 00:00:43 9108 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2014-12-01 00:00:43 9108 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2014-12-01 00:00:43 9108 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2014-12-01 00:00:43 9108 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2014-12-01 00:00:43 9108 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2014-12-01 00:00:43 9108 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2014-12-01 00:00:43 9108 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2014-12-01 00:00:43 9108 [Note] Shutting down plugin 'INNODB_METRICS'
2014-12-01 00:00:43 9108 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2014-12-01 00:00:43 9108 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2014-12-01 00:00:43 9108 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2014-12-01 00:00:43 9108 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2014-12-01 00:00:43 9108 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2014-12-01 00:00:43 9108 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2014-12-01 00:00:43 9108 [Note] Shutting down plugin 'INNODB_CMPMEM'
2014-12-01 00:00:43 9108 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2014-12-01 00:00:43 9108 [Note] Shutting down plugin 'INNODB_CMP'
2014-12-01 00:00:43 9108 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2014-12-01 00:00:43 9108 [Note] Shutting down plugin 'INNODB_LOCKS'
2014-12-01 00:00:43 9108 [Note] Shutting down plugin 'INNODB_TRX'
2014-12-01 00:00:43 9108 [Note] Shutting down plugin 'InnoDB'
2014-12-01 00:00:43 9108 [Note] InnoDB: FTS optimize thread exiting.
2014-12-01 00:00:43 9108 [Note] InnoDB: Starting shutdown...
2014-12-01 00:00:44 9108 [Note] InnoDB: Shutdown completed; log sequence number 8980100
2014-12-01 00:00:44 9108 [Note] Shutting down plugin 'BLACKHOLE'
2014-12-01 00:00:44 9108 [Note] Shutting down plugin 'ARCHIVE'
2014-12-01 00:00:44 9108 [Note] Shutting down plugin 'MRG_MYISAM'
2014-12-01 00:00:44 9108 [Note] Shutting down plugin 'MyISAM'
2014-12-01 00:00:44 9108 [Note] Shutting down plugin 'MEMORY'
2014-12-01 00:00:44 9108 [Note] Shutting down plugin 'CSV'
2014-12-01 00:00:44 9108 [Note] Shutting down plugin 'sha256_password'
2014-12-01 00:00:44 9108 [Note] Shutting down plugin 'mysql_old_password'
2014-12-01 00:00:44 9108 [Note] Shutting down plugin 'mysql_native_password'
2014-12-01 00:00:44 9108 [Note] Shutting down plugin 'binlog'
2014-12-01 00:00:44 9108 [Note] C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqld.exe: Shutdown complete
1.首先,任务栏右边mysql图标右键action->manage monitored items打开
2.(具体记得不太清怎么操作,好像是)打开services页面,然后删掉service,打开instances页面,删掉instance,最后在services页面按add重新加回去原来的sevice
然后我的就可以了
关于为什么我不求甚解不想了解其中原因,因为我的需求只是掌握基本语句操作,我不想,没有时间,没有精力弄深入,所以,各位DBA或者工程师GG们轻拍,我连业余的都不是。
把Windows里边对应的mysql服务加到楼主说的service中就可以了,不知道是什么原理
把Windows里边对应的mysql服务加到楼主说的service中就可以了,不知道是什么原理正好解决了这个问题
然后我直接用管理员权限打开了mysql notifier,修改状态时不会有权限提示
直接开一个命令行,执行<your mysql dir>\bin\mysqld.exe,应该就可以启动。
直接运行会占用一个命令行窗口,如果想后台运行,在用下面的命令
cd <your mysql dir>\bin
echo new ActiveXObject("WScript.Shell").run("mysqld.exe", 0 /* background */, false) > startup.js
cscript startup.js关闭mysqld用
mysqladmin -u root -p shutdown