You can use any unused port on your computer between 1 to 65535, but I usually use port 3307. Below this line, you should find the port number, which says port=3306 by default. Inside the file, go down and find the section that contains the following line: # The MySQL server. In the XAMPP control panel, click on the Config button of the MySQL module.Regardless, below are the steps to change the port of XAMPP’s MySQL: Do note that if another MySQL program is using port 3306, there is a chance that this doesn’t work, as 2 seperate installations of MySQL can interfere with each other. If you don’t want to uninstall the program that is using port 3306, or if you can’t find the process using the instructions above, you can also configure XAMPP MySQL to use a different port. …or some other variation of MySQL, since it is one of the few programs that use port 3306.Īfter uninstalling the other program(s), remember to restart your computer before trying to start MySQL again. In most cases, this should be another installation of MySQL on your computer, such as: If it doesn’t work, you will have to find the program that was creating the process and uninstall it. Depending on the program that was occupying port 3306, this might or might not work. Once this is done, you can try starting MySQL on XAMPP again. If your Task Manager doesn’t show all the processes, click on More details at the bottom of the window to get the full Task Manager window. If port 3306 is in the list when you haven’t started MySQL on XAMPP, this means that another program is using it. To ascertain whether this is the case, you can click on the Netstat button to open up a window with a list of all the ports that are being used on your computer currently. By default, XAMPP’s MySQL service binds to port 3306 when started, and it can only do so if another program is not already using it. The most likely reason that XAMPP’s MySQL service is unable to start is because port 3306 is already used by a different program that is currently running on your computer. Possible causes and fixesīelow are some common causes that prevent XAMPP’s MySQL module from starting. improper priviliges, a crash, or a shutdown by another method. This may be due to a blocked port, missing dependencies, Below is a transcription of the error log shown on XAMPP when MySQL fails to start: Attempting to start MySQL service.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |