Guides and tutorials

Hundreds of tutorials and step by step guides carefully written by our support team.

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. In the following manual, we will show you how to open port 3306 in Plesk.

1. Once logged in to Plesk, go to the main screen by clicking on Websites and Domains, located on the left menu. enter image description here

2. Now click on the website on which you want to open port 3306 to perform a migration. enter image description here

3. Once the menu for the selected website has been displayed, go to Databases. enter image description here

4. From your website's database administration, click on the user name of the database. enter image description here

5. 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. 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. enter image description here

6. Next, you will need to allow remote connections for database hosting. To do this go to Tools and Settings in the left hand menu of Plesk. enter image description here

7. Click on Database servers, located under "Applications and databases". enter image description here

8. Once on the database server, click on Settings. enter image description here

9. 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. enter image description here

10. 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. enter image description here

11. Check the box to allow local MySQL server to accept external connections and finally click on *accept. enter image description here

Once you have completed these steps, you will have port 3306 on your Plesk server open for successful database migration.

More than 2000 m² of own facilities and Data Centers in Spain
Your privacy is important for us
We use our own cookies for the proper functioning of the site. In addition, third-party cookies are used for analytical purposes only. This information is not associated with any person so that personal identifying data is not stored, but is only information that is collected to identify the session, with the aim of facilitating the analysis of the website. You can change your preferences at any time by entering this website again. For more information about our cookie policy you can visit our Cookies. You can press the "Accept and close" button to give us your consent or you can access more detailed information and manage cookies.
More than 2000 m² of own facilities and Data Centers in Spain
Your privacy is important for us
We use our own cookies for the proper functioning of the site. In addition, third-party cookies are used for analytical purposes only. This information is not associated with any person so that personal identifying data is not stored, but is only information that is collected to identify the session, with the aim of facilitating the analysis of the website. You can change your preferences at any time by entering this website again. For more information about our cookie policy you can visit our Cookies. You can press the "Accept and close" button to give us your consent or you can access more detailed information and manage cookies.