How can I configure remote access for mysql?

Important Notes:

• This guide will help you configure your server to allow remote connections to your mySQL database. This guide is intended for server with the Plesk Control Panel installed. 
• If you are with Managed Hosting, please login to https://serverportal.com/ and submit an A la Carte' work order.  To maintain security, please ensure you include the exact address you wish to grant access to, as wide open grant all IP access permissions are not permitted.
  

Getting Started:

1. Log into your Plesk Control panel by browsing to https://yourserversipaddress:8443 . You can log in using the username 'admin' and the password that was emailed to you when your dedicated server was setup.

2. Once logged in, click on 'Domains' on the left side of the control panel.

   
   

3. Choose the domain that the database will be associated with.

   
   

4. Click on 'Databases', located under the 'Services' heading

   
   

5. If you have not created a database yet, click on 'Add New Database' to create a database. If you already have a database listed or if you've just created a new database, simply click on the database listed below.

   
   

6. Now you'll need to click on 'Add New Database user', this is the user account that you will be remotely logging into the mySQL server with. You will need to remember the username and password that you set here.

7. Now that the user has been added, we simply need to open the mySQL port (3306) in the firewall and restrict it to allow access only to your home/office computer. To do this, just click on 'Modules' on the left side of the Plesk Control Panel.

   
   

8. Next, Click on 'Firewall'.

   
   

9. You are now looking at the firewall options for you server. First you should click on 'Edit Firewall Configurations'.

   
   

10. Now find the entry labeled 'MySQL server' and click on the text.

    
    

11. This is where you can edit the rules for port 3306, the default mySQL port. Choose the 'Allow from selected sources, deny from others' option.

    
    

12. A text box will appear below, go ahead and enter your local static IP address in this box and then click 'add'.

    
    

13. You can now access your mySQL database from a remote location.

Related Articles

• What is the username and password to access MySQL on my Unix dedicated server?
• How do I manage databases in the Plesk control panel?
• Do you have some database performance tuning suggestions?
• How do I optimze mysql?
• How do I back up a MySQL database from command line?

Attachments

No attachments were found.

Visitor Comments

No visitor comments posted. Post a comment