Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

mySQL server in XAMP don't start

Tags:

mysql

I read all of articles about my problem but it still not working

How can I solve this issue?

Here is my log file:

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-06-02 14:23:12 c10 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-06-02 14:23:12 3088 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2016-06-02 14:23:12 3088 [Note] InnoDB: The InnoDB memory heap is disabled
2016-06-02 14:23:12 3088 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-06-02 14:23:12 3088 [Note] InnoDB: Memory barrier is not used
2016-06-02 14:23:12 3088 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-06-02 14:23:12 3088 [Note] InnoDB: Using generic crc32 instructions
2016-06-02 14:23:12 3088 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2016-06-02 14:23:12 3088 [Note] InnoDB: Completed initialization of buffer pool
2016-06-02 14:23:12 3088 [Note] InnoDB: Highest supported file format is Barracuda.
2016-06-02 14:23:12 3088 [Note] InnoDB: 128 rollback segment(s) are active.
2016-06-02 14:23:12 3088 [Note] InnoDB: Waiting for purge to start
2016-06-02 14:23:12 3088 [Note] InnoDB:  Percona XtraDB (http://www.percona.com) 5.6.28-76.1 started; log sequence number 1835037
2016-06-02 14:23:12 6804 [Note] InnoDB: Dumping buffer pool(s) not yet started
2016-06-02 14:23:12 3088 [Note] Plugin 'FEEDBACK' is disabled.
2016-06-02 14:23:12 3088 [Note] Server socket created on IP: '::'.
2016-06-02 14:23:12 3088 [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-06-02 14:23:12 3088 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2016-06-02 14:23:12 3088 [ERROR] Aborting

2016-06-02 14:48:22 4256 [Warning] option 'innodb-purge-threads': unsigned value 0 adjusted to 1
2016-06-02 14:48:22 10a0 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-06-02 14:48:22 4256 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2016-06-02 14:48:22 4256 [Note] InnoDB: The InnoDB memory heap is disabled
2016-06-02 14:48:22 4256 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-06-02 14:48:22 4256 [Note] InnoDB: Memory barrier is not used
2016-06-02 14:48:22 4256 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-06-02 14:48:22 4256 [Note] InnoDB: Using generic crc32 instructions
2016-06-02 14:48:22 4256 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2016-06-02 14:48:22 4256 [Note] InnoDB: Completed initialization of buffer pool
2016-06-02 14:48:22 4256 [Note] InnoDB: Highest supported file format is Barracuda.
2016-06-02 14:48:22 4256 [Note] InnoDB: 128 rollback segment(s) are active.
2016-06-02 14:48:22 4256 [Note] InnoDB:  Percona XtraDB (http://www.percona.com) 5.6.28-76.1 started; log sequence number 1835047
2016-06-02 14:48:22 4256 [Note] InnoDB: !!! innodb_force_recovery is set to 3 !!!
2016-06-02 14:48:22 4524 [Note] InnoDB: Dumping buffer pool(s) not yet started
2016-06-02 14:48:22 4256 [Note] Plugin 'FEEDBACK' is disabled.
2016-06-02 14:48:22 4256 [Note] Server socket created on IP: '::'.
2016-06-02 14:48:22 4256 [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-06-02 14:48:22 4256 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2016-06-02 14:48:22 4256 [ERROR] Aborting

2016-06-02 14:48:26 6448 [Warning] option 'innodb-purge-threads': unsigned value 0 adjusted to 1
2016-06-02 14:48:26 1930 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-06-02 14:48:26 6448 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2016-06-02 14:48:26 6448 [Note] InnoDB: The InnoDB memory heap is disabled
2016-06-02 14:48:26 6448 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-06-02 14:48:26 6448 [Note] InnoDB: Memory barrier is not used
2016-06-02 14:48:26 6448 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-06-02 14:48:26 6448 [Note] InnoDB: Using generic crc32 instructions
2016-06-02 14:48:26 6448 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2016-06-02 14:48:26 6448 [Note] InnoDB: Completed initialization of buffer pool
2016-06-02 14:48:26 6448 [Note] InnoDB: Highest supported file format is Barracuda.
2016-06-02 14:48:26 6448 [Note] InnoDB: 128 rollback segment(s) are active.
2016-06-02 14:48:26 6448 [Note] InnoDB:  Percona XtraDB (http://www.percona.com) 5.6.28-76.1 started; log sequence number 1835047
2016-06-02 14:48:26 6448 [Note] InnoDB: !!! innodb_force_recovery is set to 3 !!!
2016-06-02 14:48:26 5968 [Note] InnoDB: Dumping buffer pool(s) not yet started
2016-06-02 14:48:26 6448 [Note] Plugin 'FEEDBACK' is disabled.
2016-06-02 14:48:26 6448 [Note] Server socket created on IP: '::'.
2016-06-02 14:48:26 6448 [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-06-02 14:48:26 6448 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2016-06-02 14:48:26 6448 [ERROR] Aborting

2016-06-02 14:48:29 5836 [Warning] option 'innodb-purge-threads': unsigned value 0 adjusted to 1
2016-06-02 14:48:29 16cc 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-06-02 14:48:29 5836 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2016-06-02 14:48:29 5836 [Note] InnoDB: The InnoDB memory heap is disabled
2016-06-02 14:48:29 5836 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-06-02 14:48:29 5836 [Note] InnoDB: Memory barrier is not used
2016-06-02 14:48:29 5836 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-06-02 14:48:29 5836 [Note] InnoDB: Using generic crc32 instructions
2016-06-02 14:48:29 5836 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2016-06-02 14:48:29 5836 [Note] InnoDB: Completed initialization of buffer pool
2016-06-02 14:48:29 5836 [Note] InnoDB: Highest supported file format is Barracuda.
2016-06-02 14:48:29 5836 [Note] InnoDB: 128 rollback segment(s) are active.
2016-06-02 14:48:29 5836 [Note] InnoDB:  Percona XtraDB (http://www.percona.com) 5.6.28-76.1 started; log sequence number 1835047
2016-06-02 14:48:29 5836 [Note] InnoDB: !!! innodb_force_recovery is set to 3 !!!
2016-06-02 14:48:29 8112 [Note] InnoDB: Dumping buffer pool(s) not yet started
2016-06-02 14:48:29 5836 [Note] Plugin 'FEEDBACK' is disabled.
2016-06-02 14:48:29 5836 [Note] Server socket created on IP: '::'.
2016-06-02 14:48:29 5836 [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-06-02 14:48:29 5836 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2016-06-02 14:48:29 5836 [ERROR] Aborting

2016-06-02 14:49:50 7448 [Warning] option 'innodb-purge-threads': unsigned value 0 adjusted to 1
2016-06-02 14:49:50 1d18 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-06-02 14:49:50 7448 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2016-06-02 14:49:50 7448 [Note] InnoDB: The InnoDB memory heap is disabled
2016-06-02 14:49:50 7448 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-06-02 14:49:50 7448 [Note] InnoDB: Memory barrier is not used
2016-06-02 14:49:50 7448 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-06-02 14:49:50 7448 [Note] InnoDB: Using generic crc32 instructions
2016-06-02 14:49:50 7448 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2016-06-02 14:49:50 7448 [Note] InnoDB: Completed initialization of buffer pool
2016-06-02 14:49:50 7448 [Note] InnoDB: Highest supported file format is Barracuda.
2016-06-02 14:49:51 7448 [Note] InnoDB: 128 rollback segment(s) are active.
2016-06-02 14:49:51 7448 [Note] InnoDB:  Percona XtraDB (http://www.percona.com) 5.6.28-76.1 started; log sequence number 1835047
2016-06-02 14:49:51 7448 [Note] InnoDB: !!! innodb_force_recovery is set to 3 !!!
2016-06-02 14:49:51 3128 [Note] InnoDB: Dumping buffer pool(s) not yet started
2016-06-02 14:49:51 7448 [Note] Plugin 'FEEDBACK' is disabled.
2016-06-02 14:49:51 7448 [Note] Server socket created on IP: '::'.
2016-06-02 14:49:51 7448 [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-06-02 14:49:51 7448 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2016-06-02 14:49:51 7448 [ERROR] Aborting

2016-06-02 14:49:58 1512 [Warning] option 'innodb-purge-threads': unsigned value 0 adjusted to 1
2016-06-02 14:49:58 5e8 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-06-02 14:49:58 1512 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2016-06-02 14:49:58 1512 [Note] InnoDB: The InnoDB memory heap is disabled
2016-06-02 14:49:58 1512 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-06-02 14:49:58 1512 [Note] InnoDB: Memory barrier is not used
2016-06-02 14:49:58 1512 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-06-02 14:49:58 1512 [Note] InnoDB: Using generic crc32 instructions
2016-06-02 14:49:58 1512 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2016-06-02 14:49:58 1512 [Note] InnoDB: Completed initialization of buffer pool
2016-06-02 14:49:58 1512 [Note] InnoDB: Highest supported file format is Barracuda.
2016-06-02 14:49:58 1512 [Note] InnoDB: 128 rollback segment(s) are active.
2016-06-02 14:49:58 1512 [Note] InnoDB:  Percona XtraDB (http://www.percona.com) 5.6.28-76.1 started; log sequence number 1835047
2016-06-02 14:49:58 1512 [Note] InnoDB: !!! innodb_force_recovery is set to 3 !!!
2016-06-02 14:49:58 4724 [Note] InnoDB: Dumping buffer pool(s) not yet started
2016-06-02 14:49:58 1512 [Note] Plugin 'FEEDBACK' is disabled.
2016-06-02 14:49:58 1512 [Note] Server socket created on IP: '::'.
2016-06-02 14:49:58 1512 [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-06-02 14:49:58 1512 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2016-06-02 14:49:58 1512 [ERROR] Aborting

2016-06-02 14:50:01 5360 [Warning] option 'innodb-purge-threads': unsigned value 0 adjusted to 1
2016-06-02 14:50:01 14f0 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-06-02 14:50:01 5360 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2016-06-02 14:50:01 5360 [Note] InnoDB: The InnoDB memory heap is disabled
2016-06-02 14:50:01 5360 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-06-02 14:50:01 5360 [Note] InnoDB: Memory barrier is not used
2016-06-02 14:50:01 5360 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-06-02 14:50:01 5360 [Note] InnoDB: Using generic crc32 instructions
2016-06-02 14:50:01 5360 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2016-06-02 14:50:01 5360 [Note] InnoDB: Completed initialization of buffer pool
2016-06-02 14:50:01 5360 [Note] InnoDB: Highest supported file format is Barracuda.
2016-06-02 14:50:01 5360 [Note] InnoDB: 128 rollback segment(s) are active.
2016-06-02 14:50:01 5360 [Note] InnoDB:  Percona XtraDB (http://www.percona.com) 5.6.28-76.1 started; log sequence number 1835047
2016-06-02 14:50:01 5360 [Note] InnoDB: !!! innodb_force_recovery is set to 3 !!!
2016-06-02 14:50:01 1264 [Note] InnoDB: Dumping buffer pool(s) not yet started
2016-06-02 14:50:01 5360 [Note] Plugin 'FEEDBACK' is disabled.
2016-06-02 14:50:01 5360 [Note] Server socket created on IP: '::'.
2016-06-02 14:50:01 5360 [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-06-02 14:50:01 5360 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2016-06-02 14:50:01 5360 [ERROR] Aborting

2016-06-02 14:53:10 4928 [Warning] option 'innodb-purge-threads': unsigned value 0 adjusted to 1
2016-06-02 14:53:10 1340 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-06-02 14:53:10 4928 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2016-06-02 14:53:10 4928 [Note] InnoDB: The InnoDB memory heap is disabled
2016-06-02 14:53:10 4928 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-06-02 14:53:10 4928 [Note] InnoDB: Memory barrier is not used
2016-06-02 14:53:10 4928 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-06-02 14:53:10 4928 [Note] InnoDB: Using generic crc32 instructions
2016-06-02 14:53:10 4928 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2016-06-02 14:53:10 4928 [Note] InnoDB: Completed initialization of buffer pool
2016-06-02 14:53:10 4928 [Note] InnoDB: Highest supported file format is Barracuda.
2016-06-02 14:53:10 4928 [Note] InnoDB: 128 rollback segment(s) are active.
2016-06-02 14:53:10 4928 [Note] InnoDB:  Percona XtraDB (http://www.percona.com) 5.6.28-76.1 started; log sequence number 1835047
2016-06-02 14:53:10 4928 [Note] InnoDB: !!! innodb_force_recovery is set to 3 !!!
2016-06-02 14:53:10 5072 [Note] InnoDB: Dumping buffer pool(s) not yet started
2016-06-02 14:53:10 4928 [Note] Plugin 'FEEDBACK' is disabled.
2016-06-02 14:53:10 4928 [Note] Server socket created on IP: '::'.
2016-06-02 14:53:10 4928 [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-06-02 14:53:10 4928 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2016-06-02 14:53:10 4928 [ERROR] Aborting

2016-06-02 14:58:04 5244 [Warning] option 'innodb-purge-threads': unsigned value 0 adjusted to 1
2016-06-02 14:58:04 147c 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-06-02 14:58:04 147c InnoDB: Warning: Setting innodb_use_sys_malloc to FALSE is DEPRECATED. This option may be removed in future releases, together with the InnoDB's internal memory allocator.
2016-06-02 14:58:04 5244 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2016-06-02 14:58:04 5244 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-06-02 14:58:04 5244 [Note] InnoDB: Memory barrier is not used
2016-06-02 14:58:04 5244 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-06-02 14:58:04 5244 [Note] InnoDB: Using generic crc32 instructions
2016-06-02 14:58:04 5244 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2016-06-02 14:58:04 5244 [Note] InnoDB: Completed initialization of buffer pool
2016-06-02 14:58:04 5244 [Note] InnoDB: Highest supported file format is Barracuda.
2016-06-02 14:58:05 5244 [Note] InnoDB: 128 rollback segment(s) are active.
2016-06-02 14:58:05 5244 [Note] InnoDB:  Percona XtraDB (http://www.percona.com) 5.6.28-76.1 started; log sequence number 1835047
2016-06-02 14:58:05 5244 [Note] InnoDB: !!! innodb_force_recovery is set to 3 !!!
2016-06-02 14:58:05 332 [Note] InnoDB: Dumping buffer pool(s) not yet started
2016-06-02 14:58:05 5244 [Note] Plugin 'FEEDBACK' is disabled.
2016-06-02 14:58:05 5244 [Note] Server socket created on IP: '::'.
2016-06-02 14:58:05 5244 [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-06-02 14:58:05 5244 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2016-06-02 14:58:05 5244 [ERROR] Aborting

2016-06-02 14:59:17 4716 [Warning] option 'innodb-purge-threads': unsigned value 0 adjusted to 1
2016-06-02 14:59:17 126c 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-06-02 14:59:17 126c InnoDB: Warning: Setting innodb_use_sys_malloc to FALSE is DEPRECATED. This option may be removed in future releases, together with the InnoDB's internal memory allocator.
2016-06-02 14:59:17 4716 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2016-06-02 14:59:17 4716 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-06-02 14:59:17 4716 [Note] InnoDB: Memory barrier is not used
2016-06-02 14:59:17 4716 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-06-02 14:59:17 4716 [Note] InnoDB: Using generic crc32 instructions
2016-06-02 14:59:17 4716 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2016-06-02 14:59:17 4716 [Note] InnoDB: Completed initialization of buffer pool
2016-06-02 14:59:17 4716 [Note] InnoDB: Highest supported file format is Barracuda.
2016-06-02 14:59:17 4716 [Note] InnoDB: 128 rollback segment(s) are active.
2016-06-02 14:59:17 4716 [Note] InnoDB:  Percona XtraDB (http://www.percona.com) 5.6.28-76.1 started; log sequence number 1835047
2016-06-02 14:59:17 4716 [Note] InnoDB: !!! innodb_force_recovery is set to 3 !!!
2016-06-02 14:59:17 4716 [Note] Plugin 'FEEDBACK' is disabled.
2016-06-02 14:59:17 4652 [Note] InnoDB: Dumping buffer pool(s) not yet started
2016-06-02 14:59:17 4716 [Note] Server socket created on IP: '::'.
2016-06-02 14:59:17 4716 [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-06-02 14:59:17 4716 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2016-06-02 14:59:17 4716 [ERROR] Aborting

2016-06-02 14:59:30 4916 [Warning] option 'innodb-purge-threads': unsigned value 0 adjusted to 1
2016-06-02 14:59:30 1334 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-06-02 14:59:30 1334 InnoDB: Warning: Setting innodb_use_sys_malloc to FALSE is DEPRECATED. This option may be removed in future releases, together with the InnoDB's internal memory allocator.
2016-06-02 14:59:30 4916 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2016-06-02 14:59:30 4916 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-06-02 14:59:30 4916 [Note] InnoDB: Memory barrier is not used
2016-06-02 14:59:30 4916 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-06-02 14:59:30 4916 [Note] InnoDB: Using generic crc32 instructions
2016-06-02 14:59:30 4916 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2016-06-02 14:59:30 4916 [Note] InnoDB: Completed initialization of buffer pool
2016-06-02 14:59:30 4916 [Note] InnoDB: Highest supported file format is Barracuda.
2016-06-02 14:59:30 4916 [Note] InnoDB: 128 rollback segment(s) are active.
2016-06-02 14:59:30 4916 [Note] InnoDB:  Percona XtraDB (http://www.percona.com) 5.6.28-76.1 started; log sequence number 1835047
2016-06-02 14:59:30 4916 [Note] InnoDB: !!! innodb_force_recovery is set to 3 !!!
2016-06-02 14:59:30 4404 [Note] InnoDB: Dumping buffer pool(s) not yet started
2016-06-02 14:59:30 4916 [Note] Plugin 'FEEDBACK' is disabled.
2016-06-02 14:59:30 4916 [Note] Server socket created on IP: '::'.
2016-06-02 14:59:30 4916 [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-06-02 14:59:30 4916 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2016-06-02 14:59:30 4916 [ERROR] Aborting

Thanks.

like image 747
alibar Avatar asked Jun 02 '16 10:06

alibar


People also ask

Why MySQL is not starting in XAMPP on Mac?

a. On your macOS, you might have multiple instances of MySQL servers running. This can be caused by other applications (for e.g. SQL Workbench) running their own instances of MySQL. To fix this issue, you need to stop the other instance of the MySQL server.

Can't connect to MySQL server on localhost XAMPP?

normally means that there is no MySQL server running on the system or that you are using an incorrect Unix socket file name or TCP/IP port number when trying to connect to the server. You should also check that the TCP/IP port you are using has not been blocked by a firewall or port blocking service.


2 Answers

I ran into this same issue when I had MySQL Workbench and XAMPP downloaded. Since they're both trying to access Port 3306 an error occurs. I'm running this on Windows 10, I'm not sure if this fix also works on Mac & Linux. I changed the port of XAMPP to 3307 and left the MySQL untouched. Here's how I did that: *Take into consideration that the line numbers may be different on your system.

  1. In the XAMPP GUI click on "Config" -> "Service and Port Settings" -> "MySQL" tab -> Change Main Port to 3307 -> Save -> Save

  2. Locate the installation file for XAMPP -> open MySQL folder -> open bin folder -> right click on "my.ini" and edit it

  3. Change the following lines: (Line 20) Port = 3306 -> Port = 3307 (Line 28) Port = 3306 -> Port = 3307

Save the file, restart your computer, and the server should run.

like image 124
Ryan Russell Avatar answered Nov 25 '22 18:11

Ryan Russell


I just ran into this problem myself after I installed XAMPP for APACHE. I decided to use it for a localhost of MySQL too. Here's what I did to get it to work.

In windows, open command prompt, type: netstat -ano|find "3306"

The PID LISTENING was 4608. Opened Task Manager, went to Details tab. Found the PID, it was a mysql.exe from another application. Right click the application and select End Task.

Restart XAMPP.

I don't recommend changing the Port Number just because 3306 is a Standard assigned port to MySQL as well as 33060, 33061, and 33062. In a few cases, I have seen Port 22 assigned. There is a protocol set up for this and when to use which one.

like image 28
Brendan Walker Avatar answered Nov 25 '22 20:11

Brendan Walker