Guides and tutorials

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

How to open 3306 port in Plesk

In order to carry out 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, it will be shown how to open port 3306 in Plesk.

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

  2. Now click on the web 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 username 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 any host and accept the changes. enter image description here

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

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

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

  9. As you did in step number 5, you must select Allow remote connections from any host, in the default configuration for remote access of database users and, finally, accept. enter image description here

  10. To finish, from the Database Servers page (which can be reached by following steps 6 and 7), click on localhost of the server that contains the web database to to transfer. enter image description here

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

Once these steps have been carried out, you will already have port 3306 of your server in your Plesk open to be able to carry out the migration of the database successfully.

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.
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.