# connect), the slave will create a file, and any later # if you mistyped the password in master-password and the slave fails to # start replication for the first time (even unsuccessfully, for example However, in case you choose this method, then # MASTER_USER='joe', MASTER_PASSWORD='secret' # by the master's port number (3306 by default). # where you replace, , by quoted strings and # This is for a system with little memory (, MASTER_PORT=, Save the changes to the file, and try to start MySQL on XAMPP again.Īrticle continues after the advertisement:īelow is a snapshot of my my.cnf file, with the part that you need to change highlighted: my.cnf # Example MySQL config file for small systems.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, For LAMP, you can locate the files on 'usr/bin/apache' directory.Below is a transcription of the error log shown on XAMPP when MySQL fails to start: Attempting to start MySQL service. The same procedure can be applied for 'WAMP' and 'LAMP' stacks. You have successfully changed the default port numbers of apache and mysql server on xampp server. You can use 'Netstat' to check all used ports on your system. Please make sure the new port number is not used by any other service. and change it to '3310' or something else and save. To do this, go to /mysql/bin/ and open the file my.ini. Just like Apache, you can also change the default port used by MySQL Server which is '3306'. This is not required when you leave apache to run on the default port itself. Please remember to use the port number along with local host to access it. If everything goes fine, you will see the xampp home page. Open /apache/conf/extra/nf file and search for the lines,ĭone! Now restart Apache and access the url on browser. to some unused port like this,Īnd replace '80' with the new port no like this, Unless you have changed it, this is the port number you must replace.Īnd then change the port no. Go to /apache/conf folder and open nf file. Stop Apache server and exit XAMPP control panel if it is already running.
0 Comments
Leave a Reply. |