![]() But the port no needs changes in few other places such as my.in. Once you have completed these steps, you will have port 3306 on your Plesk server open for successful database migration. A Mysql Port (3306) used error in XAMPP can be easily fixed by changing the port no of mysql. Check the box to allow local MySQL server to accept external connections and finally click on accept. Finally, from the Database servers page (which can be reached by following steps 6 and 7), click on localhost of the server containing the web database to be transferred.ġ1. As in step 5, you must select Allow remote connections from, indicating the IP 81.25.112.90 to enable remote access for database users, and then click accept.ġ0. ![]() Once on the database server, click on Settings.ĩ. Click on Database servers, located under "Applications and databases".Ĩ. To do this go to Tools and Settings in the left hand menu of Plesk.ħ. Next, you will need to allow remote connections for database hosting. The IP 81.25.112.90 is the one of the server owned by SWHosting in charge of migrating your Hosting from your current provider to your hosting hosted in SWHosting.Ħ. ![]() If you go to the bottom you will find the "Access Control" options, where you must select Allow remote connections from indicating the IP 81.25.112.90 and then accept the changes. Start the MySQL service using below command: /etc/init. If MySQL service is found running in step 3 then kill the service using below command: kill -9 pid. From your website's database administration, click on the user name of the database.ĥ. Check if MySQL service port 3306 is still in use or not by running below command: netstat -apn grep 3306. Once the menu for the selected website has been displayed, go to Databases.Ĥ. Now, in Xampp, click on ' config ' in the Mysql row (click on Mysql's 'config'), and open ' my.ini '. Now click on the website on which you want to open port 3306 to perform a migration.ģ. Go to ' config ' at top-right corner of the Xampp window, click on ' service and port settings ', go to ' mysql ' tab and change the ' main port ' to 3308 or something else. Once logged in to Plesk, go to the main screen by clicking on Websites and Domains, located on the left menu.Ģ. In the following manual, we will show you how to open port 3306 in Plesk.ġ. In order to perform a complete migration from another Hosting to SWHosting, it is essential that port 3306, which corresponds to the MySQL database, is open.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |