重启后我到服务里面看mysql服务没启动,我分别把安装时候能运行的日志和重启后失败的错误日志发出来131011 10:11:30 [Note] Plugin 'FEDERATED' is disabled. 131011 10:11:30 InnoDB: The InnoDB memory heap is disabled 131011 10:11:30 InnoDB: Mutexes and rw_locks use Windows interlocked functions 131011 10:11:30 InnoDB: Compressed tables use zlib 1.2.3 131011 10:11:30 InnoDB: Initializing buffer pool, size = 46.0M 131011 10:11:30 InnoDB: Completed initialization of buffer pool InnoDB: The first specified data file .\ibdata1 did not exist: InnoDB: a new database to be created! 131011 10:11:30 InnoDB: Setting file .\ibdata1 size to 10 MB InnoDB: Database physically writes the file full: wait... 131011 10:11:31 InnoDB: Log file .\ib_logfile0 did not exist: new to be created InnoDB: Setting log file .\ib_logfile0 size to 23 MB InnoDB: Database physically writes the file full: wait... 131011 10:11:32 InnoDB: Log file .\ib_logfile1 did not exist: new to be created InnoDB: Setting log file .\ib_logfile1 size to 23 MB InnoDB: Database physically writes the file full: wait... InnoDB: Doublewrite buffer not found: creating new InnoDB: Doublewrite buffer created InnoDB: 127 rollback segment(s) active. InnoDB: Creating foreign key constraint system tables InnoDB: Foreign key constraint system tables created 131011 10:11:33 InnoDB: Waiting for the background threads to start 131011 10:11:34 InnoDB: 1.1.8 started; log sequence number 0 131011 10:11:34 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306 131011 10:11:35 [Note] - '0.0.0.0' resolves to '0.0.0.0'; 131011 10:11:35 [Note] Server socket created on IP: '0.0.0.0'. 131011 10:11:35 [Note] Event Scheduler: Loaded 0 events 131011 10:11:35 [Note] C:\Program Files\MySQL\MySQL Server 5.5\bin\mysqld: ready for connections. Version: '5.5.27' socket: '' port: 3306 MySQL Community Server (GPL) 下面是重启后不能连上的错误日志131011 10:11:30 [Note] Plugin 'FEDERATED' is disabled. 131011 10:11:30 InnoDB: The InnoDB memory heap is disabled 131011 10:11:30 InnoDB: Mutexes and rw_locks use Windows interlocked functions 131011 10:11:30 InnoDB: Compressed tables use zlib 1.2.3 131011 10:11:30 InnoDB: Initializing buffer pool, size = 46.0M 131011 10:11:30 InnoDB: Completed initialization of buffer pool InnoDB: The first specified data file .\ibdata1 did not exist: InnoDB: a new database to be created! 131011 10:11:30 InnoDB: Setting file .\ibdata1 size to 10 MB InnoDB: Database physically writes the file full: wait... 131011 10:11:31 InnoDB: Log file .\ib_logfile0 did not exist: new to be created InnoDB: Setting log file .\ib_logfile0 size to 23 MB InnoDB: Database physically writes the file full: wait... 131011 10:11:32 InnoDB: Log file .\ib_logfile1 did not exist: new to be created InnoDB: Setting log file .\ib_logfile1 size to 23 MB InnoDB: Database physically writes the file full: wait... InnoDB: Doublewrite buffer not found: creating new InnoDB: Doublewrite buffer created InnoDB: 127 rollback segment(s) active. InnoDB: Creating foreign key constraint system tables InnoDB: Foreign key constraint system tables created 131011 10:11:33 InnoDB: Waiting for the background threads to start 131011 10:11:34 InnoDB: 1.1.8 started; log sequence number 0 131011 10:11:34 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306 131011 10:11:35 [Note] - '0.0.0.0' resolves to '0.0.0.0'; 131011 10:11:35 [Note] Server socket created on IP: '0.0.0.0'. 131011 10:11:35 [Note] Event Scheduler: Loaded 0 events 131011 10:11:35 [Note] C:\Program Files\MySQL\MySQL Server 5.5\bin\mysqld: ready for connections. Version: '5.5.27' socket: '' port: 3306 MySQL Community Server (GPL) 131011 10:13:17 [Note] C:\Program Files\MySQL\MySQL Server 5.5\bin\mysqld: Normal shutdown131011 10:13:17 [Note] Event Scheduler: Purging the queue. 0 events 131011 10:13:19 [Warning] C:\Program Files\MySQL\MySQL Server 5.5\bin\mysqld: Forcing close of thread 2 user: 'root'131011 10:13:19 InnoDB: Starting shutdown... 131011 10:13:20 InnoDB: Shutdown completed; log sequence number 1595675 131011 10:13:20 [Note] C:\Program Files\MySQL\MySQL Server 5.5\bin\mysqld: Shutdown complete131011 10:13:53 [Note] Plugin 'FEDERATED' is disabled. 131011 10:13:53 InnoDB: The InnoDB memory heap is disabled 131011 10:13:53 InnoDB: Mutexes and rw_locks use Windows interlocked functions 131011 10:13:53 InnoDB: Compressed tables use zlib 1.2.3 131011 10:13:53 InnoDB: Initializing buffer pool, size = 46.0M 131011 10:13:53 InnoDB: Completed initialization of buffer pool 131011 10:13:53 InnoDB: highest supported file format is Barracuda. 131011 10:13:53 InnoDB: Operating system error number 87 in a file operation. InnoDB: Some operating system error numbers are described at InnoDB: http://dev.mysql.com/doc/refman/5.5/en/operating-system-error-codes.html InnoDB: File name .\ib_logfile0 InnoDB: File operation call: 'aio read'. InnoDB: Cannot continue operation.
把错误日志贴出来
131011 10:11:30 InnoDB: The InnoDB memory heap is disabled
131011 10:11:30 InnoDB: Mutexes and rw_locks use Windows interlocked functions
131011 10:11:30 InnoDB: Compressed tables use zlib 1.2.3
131011 10:11:30 InnoDB: Initializing buffer pool, size = 46.0M
131011 10:11:30 InnoDB: Completed initialization of buffer pool
InnoDB: The first specified data file .\ibdata1 did not exist:
InnoDB: a new database to be created!
131011 10:11:30 InnoDB: Setting file .\ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
131011 10:11:31 InnoDB: Log file .\ib_logfile0 did not exist: new to be created
InnoDB: Setting log file .\ib_logfile0 size to 23 MB
InnoDB: Database physically writes the file full: wait...
131011 10:11:32 InnoDB: Log file .\ib_logfile1 did not exist: new to be created
InnoDB: Setting log file .\ib_logfile1 size to 23 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: 127 rollback segment(s) active.
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
131011 10:11:33 InnoDB: Waiting for the background threads to start
131011 10:11:34 InnoDB: 1.1.8 started; log sequence number 0
131011 10:11:34 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
131011 10:11:35 [Note] - '0.0.0.0' resolves to '0.0.0.0';
131011 10:11:35 [Note] Server socket created on IP: '0.0.0.0'.
131011 10:11:35 [Note] Event Scheduler: Loaded 0 events
131011 10:11:35 [Note] C:\Program Files\MySQL\MySQL Server 5.5\bin\mysqld: ready for connections.
Version: '5.5.27' socket: '' port: 3306 MySQL Community Server (GPL)
下面是重启后不能连上的错误日志131011 10:11:30 [Note] Plugin 'FEDERATED' is disabled.
131011 10:11:30 InnoDB: The InnoDB memory heap is disabled
131011 10:11:30 InnoDB: Mutexes and rw_locks use Windows interlocked functions
131011 10:11:30 InnoDB: Compressed tables use zlib 1.2.3
131011 10:11:30 InnoDB: Initializing buffer pool, size = 46.0M
131011 10:11:30 InnoDB: Completed initialization of buffer pool
InnoDB: The first specified data file .\ibdata1 did not exist:
InnoDB: a new database to be created!
131011 10:11:30 InnoDB: Setting file .\ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
131011 10:11:31 InnoDB: Log file .\ib_logfile0 did not exist: new to be created
InnoDB: Setting log file .\ib_logfile0 size to 23 MB
InnoDB: Database physically writes the file full: wait...
131011 10:11:32 InnoDB: Log file .\ib_logfile1 did not exist: new to be created
InnoDB: Setting log file .\ib_logfile1 size to 23 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: 127 rollback segment(s) active.
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
131011 10:11:33 InnoDB: Waiting for the background threads to start
131011 10:11:34 InnoDB: 1.1.8 started; log sequence number 0
131011 10:11:34 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
131011 10:11:35 [Note] - '0.0.0.0' resolves to '0.0.0.0';
131011 10:11:35 [Note] Server socket created on IP: '0.0.0.0'.
131011 10:11:35 [Note] Event Scheduler: Loaded 0 events
131011 10:11:35 [Note] C:\Program Files\MySQL\MySQL Server 5.5\bin\mysqld: ready for connections.
Version: '5.5.27' socket: '' port: 3306 MySQL Community Server (GPL)
131011 10:13:17 [Note] C:\Program Files\MySQL\MySQL Server 5.5\bin\mysqld: Normal shutdown131011 10:13:17 [Note] Event Scheduler: Purging the queue. 0 events
131011 10:13:19 [Warning] C:\Program Files\MySQL\MySQL Server 5.5\bin\mysqld: Forcing close of thread 2 user: 'root'131011 10:13:19 InnoDB: Starting shutdown...
131011 10:13:20 InnoDB: Shutdown completed; log sequence number 1595675
131011 10:13:20 [Note] C:\Program Files\MySQL\MySQL Server 5.5\bin\mysqld: Shutdown complete131011 10:13:53 [Note] Plugin 'FEDERATED' is disabled.
131011 10:13:53 InnoDB: The InnoDB memory heap is disabled
131011 10:13:53 InnoDB: Mutexes and rw_locks use Windows interlocked functions
131011 10:13:53 InnoDB: Compressed tables use zlib 1.2.3
131011 10:13:53 InnoDB: Initializing buffer pool, size = 46.0M
131011 10:13:53 InnoDB: Completed initialization of buffer pool
131011 10:13:53 InnoDB: highest supported file format is Barracuda.
131011 10:13:53 InnoDB: Operating system error number 87 in a file operation.
InnoDB: Some operating system error numbers are described at
InnoDB: http://dev.mysql.com/doc/refman/5.5/en/operating-system-error-codes.html
InnoDB: File name .\ib_logfile0
InnoDB: File operation call: 'aio read'.
InnoDB: Cannot continue operation.