Apache Friends Support Forum

dogdomain wrote:MySQL set for port 3306. How do I change the port or how do I find out what app is using port 3306 already?????

I had a preinstalled version of MySQL and just managed to run xampp as admin after changing port number using control panel.But now when I started MySQL on xampp control panel,the below error occurred:
19:39:56 [mysql] Error: MySQL shutdown unexpectedly.
19:39:56 [mysql] This may be due to a blocked port, missing dependencies,
19:39:56 [mysql] improper privileges, a crash, or a shutdown by another method.
19:39:56 [mysql] Press the Logs button to view error logs and check
19:39:56 [mysql] the Windows Event Viewer for more clues
19:39:56 [mysql] If you need more help, copy and post this
19:39:56 [mysql] entire log window on the forums

Below are the contents of the log window:
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

2017-10-04 22:22:08 df0 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.
2017-10-04 22:22:08 3568 [Note] InnoDB: innodb_empty_free_list_algorithm has been changed to legacy because of small buffer pool size. In order to use backoff, increase buffer pool at least up to 20MB.

2017-10-04 22:22:08 3568 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2017-10-04 22:22:08 3568 [Note] InnoDB: The InnoDB memory heap is disabled
2017-10-04 22:22:08 3568 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2017-10-04 22:22:08 3568 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier
2017-10-04 22:22:08 3568 [Note] InnoDB: Compressed tables use zlib 1.2.3
2017-10-04 22:22:08 3568 [Note] InnoDB: Using generic crc32 instructions
2017-10-04 22:22:08 3568 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2017-10-04 22:22:08 3568 [Note] InnoDB: Completed initialization of buffer pool
2017-10-04 22:22:08 3568 [Note] InnoDB: Highest supported file format is Barracuda.
2017-10-04 22:22:10 3568 [Note] InnoDB: 128 rollback segment(s) are active.
2017-10-04 22:22:10 3568 [Note] InnoDB: Waiting for purge to start
2017-10-04 22:22:10 3568 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.36-82.1 started; log sequence number 1835037
2017-10-04 22:22:10 1800 [Note] InnoDB: Dumping buffer pool(s) not yet started
2017-10-04 22:22:10 3568 [Note] Plugin 'FEEDBACK' is disabled.
2017-10-04 22:22:10 3568 [Note] Server socket created on IP: '::'.
2017-10-04 22:22:10 3568 [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.


2017-10-04 22:22:10 3568 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2017-10-04 22:22:10 3568 [ERROR] Aborting

2017-10-18 19:38:01 8ac 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.
2017-10-18 19:38:01 2220 [Note] InnoDB: innodb_empty_free_list_algorithm has been changed to legacy because of small buffer pool size. In order to use backoff, increase buffer pool at least up to 20MB.

2017-10-18 19:38:01 2220 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2017-10-18 19:38:01 2220 [Note] InnoDB: The InnoDB memory heap is disabled
2017-10-18 19:38:01 2220 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2017-10-18 19:38:01 2220 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier
2017-10-18 19:38:01 2220 [Note] InnoDB: Compressed tables use zlib 1.2.3
2017-10-18 19:38:01 2220 [Note] InnoDB: Using generic crc32 instructions
2017-10-18 19:38:01 2220 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2017-10-18 19:38:01 2220 [Note] InnoDB: Completed initialization of buffer pool
2017-10-18 19:38:02 2220 [Note] InnoDB: Highest supported file format is Barracuda.
2017-10-18 19:38:06 2220 [Note] InnoDB: 128 rollback segment(s) are active.
2017-10-18 19:38:06 2220 [Note] InnoDB: Waiting for purge to start
2017-10-18 19:38:07 2220 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.36-82.1 started; log sequence number 1835047
2017-10-18 19:38:07 2620 [Note] InnoDB: Dumping buffer pool(s) not yet started
2017-10-18 19:38:07 2220 [Note] Plugin 'FEEDBACK' is disabled.
2017-10-18 19:38:07 2220 [Note] Server socket created on IP: '::'.
2017-10-18 19:38:07 2220 [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.


2017-10-18 19:38:07 2220 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2017-10-18 19:38:07 2220 [ERROR] Aborting

2017-10-18 19:39:52 d78 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.
2017-10-18 19:39:52 3448 [Note] InnoDB: innodb_empty_free_list_algorithm has been changed to legacy because of small buffer pool size. In order to use backoff, increase buffer pool at least up to 20MB.

2017-10-18 19:39:52 3448 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2017-10-18 19:39:52 3448 [Note] InnoDB: The InnoDB memory heap is disabled
2017-10-18 19:39:52 3448 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2017-10-18 19:39:52 3448 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier
2017-10-18 19:39:52 3448 [Note] InnoDB: Compressed tables use zlib 1.2.3
2017-10-18 19:39:52 3448 [Note] InnoDB: Using generic crc32 instructions
2017-10-18 19:39:52 3448 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2017-10-18 19:39:52 3448 [Note] InnoDB: Completed initialization of buffer pool
2017-10-18 19:39:52 3448 [Note] InnoDB: Highest supported file format is Barracuda.
2017-10-18 19:39:53 3448 [Note] InnoDB: 128 rollback segment(s) are active.
2017-10-18 19:39:53 3448 [Note] InnoDB: Waiting for purge to start
2017-10-18 19:39:53 3448 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.36-82.1 started; log sequence number 1835057
2017-10-18 19:39:53 3980 [Note] InnoDB: Dumping buffer pool(s) not yet started
2017-10-18 19:39:53 3448 [Note] Plugin 'FEEDBACK' is disabled.
2017-10-18 19:39:53 3448 [Note] Server socket created on IP: '::'.
2017-10-18 19:39:53 3448 [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.


2017-10-18 19:39:53 3448 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2017-10-18 19:39:53 3448 [ERROR] Aborting

Can someone help me with this?

Please read carefully the leading text of the control panel service and port settings form.

The service and port settings form in the control panel has important instructions at the top that should be read attentively.