xampp下mysql不能启动，错误日志如下

Question

2014-08-23 16:02:45 9692 [Note] Plugin 'FEDERATED' is disabled.
2014-08-23 16:02:45 257c 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-08-23 16:02:45 9692 [Note] InnoDB: Using atomics to ref count buffer pool pages
2014-08-23 16:02:45 9692 [Note] InnoDB: The InnoDB memory heap is disabled
2014-08-23 16:02:45 9692 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2014-08-23 16:02:45 9692 [Note] InnoDB: Compressed tables use zlib 1.2.3
2014-08-23 16:02:45 9692 [Note] InnoDB: Not using CPU crc32 instructions
2014-08-23 16:02:45 9692 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2014-08-23 16:02:45 9692 [Note] InnoDB: Completed initialization of buffer pool
2014-08-23 16:02:45 9692 [Note] InnoDB: Highest supported file format is Barracuda.
2014-08-23 16:02:45 9692 [Note] InnoDB: 128 rollback segment(s) are active.
2014-08-23 16:02:46 9692 [Note] InnoDB: Waiting for purge to start
2014-08-23 16:02:46 9692 [Note] InnoDB: 5.6.16 started; log sequence number 1600664
2014-08-23 16:02:46 9692 [Note] Server hostname (bind-address): '*'; port: 3306
2014-08-23 16:02:46 9692 [Note] IPv6 is available.
2014-08-23 16:02:46 9692 [Note]   - '::' resolves to '::';
2014-08-23 16:02:46 9692 [Note] Server socket created on IP: '::'.
2014-08-23 16:02:46 9692 [Warning] InnoDB: Cannot open table mysql/slave_master_info from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.
2014-08-23 16:02:46 9692 [Warning] Info table is not ready to be used. Table 'mysql.slave_master_info' cannot be opened.
2014-08-23 16:02:46 9692 [Warning] InnoDB: Cannot open table mysql/slave_worker_info from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.
2014-08-23 16:02:46 9692 [Warning] InnoDB: Cannot open table mysql/slave_relay_log_info from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.
2014-08-23 16:02:46 9692 [Warning] Info table is not ready to be used. Table 'mysql.slave_relay_log_info' cannot be opened.
2014-08-23 16:02:46 9692 [ERROR] Event Scheduler: Failed to open table mysql.event
2014-08-23 16:02:46 9692 [ERROR] Event Scheduler: Error while loading from disk.
2014-08-23 16:02:46 9692 [Note] Event Scheduler: Purging the queue. 0 events
2014-08-23 16:02:46 9692 [ERROR] Aborting

2014-08-23 16:02:46 9692 [Note] Binlog end
2014-08-23 16:02:46 9692 [Note] Shutting down plugin 'partition'
2014-08-23 16:02:46 9692 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2014-08-23 16:02:46 9692 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2014-08-23 16:02:46 9692 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2014-08-23 16:02:46 9692 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2014-08-23 16:02:46 9692 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2014-08-23 16:02:46 9692 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2014-08-23 16:02:46 9692 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2014-08-23 16:02:46 9692 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2014-08-23 16:02:46 9692 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2014-08-23 16:02:46 9692 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2014-08-23 16:02:46 9692 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2014-08-23 16:02:46 9692 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2014-08-23 16:02:46 9692 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2014-08-23 16:02:46 9692 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2014-08-23 16:02:46 9692 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2014-08-23 16:02:46 9692 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2014-08-23 16:02:46 9692 [Note] Shutting down plugin 'INNODB_METRICS'
2014-08-23 16:02:46 9692 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2014-08-23 16:02:46 9692 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2014-08-23 16:02:46 9692 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2014-08-23 16:02:46 9692 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2014-08-23 16:02:46 9692 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2014-08-23 16:02:46 9692 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2014-08-23 16:02:46 9692 [Note] Shutting down plugin 'INNODB_CMPMEM'
2014-08-23 16:02:46 9692 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2014-08-23 16:02:46 9692 [Note] Shutting down plugin 'INNODB_CMP'
2014-08-23 16:02:46 9692 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2014-08-23 16:02:46 9692 [Note] Shutting down plugin 'INNODB_LOCKS'
2014-08-23 16:02:46 9692 [Note] Shutting down plugin 'INNODB_TRX'
2014-08-23 16:02:46 9692 [Note] Shutting down plugin 'InnoDB'
2014-08-23 16:02:46 9692 [Note] InnoDB: FTS optimize thread exiting.
2014-08-23 16:02:46 9692 [Note] InnoDB: Starting shutdown...
2014-08-23 16:02:48 9692 [Note] InnoDB: Shutdown completed; log sequence number 1600674
2014-08-23 16:02:48 9692 [Note] Shutting down plugin 'BLACKHOLE'
2014-08-23 16:02:48 9692 [Note] Shutting down plugin 'ARCHIVE'
2014-08-23 16:02:48 9692 [Note] Shutting down plugin 'MRG_MYISAM'
2014-08-23 16:02:48 9692 [Note] Shutting down plugin 'MyISAM'
2014-08-23 16:02:48 9692 [Note] Shutting down plugin 'MEMORY'
2014-08-23 16:02:48 9692 [Note] Shutting down plugin 'CSV'
2014-08-23 16:02:48 9692 [Note] Shutting down plugin 'sha256_password'
2014-08-23 16:02:48 9692 [Note] Shutting down plugin 'mysql_old_password'
2014-08-23 16:02:48 9692 [Note] Shutting down plugin 'mysql_native_password'
2014-08-23 16:02:48 9692 [Note] Shutting down plugin 'binlog'
2014-08-23 16:02:48 9692 [Note] h:\xampp\xampp\mysql\bin\mysqld.exe: Shutdown complete

mysql running3秒后自动停止，apache端口设为8081,443和3306端口都未被占用。apache能够正常使用，mysql不能启动

Answer 1

I have encountered this before when installing xmapp on win7. The reason is that a mysql was installed on the machine before, which conflicted with the mysql of xampp. If you want to start xampp's mysql, you must turn off the previously installed mysql service in the service.

Answer 2

Two mysql databases conflict