by DarthSidus » 28. January 2016 22:27
MySQL is not starting in xampp windows 10. It returns the following error:
Error: MySQL shutdown unexpectedly.
9:08:35 PM [mysql] This may be due to a blocked port, missing dependencies,
9:08:35 PM [mysql] improper privileges, a crash, or a shutdown by another method.
9:08:35 PM [mysql] Press the Logs button to view error logs and check
9:08:35 PM [mysql] the Windows Event Viewer for more clues
9:08:35 PM [mysql] If you need more help, copy and post this
9:08:35 PM [mysql] entire log window on the forums
This is the .ini file:
# Example MySQL config file for small systems.
#
# This is for a system with little memory (<= 64M) where MySQL is only used
# from time to time and it's important that the mysqld daemon
# doesn't use much resources.
#
# You can copy this file to
# C:/xampp/mysql/bin/my.cnf to set global options,
# mysql-data-dir/my.cnf to set server-specific options (in this
# installation this directory is C:/xampp/mysql/data) or
# ~/.my.cnf to set user-specific options.
#
# In this file, you can use all long options that a program supports.
# If you want to know which options a program supports, run the program
# with the "--help" option.
# The following options will be passed to all MySQL clients
[client]
# password = your_password
port = 3306
socket = "C:/xampp/mysql/mysql.sock"
# Here follows entries for some specific programs
# The MySQL server
[mysqld]
port= 3306
socket = "C:/xampp/mysql/mysql.sock"
basedir = "C:/xampp/mysql"
tmpdir = "C:/xampp/tmp"
datadir = "C:/xampp/mysql/data"
pid_file = "mysql.pid"
# enable-named-pipe
key_buffer = 16M
max_allowed_packet = 1M
sort_buffer_size = 512K
net_buffer_length = 8K
read_buffer_size = 256K
read_rnd_buffer_size = 512K
myisam_sort_buffer_size = 8M
log_error = "mysql_error.log"
# Change here for bind listening
# bind-address="127.0.0.1"
# bind-address = ::1 # for ipv6
# Where do all the plugins live
plugin_dir = "C:/xampp/mysql/lib/plugin/"
# Don't listen on a TCP/IP port at all. This can be a security enhancement,
# if all processes that need to connect to mysqld run on the same host.
# All interaction with mysqld must be made via Unix sockets or named pipes.
# Note that using this option without enabling named pipes on Windows
# (via the "enable-named-pipe" option) will render mysqld useless!
#
# commented in by lampp security
#skip-networking
#skip-federated
# Replication Master Server (default)
# binary logging is required for replication
# log-bin deactivated by default since XAMPP 1.4.11
#log-bin=mysql-bin
# required unique id between 1 and 2^32 - 1
# defaults to 1 if master-host is not set
# but will not function as a master if omitted
server-id = 1
# Replication Slave (comment out master section to use this)
#
# To configure this host as a replication slave, you can choose between
# two methods :
#
# 1) Use the CHANGE MASTER TO command (fully described in our manual) -
# the syntax is:
#
# CHANGE MASTER TO MASTER_HOST=<host>, MASTER_PORT=<port>,
# MASTER_USER=<user>, MASTER_PASSWORD=<password> ;
#
# where you replace <host>, <user>, <password> by quoted strings and
# <port> by the master's port number (3306 by default).
#
# Example:
#
# CHANGE MASTER TO MASTER_HOST='125.564.12.1', MASTER_PORT=3306,
# MASTER_USER='joe', MASTER_PASSWORD='secret';
#
# OR
And this is the error log:
2015-11-10 15:26:56 10fc 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.
2015-11-10 15:26:56 4348 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2015-11-10 15:26:56 4348 [Note] InnoDB: The InnoDB memory heap is disabled
2015-11-10 15:26:56 4348 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2015-11-10 15:26:56 4348 [Note] InnoDB: Memory barrier is not used
2015-11-10 15:26:56 4348 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-11-10 15:26:56 4348 [Note] InnoDB: Not using CPU crc32 instructions
2015-11-10 15:26:56 4348 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2015-11-10 15:26:56 4348 [Note] InnoDB: Completed initialization of buffer pool
2015-11-10 15:26:56 4348 [Note] InnoDB: Highest supported file format is Barracuda.
2015-11-10 15:26:57 4348 [Note] InnoDB: 128 rollback segment(s) are active.
2015-11-10 15:26:57 4348 [Note] InnoDB: Waiting for purge to start
2015-11-10 15:26:57 4348 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.26-74.0 started; log sequence number 1835027
2015-11-10 15:26:57 6140 [Note] InnoDB: Dumping buffer pool(s) not yet started
2015-11-10 15:26:57 4348 [Note] Plugin 'FEEDBACK' is disabled.
2015-11-10 15:26:57 4348 [Note] Server socket created on IP: '::'.
2015-11-10 15:26:57 4348 [Note] Event Scheduler: Loaded 0 events
2015-11-10 15:26:57 4348 [Note] C:\xampp\mysql\bin\mysqld.exe: ready for connections.
Version: '10.1.8-MariaDB' socket: '' port: 3306 mariadb.org binary distribution
2015-11-10 15:27:11 5152 [Note] C:\xampp\mysql\bin\mysqld.exe: Normal shutdown
2015-11-10 15:27:11 5152 [Note] Event Scheduler: Purging the queue. 0 events
2015-11-10 15:27:11 5732 [Note] InnoDB: FTS optimize thread exiting.
2015-11-10 15:27:11 5152 [Note] InnoDB: Starting shutdown...
2015-11-10 15:27:13 5152 [Note] InnoDB: Shutdown completed; log sequence number 1835037
2015-11-10 15:27:13 5152 [Note] C:\xampp\mysql\bin\mysqld.exe: Shutdown complete
2016-01-23 18:28:59 3a38 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.
2016-01-23 18:28:59 14904 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2016-01-23 18:28:59 14904 [Note] InnoDB: The InnoDB memory heap is disabled
2016-01-23 18:28:59 14904 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-01-23 18:28:59 14904 [Note] InnoDB: Memory barrier is not used
2016-01-23 18:28:59 14904 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-01-23 18:28:59 14904 [Note] InnoDB: Not using CPU crc32 instructions
2016-01-23 18:28:59 14904 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2016-01-23 18:28:59 14904 [Note] InnoDB: Completed initialization of buffer pool
2016-01-23 18:28:59 14904 [Note] InnoDB: Highest supported file format is Barracuda.
2016-01-23 18:28:59 14904 [Note] InnoDB: 128 rollback segment(s) are active.
2016-01-23 18:28:59 14904 [Note] InnoDB: Waiting for purge to start
2016-01-23 18:28:59 14904 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.26-74.0 started; log sequence number 1835037
2016-01-23 18:28:59 14780 [Note] InnoDB: Dumping buffer pool(s) not yet started
2016-01-23 18:28:59 14904 [Note] Plugin 'FEEDBACK' is disabled.
2016-01-23 18:28:59 14904 [Note] Server socket created on IP: '::'.
2016-01-23 18:28:59 14904 [ERROR] Can't start server: Bind on TCP/IP port. Got error: 10048: Only one usage of each socket address (protocol/network address/port) is normally permitted.
2016-01-23 18:28:59 14904 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2016-01-23 18:28:59 14904 [ERROR] Aborting
2016-01-23 18:29:22 2754 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.
2016-01-23 18:29:22 10068 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2016-01-23 18:29:22 10068 [Note] InnoDB: The InnoDB memory heap is disabled
2016-01-23 18:29:22 10068 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-01-23 18:29:22 10068 [Note] InnoDB: Memory barrier is not used
2016-01-23 18:29:22 10068 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-01-23 18:29:22 10068 [Note] InnoDB: Not using CPU crc32 instructions
2016-01-23 18:29:22 10068 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2016-01-23 18:29:22 10068 [Note] InnoDB: Completed initialization of buffer pool
2016-01-23 18:29:22 10068 [Note] InnoDB: Highest supported file format is Barracuda.
2016-01-23 18:29:22 10068 [Note] InnoDB: 128 rollback segment(s) are active.
2016-01-23 18:29:22 10068 [Note] InnoDB: Waiting for purge to start
2016-01-23 18:29:22 10068 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.26-74.0 started; log sequence number 1835047
2016-01-23 18:29:22 2508 [Note] InnoDB: Dumping buffer pool(s) not yet started
2016-01-23 18:29:22 10068 [Note] Plugin 'FEEDBACK' is disabled.
2016-01-23 18:29:22 10068 [Note] Server socket created on IP: '::'.
2016-01-23 18:29:22 10068 [ERROR] Can't start server: Bind on TCP/IP port. Got error: 10048: Only one usage of each socket address (protocol/network address/port) is normally permitted.
2016-01-23 18:29:22 10068 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2016-01-23 18:29:22 10068 [ERROR] Aborting
2016-01-23 18:31:34 21a8 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.
2016-01-23 18:31:34 8616 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2016-01-23 18:31:34 8616 [Note] InnoDB: The InnoDB memory heap is disabled
2016-01-23 18:31:34 8616 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-01-23 18:31:34 8616 [Note] InnoDB: Memory barrier is not used
2016-01-23 18:31:34 8616 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-01-23 18:31:34 8616 [Note] InnoDB: Not using CPU crc32 instructions
2016-01-23 18:31:34 8616 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2016-01-23 18:31:34 8616 [Note] InnoDB: Completed initialization of buffer pool
2016-01-23 18:31:34 8616 [Note] InnoDB: Highest supported file format is Barracuda.
2016-01-23 18:31:34 8616 [Note] InnoDB: 128 rollback segment(s) are active.
2016-01-23 18:31:34 8616 [Note] InnoDB: Waiting for purge to start
2016-01-23 18:31:34 8616 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.26-74.0 started; log sequence number 1835057
2016-01-23 18:31:34 14716 [Note] InnoDB: Dumping buffer pool(s) not yet started
2016-01-23 18:31:34 8616 [Note] Plugin 'FEEDBACK' is disabled.
2016-01-23 18:31:34 8616 [Note] Server socket created on IP: '::'.
2016-01-23 18:31:34 8616 [ERROR] Can't start server: Bind on TCP/IP port. Got error: 10048: Only one usage of each socket address (protocol/network address/port) is normally permitted.
2016-01-23 18:31:34 8616 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2016-01-23 18:31:34 8616 [ERROR] Aborting
2016-01-23 18:33:42 3084 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.
2016-01-23 18:33:42 12420 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2016-01-23 18:33:42 12420 [Note] InnoDB: The InnoDB memory heap is disabled
2016-01-23 18:33:42 12420 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-01-23 18:33:42 12420 [Note] InnoDB: Memory barrier is not used
2016-01-23 18:33:42 12420 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-01-23 18:33:42 12420 [Note] InnoDB: Not using CPU crc32 instructions
2016-01-23 18:33:42 12420 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2016-01-23 18:33:42 12420 [Note] InnoDB: Completed initialization of buffer pool
2016-01-23 18:33:42 12420 [Note] InnoDB: Highest supported file format is Barracuda.
2016-01-23 18:33:42 12420 [Note] InnoDB: 128 rollback segment(s) are active.
2016-01-23 18:33:42 12420 [Note] InnoDB: Waiting for purge to start
2016-01-23 18:33:42 12420 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.26-74.0 started; log sequence number 1835067
2016-01-23 18:33:42 13720 [Note] InnoDB: Dumping buffer pool(s) not yet started
2016-01-23 18:33:42 12420 [Note] Plugin 'FEEDBACK' is disabled.
2016-01-23 18:33:42 12420 [Note] Server socket created on IP: '::'.
2016-01-23 18:33:42 12420 [Note] c:\xampp\mysql\bin\mysqld.exe: ready for connections.
Version: '10.1.9-MariaDB' socket: '' port: 3306 mariadb.org binary distribution
2016-01-23 20:51:06 43b4 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.
2016-01-23 20:51:06 17332 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2016-01-23 20:51:06 17332 [Note] InnoDB: The InnoDB memory heap is disabled
2016-01-23 20:51:06 17332 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-01-23 20:51:06 17332 [Note] InnoDB: Memory barrier is not used
2016-01-23 20:51:06 17332 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-01-23 20:51:06 17332 [Note] InnoDB: Not using CPU crc32 instructions
2016-01-23 20:51:06 17332 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2016-01-23 20:51:06 17332 [Note] InnoDB: Completed initialization of buffer pool
2016-01-23 20:51:06 17332 [ERROR] InnoDB: C:\xampp\mysql\data\ibdata1 can't be opened in read-write mode
2016-01-23 20:51:06 17332 [ERROR] InnoDB: The system tablespace must be writable!
2016-01-23 20:51:06 17332 [ERROR] Plugin 'InnoDB' init function returned error.
2016-01-23 20:51:06 17332 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2016-01-23 20:51:06 17332 [Note] Plugin 'FEEDBACK' is disabled.
2016-01-23 20:51:06 17332 [ERROR] Unknown/unsupported storage engine: InnoDB
2016-01-23 20:51:06 17332 [ERROR] Aborting
2016-01-23 21:09:11 2956 [Note] c:\xampp\mysql\bin\mysqld.exe: Normal shutdown
2016-01-23 21:09:11 2956 [Note] Event Scheduler: Purging the queue. 0 events
2016-01-23 21:09:11 13624 [Note] InnoDB: FTS optimize thread exiting.
2016-01-23 21:09:11 2956 [Note] InnoDB: Starting shutdown...
2016-01-23 21:09:12 2956 [Note] InnoDB: Shutdown completed; log sequence number 1835077
2016-01-23 21:09:12 2956 [Note] c:\xampp\mysql\bin\mysqld.exe: Shutdown complete
2016-01-23 21:09:18 3b8 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.
2016-01-23 21:09:18 952 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2016-01-23 21:09:18 952 [Note] InnoDB: The InnoDB memory heap is disabled
2016-01-23 21:09:18 952 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-01-23 21:09:18 952 [Note] InnoDB: Memory barrier is not used
2016-01-23 21:09:18 952 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-01-23 21:09:18 952 [Note] InnoDB: Not using CPU crc32 instructions
2016-01-23 21:09:18 952 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2016-01-23 21:09:18 952 [Note] InnoDB: Completed initialization of buffer pool
2016-01-23 21:09:18 952 [Note] InnoDB: Highest supported file format is Barracuda.
2016-01-23 21:09:18 952 [Note] InnoDB: 128 rollback segment(s) are active.
2016-01-23 21:09:18 952 [Note] InnoDB: Waiting for purge to start
2016-01-23 21:09:18 952 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.26-74.0 started; log sequence number 1835077
2016-01-23 21:09:18 5696 [Note] InnoDB: Dumping buffer pool(s) not yet started
2016-01-23 21:09:18 952 [Note] Plugin 'FEEDBACK' is disabled.
2016-01-23 21:09:18 952 [Note] Server socket created on IP: '::'.
2016-01-23 21:09:18 952 [Note] c:\xampp\mysql\bin\mysqld.exe: ready for connections.
Version: '10.1.9-MariaDB' socket: '' port: 3306 mariadb.org binary distribution
2016-01-23 21:09:44 5732 [Note] c:\xampp\mysql\bin\mysqld.exe: Normal shutdown
2016-01-23 21:09:44 5732 [Note] Event Scheduler: Purging the queue. 0 events
2016-01-23 21:09:44 4848 [Note] InnoDB: FTS optimize thread exiting.
2016-01-23 21:09:44 5732 [Note] InnoDB: Starting shutdown...
2016-01-23 21:09:45 5732 [Note] InnoDB: Shutdown completed; log sequence number 1835087
2016-01-23 21:09:45 5732 [Note] c:\xampp\mysql\bin\mysqld.exe: Shutdown complete
2016-01-23 21:10:02 2f94 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.
2016-01-23 21:10:02 12180 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2016-01-23 21:10:02 12180 [Note] InnoDB: The InnoDB memory heap is disabled
2016-01-23 21:10:02 12180 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-01-23 21:10:02 12180 [Note] InnoDB: Memory barrier is not used
2016-01-23 21:10:02 12180 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-01-23 21:10:02 12180 [Note] InnoDB: Not using CPU crc32 instructions
2016-01-23 21:10:02 12180 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2016-01-23 21:10:02 12180 [Note] InnoDB: Completed initialization of buffer pool
2016-01-23 21:10:02 12180 [Note] InnoDB: Highest supported file format is Barracuda.
2016-01-23 21:10:03 12180 [Note] InnoDB: 128 rollback segment(s) are active.
2016-01-23 21:10:03 12180 [Note] InnoDB: Waiting for purge to start
2016-01-23 21:10:03 12180 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.26-74.0 started; log sequence number 1835087
2016-01-23 21:10:03 14048 [Note] InnoDB: Dumping buffer pool(s) not yet started
2016-01-23 21:10:03 12180 [Note] Plugin 'FEEDBACK' is disabled.
2016-01-23 21:10:03 12180 [Note] Server socket created on IP: '::'.
2016-01-23 21:10:03 12180 [Note] mysql\bin\mysqld.exe: ready for connections.
Version: '10.1.9-MariaDB' socket: '' port: 3306 mariadb.org binary distribution
2016-01-23 22:07:20 1228 [Note] mysql\bin\mysqld.exe: Normal shutdown
2016-01-23 22:07:20 1228 [Note] Event Scheduler: Purging the queue. 0 events
2016-01-23 22:07:20 13692 [Note] InnoDB: FTS optimize thread exiting.
2016-01-23 22:07:20 1228 [Note] InnoDB: Starting shutdown...
2016-01-23 22:07:22 1228 [Note] InnoDB: Shutdown completed; log sequence number 1835097
2016-01-23 22:07:22 1228 [Note] mysql\bin\mysqld.exe: Shutdown complete
2016-01-23 22:07:28 22e4 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.
2016-01-23 22:07:28 8932 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2016-01-23 22:07:28 8932 [Note] InnoDB: The InnoDB memory heap is disabled
2016-01-23 22:07:28 8932 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-01-23 22:07:28 8932 [Note] InnoDB: Memory barrier is not used
2016-01-23 22:07:28 8932 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-01-23 22:07:28 8932 [Note] InnoDB: Not using CPU crc32 instructions
2016-01-23 22:07:28 8932 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2016-01-23 22:07:28 8932 [Note] InnoDB: Completed initialization of buffer pool
2016-01-23 22:07:28 8932 [Note] InnoDB: Highest supported file format is Barracuda.
2016-01-23 22:07:28 8932 [Note] InnoDB: 128 rollback segment(s) are active.
2016-01-23 22:07:28 8932 [Note] InnoDB: Waiting for purge to start
2016-01-23 22:07:28 8932 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.26-74.0 started; log sequence number 1835097
2016-01-23 22:07:28 5300 [Note] InnoDB: Dumping buffer pool(s) not yet started
2016-01-23 22:07:28 8932 [Note] Plugin 'FEEDBACK' is disabled.
2016-01-23 22:07:28 8932 [Note] Server socket created on IP: '::'.
2016-01-23 22:07:28 8932 [Note] mysql\bin\mysqld.exe: ready for connections.
Version: '10.1.9-MariaDB' socket: '' port: 3306 mariadb.org binary distribution
2016-01-24 11:57:18 30a0 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.
2016-01-24 11:57:18 12448 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2016-01-24 11:57:18 12448 [Note] InnoDB: The InnoDB memory heap is disabled
2016-01-24 11:57:18 12448 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-01-24 11:57:18 12448 [Note] InnoDB: Memory barrier is not used
2016-01-24 11:57:18 12448 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-01-24 11:57:18 12448 [Note] InnoDB: Not using CPU crc32 instructions
2016-01-24 11:57:18 12448 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2016-01-24 11:57:18 12448 [Note] InnoDB: Completed initialization of buffer pool
2016-01-24 11:57:18 12448 [Note] InnoDB: Highest supported file format is Barracuda.
2016-01-24 11:57:18 12448 [Note] InnoDB: The log sequence numbers 1835097 and 1835097 in ibdata files do not match the log sequence number 1835107 in the ib_logfiles!
2016-01-24 11:57:18 12448 [Note] InnoDB: Database was not shutdown normally!
2016-01-24 11:57:18 12448 [Note] InnoDB: Starting crash recovery.
2016-01-24 11:57:18 12448 [Note] InnoDB: Reading tablespace information from the .ibd files...
2016-01-24 11:57:18 12448 [Note] InnoDB: Restoring possible half-written data pages
2016-01-24 11:57:18 12448 [Note] InnoDB: from the doublewrite buffer...
2016-01-24 11:57:18 12448 [Note] InnoDB: 128 rollback segment(s) are active.
2016-01-24 11:57:18 12448 [Note] InnoDB: Waiting for purge to start
2016-01-24 11:57:18 12448 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.26-74.0 started; log sequence number 1835107
2016-01-24 11:57:18 13248 [Note] InnoDB: Dumping buffer pool(s) not yet started
2016-01-24 11:57:18 12448 [Note] Plugin 'FEEDBACK' is disabled.
2016-01-24 11:57:18 12448 [Note] Server socket created on IP: '::'.
2016-01-24 11:57:18 12448 [Note] c:\xampp\mysql\bin\mysqld.exe: ready for connections.
Version: '10.1.9-MariaDB' socket: '' port: 3306 mariadb.org binary distribution
2016-01-24 12:22:34 16204 [Note] c:\xampp\mysql\bin\mysqld.exe: Normal shutdown
2016-01-24 12:22:34 16204 [Note] Event Scheduler: Purging the queue. 0 events
2016-01-24 12:22:34 15736 [Note] InnoDB: FTS optimize thread exiting.
2016-01-24 12:22:34 16204 [Note] InnoDB: Starting shutdown...
2016-01-24 12:22:36 16204 [Note] InnoDB: Shutdown completed; log sequence number 1835117
2016-01-24 12:22:36 16204 [Note] c:\xampp\mysql\bin\mysqld.exe: Shutdown complete
2016-01-24 16:14:18 1e5c 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.
2016-01-24 16:14:18 7772 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2016-01-24 16:14:18 7772 [Note] InnoDB: The InnoDB memory heap is disabled
2016-01-24 16:14:18 7772 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-01-24 16:14:18 7772 [Note] InnoDB: Memory barrier is not used
2016-01-24 16:14:18 7772 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-01-24 16:14:18 7772 [Note] InnoDB: Not using CPU crc32 instructions
2016-01-24 16:14:18 7772 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2016-01-24 16:14:18 7772 [Note] InnoDB: Completed initialization of buffer pool
2016-01-24 16:14:18 7772 [Note] InnoDB: Highest supported file format is Barracuda.
2016-01-24 16:14:18 7772 [Note] InnoDB: 128 rollback segment(s) are active.
2016-01-24 16:14:18 7772 [Note] InnoDB: Waiting for purge to start
2016-01-24 16:14:18 7772 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.26-74.0 started; log sequence number 1835117
2016-01-24 16:14:18 10152 [Note] InnoDB: Dumping buffer pool(s) not yet started
2016-01-24 16:14:18 7772 [Note] Plugin 'FEEDBACK' is disabled.
2016-01-24 16:14:18 7772 [Note] Server socket created on IP: '::'.
2016-01-24 16:14:18 7772 [Note] c:\xampp\mysql\bin\mysqld.exe: ready for connections.
Version: '10.1.9-MariaDB' socket: '' port: 3306 mariadb.org binary distribution
2016-01-24 16:22:31 46fc 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.
2016-01-24 16:22:31 18172 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2016-01-24 16:22:31 18172 [Note] InnoDB: The InnoDB memory heap is disabled
2016-01-24 16:22:31 18172 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-01-24 16:22:31 18172 [Note] InnoDB: Memory barrier is not used
2016-01-24 16:22:31 18172 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-01-24 16:22:31 18172 [Note] InnoDB: Not using CPU crc32 instructions
2016-01-24 16:22:31 18172 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2016-01-24 16:22:31 18172 [Note] InnoDB: Completed initialization of buffer pool
2016-01-24 16:22:31 18172 [ERROR] InnoDB: C:\xampp\mysql\data\ibdata1 can't be opened in read-write mode
2016-01-24 16:22:31 18172 [ERROR] InnoDB: The system tablespace must be writable!
2016-01-24 16:22:31 18172 [ERROR] Plugin 'InnoDB' init function returned error.
2016-01-24 16:22:31 18172 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2016-01-24 16:22:31 18172 [Note] Plugin 'FEEDBACK' is disabled.
2016-01-24 16:22:31 18172 [ERROR] Unknown/unsupported storage engine: InnoDB
2016-01-24 16:22:31 18172 [ERROR] Aborting
2016-01-24 16:22:55 3ed4 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.
2016-01-24 16:22:55 16084 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2016-01-24 16:22:55 16084 [Note] InnoDB: The InnoDB memory heap is disabled
2016-01-24 16:22:55 16084 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-01-24 16:22:55 16084 [Note] InnoDB: Memory barrier is not used
2016-01-24 16:22:55 16084 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-01-24 16:22:55 16084 [Note] InnoDB: Not using CPU crc32 instructions
2016-01-24 16:22:55 16084 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2016-01-24 16:22:55 16084 [Note] InnoDB: Completed initialization of buffer pool
2016-01-24 16:22:55 16084 [ERROR] InnoDB: C:\xampp\mysql\data\ibdata1 can't be opened in read-write mode
2016-01-24 16:22:55 16084 [ERROR] InnoDB: The system tablespace must be writable!
2016-01-24 16:22:55 16084 [ERROR] Plugin 'InnoDB' init function returned error.
2016-01-24 16:22:55 16084 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2016-01-24 16:22:55 16084 [Note] Plugin 'FEEDBACK' is disabled.
2016-01-24 16:22:55 16084 [ERROR] Unknown/unsupported storage engine: InnoDB
2016-01-24 16:22:55 16084 [ERROR] Aborting
2016-01-24 16:23:21 253c 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.
2016-01-24 16:23:21 9532 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2016-01-24 16:23:21 9532 [Note] InnoDB: The InnoDB memory heap is disabled
2016-01-24 16:23:21 9532 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-01-24 16:23:21 9532 [Note] InnoDB: Memory barrier is not used
2016-01-24 16:23:21 9532 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-01-24 16:23:21 9532 [Note] InnoDB: Not using CPU crc32 instructions
2016-01-24 16:23:21 9532 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2016-01-24 16:23:21 9532 [Note] InnoDB: Completed initialization of buffer pool
2016-01-24 16:23:21 9532 [ERROR] InnoDB: C:\xampp\mysql\data\ibdata1 can't be opened in read-write mode
2016-01-24 16:23:21 9532 [ERROR] InnoDB: The system tablespace must be writable!
2016-01-24 16:23:21 9532 [ERROR] Plugin 'InnoDB' init function returned error.
2016-01-24 16:23:21 9532 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2016-01-24 16:23:21 9532 [Note] Plugin 'FEEDBACK' is disabled.
2016-01-24 16:23:21 9532 [ERROR] Unknown/unsupported storage engine: InnoDB
2016-01-24 16:23:21 9532 [ERROR] Aborting
2016-01-24 16:27:34 3f54 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.
2016-01-24 16:27:34 16212 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2016-01-24 16:27:34 16212 [Note] InnoDB: The InnoDB memory heap is disabled
2016-01-24 16:27:34 16212 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-01-24 16:27:34 16212 [Note] InnoDB: Memory barrier is not used
2016-01-24 16:27:34 16212 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-01-24 16:27:34 16212 [Note] InnoDB: Not using CPU crc32 instructions
2016-01-24 16:27:34 16212 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2016-01-24 16:27:34 16212 [Note] InnoDB: Completed initialization of buffer pool
2016-01-24 16:27:34 16212 [ERROR] InnoDB: C:\xampp\mysql\data\ibdata1 can't be opened in read-write mode
2016-01-24 16:27:34 16212 [ERROR] InnoDB: The system tablespace must be writable!
2016-01-24 16:27:34 16212 [ERROR] Plugin 'InnoDB' init function returned error.
2016-01-24 16:27:34 16212 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2016-01-24 16:27:34 16212 [Note] Plugin 'FEEDBACK' is disabled.
2016-01-24 16:27:34 16212 [ERROR] Unknown/unsupported storage engine: InnoDB
2016-01-24 16:27:34 16212 [ERROR] Aborting
2016-01-24 16:27:44 11e8 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.
2016-01-24 16:27:44 4584 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2016-01-24 16:27:44 4584 [Note] InnoDB: The InnoDB memory heap is disabled
2016-01-24 16:27:44 4584 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-01-24 16:27:44 4584 [Note] InnoDB: Memory barrier is not used
2016-01-24 16:27:44 4584 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-01-24 16:27:44 4584 [Note] InnoDB: Not using CPU crc32 instructions
2016-01-24 16:27:44 4584 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2016-01-24 16:27:44 4584 [Note] InnoDB: Completed initialization of buffer pool
2016-01-24 16:27:44 4584 [ERROR] InnoDB: C:\xampp\mysql\data\ibdata1 can't be opened in read-write mode
2016-01-24 16:27:44 4584 [ERROR] InnoDB: The system tablespace must be writable!
2016-01-24 16:27:44 4584 [ERROR] Plugin 'InnoDB' init function returned error.
2016-01-24 16:27:44 4584 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2016-01-24 16:27:44 4584 [Note] Plugin 'FEEDBACK' is disabled.
2016-01-24 16:27:44 4584 [ERROR] Unknown/unsupported storage engine: InnoDB
2016-01-24 16:27:44 4584 [ERROR] Aborting
2016-01-28 20:58:48 1638 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.
2016-01-28 20:58:48 5688 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2016-01-28 20:58:48 5688 [Note] InnoDB: The InnoDB memory heap is disabled
2016-01-28 20:58:48 5688 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-01-28 20:58:48 5688 [Note] InnoDB: Memory barrier is not used
2016-01-28 20:58:48 5688 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-01-28 20:58:48 5688 [Note] InnoDB: Not using CPU crc32 instructions
2016-01-28 20:58:48 5688 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2016-01-28 20:58:48 5688 [Note] InnoDB: Completed initialization of buffer pool
2016-01-28 20:58:48 5688 [Note] InnoDB: Highest supported file format is Barracuda.
2016-01-28 20:58:48 5688 [Note] InnoDB: The log sequence numbers 1835117 and 1835117 in ibdata files do not match the log sequence number 1835127 in the ib_logfiles!
2016-01-28 20:58:48 5688 [Note] InnoDB: Database was not shutdown normally!
2016-01-28 20:58:48 5688 [Note] InnoDB: Starting crash recovery.
2016-01-28 20:58:48 5688 [Note] InnoDB: Reading tablespace information from the .ibd files...
2016-01-28 20:58:48 5688 [Note] InnoDB: Restoring possible half-written data pages
2016-01-28 20:58:48 5688 [Note] InnoDB: from the doublewrite buffer...
2016-01-28 20:58:48 5688 [Note] InnoDB: 128 rollback segment(s) are active.
2016-01-28 20:58:48 5688 [Note] InnoDB: Waiting for purge to start
2016-01-28 20:58:48 5688 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.26-74.0 started; log sequence number 1835127
2016-01-28 20:58:48 17916 [Note] InnoDB: Dumping buffer pool(s) not yet started
2016-01-28 20:58:48 5688 [Note] Plugin 'FEEDBACK' is disabled.
2016-01-28 20:58:48 5688 [Note] Server socket created on IP: '::'.
2016-01-28 20:58:48 5688 [ERROR] Can't start server: Bind on TCP/IP port. Got error: 10048: Only one usage of each socket address (protocol/network address/port) is normally permitted.
2016-01-28 20:58:48 5688 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2016-01-28 20:58:48 5688 [ERROR] Aborting
2016-01-28 21:02:35 4810 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.
2016-01-28 21:02:35 18448 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2016-01-28 21:02:35 18448 [Note] InnoDB: The InnoDB memory heap is disabled
2016-01-28 21:02:35 18448 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-01-28 21:02:35 18448 [Note] InnoDB: Memory barrier is not used
2016-01-28 21:02:35 18448 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-01-28 21:02:35 18448 [Note] InnoDB: Not using CPU crc32 instructions
2016-01-28 21:02:35 18448 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2016-01-28 21:02:35 18448 [Note] InnoDB: Completed initialization of buffer pool
2016-01-28 21:02:35 18448 [Note] InnoDB: Highest supported file format is Barracuda.
2016-01-28 21:02:35 18448 [Note] InnoDB: 128 rollback segment(s) are active.
2016-01-28 21:02:35 18448 [Note] InnoDB: Waiting for purge to start
2016-01-28 21:02:35 18448 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.26-74.0 started; log sequence number 1835137
2016-01-28 21:02:35 12236 [Note] InnoDB: Dumping buffer pool(s) not yet started
2016-01-28 21:02:35 18448 [Note] Plugin 'FEEDBACK' is disabled.
2016-01-28 21:02:35 18448 [Note] Server socket created on IP: '::'.
2016-01-28 21:02:35 18448 [ERROR] Can't start server: Bind on TCP/IP port. Got error: 10048: Only one usage of each socket address (protocol/network address/port) is normally permitted.
2016-01-28 21:02:35 18448 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2016-01-28 21:02:35 18448 [ERROR] Aborting
2016-01-28 21:08:32 4ac0 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.
2016-01-28 21:08:32 19136 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2016-01-28 21:08:32 19136 [Note] InnoDB: The InnoDB memory heap is disabled
2016-01-28 21:08:32 19136 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-01-28 21:08:32 19136 [Note] InnoDB: Memory barrier is not used
2016-01-28 21:08:32 19136 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-01-28 21:08:32 19136 [Note] InnoDB: Not using CPU crc32 instructions
2016-01-28 21:08:32 19136 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2016-01-28 21:08:32 19136 [Note] InnoDB: Completed initialization of buffer pool
2016-01-28 21:08:32 19136 [Note] InnoDB: Highest supported file format is Barracuda.
2016-01-28 21:08:32 19136 [Note] InnoDB: 128 rollback segment(s) are active.
2016-01-28 21:08:32 19136 [Note] InnoDB: Waiting for purge to start
2016-01-28 21:08:32 19136 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.26-74.0 started; log sequence number 1835147
2016-01-28 21:08:32 12372 [Note] InnoDB: Dumping buffer pool(s) not yet started
2016-01-28 21:08:32 19136 [Note] Plugin 'FEEDBACK' is disabled.
2016-01-28 21:08:32 19136 [Note] Server socket created on IP: '::'.
2016-01-28 21:08:32 19136 [ERROR] Can't start server: Bind on TCP/IP port. Got error: 10048: Only one usage of each socket address (protocol/network address/port) is normally permitted.
2016-01-28 21:08:32 19136 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2016-01-28 21:08:32 19136 [ERROR] Aborting
I would appreciate any help in getting MySQL running Thanks