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?
