MySQL Error

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

MySQL Error

Postby gamesprite » 09. December 2018 19:54

I am running WIndows 10 with Kaspersky antivirsus. I just downloaded and installed XAMPP and this is what I get. I tried to restart MySQL.

2:49:00 PM [main] Initializing Control Panel
2:49:00 PM [main] Windows Version: Home 64-bit
2:49:00 PM [main] XAMPP Version: 7.2.12
2:49:00 PM [main] Control Panel Version: 3.2.2 [ Compiled: Nov 12th 2015 ]
2:49:00 PM [main] You are not running with administrator rights! This will work for
2:49:00 PM [main] most application stuff but whenever you do something with services
2:49:00 PM [main] there will be a security dialogue or things will break! So think
2:49:00 PM [main] about running this application with administrator rights!
2:49:00 PM [main] XAMPP Installation Directory: "c:\xampp\"
2:49:00 PM [main] Checking for prerequisites
2:49:00 PM [main] All prerequisites found
2:49:00 PM [main] Initializing Modules
2:49:00 PM [mysql] Problem detected!
2:49:00 PM [mysql] Port 3306 in use by "Unable to open process"!
2:49:00 PM [mysql] MySQL WILL NOT start without the configured ports free!
2:49:00 PM [mysql] You need to uninstall/disable/reconfigure the blocking application
2:49:00 PM [mysql] or reconfigure MySQL and the Control Panel to listen on a different port
2:49:00 PM [main] The Mercury module is disabled
2:49:00 PM [main] The Tomcat module is disabled
2:49:00 PM [main] Starting Check-Timer
2:49:00 PM [main] Control Panel Ready
2:49:07 PM [Apache] Attempting to start Apache app...
2:49:07 PM [Apache] Status change detected: running
2:49:09 PM [mysql] Problem detected!
2:49:09 PM [mysql] Port 3306 in use by "Unable to open process"!
2:49:09 PM [mysql] MySQL WILL NOT start without the configured ports free!
2:49:09 PM [mysql] You need to uninstall/disable/reconfigure the blocking application
2:49:09 PM [mysql] or reconfigure MySQL and the Control Panel to listen on a different port
2:49:09 PM [mysql] Attempting to start MySQL app...
2:49:09 PM [mysql] Status change detected: running
2:49:12 PM [filezilla] Attempting to start FileZilla app...
2:49:12 PM [filezilla] Status change detected: running
2:49:12 PM [mysql] Status change detected: stopped
2:49:12 PM [mysql] Error: MySQL shutdown unexpectedly.
2:49:12 PM [mysql] This may be due to a blocked port, missing dependencies,
2:49:12 PM [mysql] improper privileges, a crash, or a shutdown by another method.
2:49:12 PM [mysql] Press the Logs button to view error logs and check
2:49:12 PM [mysql] the Windows Event Viewer for more clues
2:49:12 PM [mysql] If you need more help, copy and post this
2:49:12 PM [mysql] entire log window on the forums
2:49:20 PM [mysql] +
gamesprite
 
Posts: 4
Joined: 09. December 2018 02:28
XAMPP version: 7.2
Operating System: windows 10

Re: MySQL Error

Postby Altrea » 09. December 2018 20:34

Your port 3306 is already in use, probably by another Mysql installation.
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: 11935
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 11 Pro x64

Re: MySQL Error

Postby gamesprite » 09. December 2018 21:52

I know that. I need to know how to change the settings so XAMPP will use a different port
gamesprite
 
Posts: 4
Joined: 09. December 2018 02:28
XAMPP version: 7.2
Operating System: windows 10

Re: MySQL Error

Postby Altrea » 10. December 2018 08:52

You need to change the port in your MySQL my.ini, control panel Configs and phpmyadmin config.inc.php file.
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: 11935
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 11 Pro x64

Re: MySQL Error

Postby gamesprite » 10. December 2018 23:21

Ok, I changed to port in my.ini under MySQL but I do not see anywhere to change the port number in the config.inc.php file under phpMyAdmin
gamesprite
 
Posts: 4
Joined: 09. December 2018 02:28
XAMPP version: 7.2
Operating System: windows 10

Re: MySQL Error

Postby gamesprite » 10. December 2018 23:25

I have started MySQL but when I click the admin button, the webpage says I am not connected because of incorrect settings.
gamesprite
 
Posts: 4
Joined: 09. December 2018 02:28
XAMPP version: 7.2
Operating System: windows 10

Re: MySQL Error

Postby Altrea » 11. December 2018 00:15

If the port setting is not settled in the config.inc.php you must create the line on your own.
Take a look in the phpmyadmin documentation to know how this setting looks like.
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: 11935
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 11 Pro x64


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 113 guests