MYSQL Error with Closed Port

Problems with the Windows version of XAMPP, questions, comments, and anything related.

MYSQL Error with Closed Port

Postby db5023 » 29. June 2015 17:43

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
db5023
 
Posts: 4
Joined: 29. June 2015 17:40
Operating System: Windows

Re: MYSQL Error with Closed Port

Postby glitzi85 » 29. June 2015 18:22

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).
User avatar
glitzi85
 
Posts: 1920
Joined: 05. March 2004 23:26
Location: Dahoim

Re: MYSQL Error with Closed Port

Postby db5023 » 29. June 2015 19:44

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?
db5023
 
Posts: 4
Joined: 29. June 2015 17:40
Operating System: Windows

Re: MYSQL Error with Closed Port

Postby Altrea » 29. June 2015 20:17

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.
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 8288
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 10 Pro x64

Re: MYSQL Error with Closed Port

Postby glitzi85 » 29. June 2015 20:51

@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?
User avatar
glitzi85
 
Posts: 1920
Joined: 05. March 2004 23:26
Location: Dahoim

Re: MYSQL Error with Closed Port

Postby db5023 » 29. June 2015 23:46

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
 
Posts: 4
Joined: 29. June 2015 17:40
Operating System: Windows

Re: MYSQL Error with Closed Port

Postby db5023 » 30. June 2015 00:20

Ok, Im just gonna delete anything MySQL related on my PC, reinstall XAMPP, and see what happens
db5023
 
Posts: 4
Joined: 29. June 2015 17:40
Operating System: Windows

Re: MYSQL Error with Closed Port

Postby glitzi85 » 30. June 2015 08:50

That will work. However, uninstalling MySQL Workbench won't be necessary. Uninstall of MySQL Server should be sufficient.
User avatar
glitzi85
 
Posts: 1920
Joined: 05. March 2004 23:26
Location: Dahoim


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 41 guests