MYSQL Error with Closed Port

[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

[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).

[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?

[Altrea]

(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.

[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?

[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

[db5023]

Ok, Im just gonna delete anything MySQL related on my PC, reinstall XAMPP, and see what happens

[glitzi85]

That will work. However, uninstalling MySQL Workbench won't be necessary. Uninstall of MySQL Server should be sufficient.