Page 1 of 1

MYSQL Error with Closed Port

PostPosted: 29. June 2015 17:43
by db5023
I got this error on the XAMPP Control Panel. I am brand new to PHP, so I have no idea where to start here. The part in red is where the errors start happening

12:34:46 PM [main] Initializing Control Panel
12:34:46 PM [main] Windows Version: Windows 8 64-bit
12:34:46 PM [main] XAMPP Version: 5.6.8
12:34:46 PM [main] Control Panel Version: 3.2.1 [ Compiled: May 7th 2013 ]
12:34:46 PM [main] You are not running with administrator rights! This will work for
12:34:46 PM [main] most application stuff but whenever you do something with services
12:34:46 PM [main] there will be a security dialogue or things will break! So think
12:34:46 PM [main] about running this application with administrator rights!
12:34:46 PM [main] XAMPP Installation Directory: "c:\xampp\"
12:34:46 PM [main] Checking for prerequisites
12:35:05 PM [main] All prerequisites found
12:35:05 PM [main] Initializing Modules
12:35:05 PM [mysql] Problem detected!
12:35:05 PM [mysql] Port 3306 in use by ""C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqld.exe" --defaults-file="C:\ProgramData\MySQL\MySQL Server 5.6\my.ini" MySQL56"!
12:35:05 PM [mysql] MySQL WILL NOT start without the configured ports free!
12:35:05 PM [mysql] You need to uninstall/disable/reconfigure the blocking application
12:35:05 PM [mysql] or reconfigure MySQL and the Control Panel to listen on a different port

Re: MYSQL Error with Closed Port

PostPosted: 29. June 2015 18:22
by glitzi85
There is another MySQL installation on your computer. If you installed it by accident simply remove it. If it was installed by another program that requires MySQL, you need to change the port of one installation (there should be an option in the CP).

Re: MYSQL Error with Closed Port

PostPosted: 29. June 2015 19:44
by db5023
The control panel for XAMPP? Sorry, I'm very new to this.

I installed MySql WorkBench 5.6 on purpose, so I can pracitce SQL queries. Are you saying i should delete this program?

Re: MYSQL Error with Closed Port

PostPosted: 29. June 2015 20:17
by Altrea
glitzi85 wrote:(there should be an option in the CP).

The setting in the XAMPP control panel only takes effect for the control panel prechecks.
So to change the MySQL port and keep the functionality of the CP you need to change the MySQL port on two places,, the MySQL my.ini and the CP configuration.

Re: MYSQL Error with Closed Port

PostPosted: 29. June 2015 20:51
by glitzi85
@Altrea: Good to know

@db5023: The current version of MySQL Workbench is 6.3. The current version of MySQL Server is 5.6. Are you sure you installed the Workbench and not the Server?

Re: MYSQL Error with Closed Port

PostPosted: 29. June 2015 23:46
by db5023
It seems I have installed SQL Server and MySQL Workbench

I'm going to need a step by step guys, I don't know what MySQL my.ini is

Re: MYSQL Error with Closed Port

PostPosted: 30. June 2015 00:20
by db5023
Ok, Im just gonna delete anything MySQL related on my PC, reinstall XAMPP, and see what happens

Re: MYSQL Error with Closed Port

PostPosted: 30. June 2015 08:50
by glitzi85
That will work. However, uninstalling MySQL Workbench won't be necessary. Uninstall of MySQL Server should be sufficient.