Page 1 of 1

MySQL Error

PostPosted: 09. December 2018 19:54
by gamesprite
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] +

Re: MySQL Error

PostPosted: 09. December 2018 20:34
by Altrea
Your port 3306 is already in use, probably by another Mysql installation.

Re: MySQL Error

PostPosted: 09. December 2018 21:52
by gamesprite
I know that. I need to know how to change the settings so XAMPP will use a different port

Re: MySQL Error

PostPosted: 10. December 2018 08:52
by Altrea
You need to change the port in your MySQL my.ini, control panel Configs and phpmyadmin config.inc.php file.

Re: MySQL Error

PostPosted: 10. December 2018 23:21
by gamesprite
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

Re: MySQL Error

PostPosted: 10. December 2018 23:25
by gamesprite
I have started MySQL but when I click the admin button, the webpage says I am not connected because of incorrect settings.

Re: MySQL Error

PostPosted: 11. December 2018 00:15
by Altrea
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.