Problem detected! Port 3306 in use. MySQL WILL NOT start.

[rkontominas]

I just ran a fresh install of the application for a college course, but am having issues with my machine running the program. Please see the log from the Control Panel below and then the actual log for MySQL below that.

Problem detected! Port 3306 in use by "Unable to open process"! MySQL WILL NOT start without the configured ports free!You need to uninstall/disable/reconfigure the blocking application or reconfigure MySQL and the Control Panel to listen on a different port

15:56:22 [main] Initializing Control Panel
15:56:22 [main] Windows Version: Enterprise 64-bit
15:56:22 [main] XAMPP Version: 8.2.12
15:56:22 [main] Control Panel Version: 3.3.0 [ Compiled: Apr 6th 2021 ]
15:56:22 [main] You are not running with administrator rights! This will work for
15:56:22 [main] most application stuff but whenever you do something with services
15:56:22 [main] there will be a security dialogue or things will break! So think
15:56:22 [main] about running this application with administrator rights!
15:56:22 [main] XAMPP Installation Directory: "c:\xampp\"
15:56:22 [main] Checking for prerequisites
15:56:23 [main] All prerequisites found
15:56:23 [main] Initializing Modules
15:56:23 [mysql] Problem detected!
15:56:23 [mysql] Port 3306 in use by "Unable to open process"!
15:56:23 [mysql] MySQL WILL NOT start without the configured ports free!
15:56:23 [mysql] You need to uninstall/disable/reconfigure the blocking application
15:56:23 [mysql] or reconfigure MySQL and the Control Panel to listen on a different port
15:56:23 [main] Starting Check-Timer
15:56:23 [main] Control Panel Ready
15:58:02 [mysql] Problem detected!
15:58:02 [mysql] Port 3306 in use by "Unable to open process"!
15:58:02 [mysql] MySQL WILL NOT start without the configured ports free!
15:58:02 [mysql] You need to uninstall/disable/reconfigure the blocking application
15:58:02 [mysql] or reconfigure MySQL and the Control Panel to listen on a different port
15:58:02 [mysql] Attempting to start MySQL app...
15:58:03 [mysql] Status change detected: running
15:58:05 [mysql] Status change detected: stopped
15:58:05 [mysql] Error: MySQL shutdown unexpectedly.
15:58:05 [mysql] This may be due to a blocked port, missing dependencies,
15:58:05 [mysql] improper privileges, a crash, or a shutdown by another method.
15:58:05 [mysql] Press the Logs button to view error logs and check
15:58:05 [mysql] the Windows Event Viewer for more clues
15:58:05 [mysql] If you need more help, copy and post this
15:58:05 [mysql] entire log window on the forums

This is the log report...

2024-04-10 15:58:03 0 [Note] Starting MariaDB 10.4.32-MariaDB source revision c4143f909528e3fab0677a28631d10389354c491 as process 3352
2024-04-10 15:58:03 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2024-04-10 15:58:03 0 [Note] InnoDB: Uses event mutexes
2024-04-10 15:58:03 0 [Note] InnoDB: Compressed tables use zlib 1.3
2024-04-10 15:58:03 0 [Note] InnoDB: Number of pools: 1
2024-04-10 15:58:03 0 [Note] InnoDB: Using SSE2 crc32 instructions
2024-04-10 15:58:03 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2024-04-10 15:58:03 0 [Note] InnoDB: Completed initialization of buffer pool
2024-04-10 15:58:03 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=300288
2024-04-10 15:58:03 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2024-04-10 15:58:03 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2024-04-10 15:58:03 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2024-04-10 15:58:03 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2024-04-10 15:58:03 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2024-04-10 15:58:03 0 [Note] InnoDB: Waiting for purge to start
2024-04-10 15:58:03 0 [Note] InnoDB: 10.4.32 started; log sequence number 300297; transaction id 170
2024-04-10 15:58:03 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2024-04-10 15:58:03 0 [Note] Plugin 'FEEDBACK' is disabled.
2024-04-10 15:58:03 0 [Note] Server socket created on IP: '::'.
2024-04-10 15:58:03 0 [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.

2024-04-10 15:58:03 0 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2024-04-10 15:58:03 0 [ERROR] Aborting
2024-04-10 16:02:19 0 [Note] Starting MariaDB 10.4.32-MariaDB source revision c4143f909528e3fab0677a28631d10389354c491 as process 6772
2024-04-10 16:02:19 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2024-04-10 16:02:19 0 [Note] InnoDB: Uses event mutexes
2024-04-10 16:02:19 0 [Note] InnoDB: Compressed tables use zlib 1.3
2024-04-10 16:02:19 0 [Note] InnoDB: Number of pools: 1
2024-04-10 16:02:19 0 [Note] InnoDB: Using SSE2 crc32 instructions
2024-04-10 16:02:19 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2024-04-10 16:02:19 0 [Note] InnoDB: Completed initialization of buffer pool
2024-04-10 16:02:20 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2024-04-10 16:02:20 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2024-04-10 16:02:20 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2024-04-10 16:02:20 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2024-04-10 16:02:20 0 [Note] InnoDB: Waiting for purge to start
2024-04-10 16:02:20 0 [Note] InnoDB: 10.4.32 started; log sequence number 300306; transaction id 170
2024-04-10 16:02:20 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2024-04-10 16:02:20 0 [Note] Plugin 'FEEDBACK' is disabled.
2024-04-10 16:02:20 0 [Note] Server socket created on IP: '::'.
2024-04-10 16:02:20 0 [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.

2024-04-10 16:02:20 0 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2024-04-10 16:02:20 0 [Note] InnoDB: Buffer pool(s) load completed at 240410 16:02:20
2024-04-10 16:02:20 0 [ERROR] Aborting


PLEASE advise. Thank you sincerely!

Rob K



Update - I made a change to properties.ini for the port used by MySQL to 9080 and it runs now.
https://www.wikihow.com/Install-XAMPP-for-Windows