{"id":1023,"date":"2018-05-17T17:00:57","date_gmt":"2018-05-17T17:00:57","guid":{"rendered":"https:\/\/chemicloud.com\/kb\/?post_type=article&p=1023"},"modified":"2020-08-08T04:45:41","modified_gmt":"2020-08-08T04:45:41","slug":"how-to-configure-remote-access-to-mysql-database-in-cpanel","status":"publish","type":"ht_kb","link":"https:\/\/chemicloud.com\/kb\/article\/how-to-configure-remote-access-to-mysql-database-in-cpanel\/","title":{"rendered":"How to Configure Remote Access to MySQL Database in cPanel"},"content":{"rendered":"

General information<\/h3>\n

In this article, we will shed some light on a very useful feature. One of the most useful features of cPanel is the ability to enable remote access to your MySQL Databases.<\/p>\n

This is important because some third party applications or web developers, for example, \u00a0might need access to your database from their server or their local computer. In order for them to do this securely, you need to add their IP Addresses to a whitelist. Additional privileges might be needed to allow further changes to the databases. In this case, you should contact your hosting provider and let them know exactly what you need.<\/p>\n

How to Configure Remote Access to MySQL Database<\/h3>\n

Here is how you go about doing this.<\/p>\n

1.<\/strong> Log in<\/a> to your cPanel account.<\/p>\n

2.<\/strong> Navigate to the Database <\/em>section and click on Remote MySQL<\/em> \u00ae<\/em> .<\/p>\n

\"\"<\/p>\n

3.<\/strong> In the Add Access Host <\/em>box, you need to enter each individual IP Address and click on Add Host.\u00a0<\/em>You can get your own IP address at ip4.me<\/a>. If your web developer is the person who requires access, ask them to visit that URL and to provide you with their own IP address.<\/p>\n

\"\"<\/p>\n

Bellow this section you will see a list with all the added access hosts (or IPs). You can also remove IP addresses, if needed.<\/p>\n

Another interesting feature is the possibility to add the \u201c%\u201d wildcard. This allows you to add an entire IP range to the access hosts list. While it may seem like an easy \u201cfix\u201d, the usage of the % is not advisable, as it presents some security risks.<\/p>\n \t\t

\r\n \t\t\t \t\t\t \t\t\t\t

\r\n \t\t\t\t\tMake sure you always take into account the security issues when allowing third-party IP Addresses access to your database. This type of vulnerability may be exploited by people looking to steal sensitive or proprietary customer information. \t\t\t\t<\/p>\r\n \t\t\t \t\t\t\r\n \t\t<\/div>\r\n \t\t\n

How to connect remotely to MySQL Database using MySQL Workbench<\/h3>\n

MySQL Workbench is a visual tool for database architects and developers. MySQL Workbench provides data modeling, SQL development, and comprehensive database administration tools, and much more. MySQL Workbench is available on Windows, Linux, and Mac OS X. You can download it here<\/a>.<\/p>\n

Once MySQL Workbench is installed, please follow the steps below to connect to your database:<\/p>\n

    \n
  1. Open\u00a0MySQL Workbench<\/strong>.<\/li>\n
  2. Click\u00a0New Connection<\/strong>\u00a0towards the bottom left of MySQL Workbench.<\/li>\n
  3. In the \u201cSet up a New Connection Dialogue<\/em>\u201d box, Type your Database connection credentials. The credentials will be like the following:Connection Name:\u00a0<\/strong>You can name this whatever you like.
    \nConnection Method:\u00a0<\/strong>Standard (TCP\/IP).
    \nHostname:\u00a0<\/strong>You can use your domain our your     server’s IP addres<\/a>s.
    \nPort:\u00a0<\/strong>3306
    \nUsername: <\/strong>the user you created for the database.
    \nPassword: <\/strong>the password for the database user that was created.
    \nDefault Schema:\u00a0<\/strong>This can be left blank.<\/li>\n
  4. Click\u00a0Test Connection<\/strong>.<\/li>\n
  5. Type your password and click the \u201cSave Password in Vault<\/em>\u201d checkbox. Click Ok<\/strong>.<\/li>\n
  6. MySQL Workbench should say \u201cConnection parameters are correct<\/em>\u201c. Click\u00a0Ok<\/strong>.<\/li>\n
  7. Click\u00a0Ok<\/strong>\u00a0again to accept the connection settings.<\/li>\n
  8. Now under the SQL Development section, you will see your connection listed in the Open Connection to Start Querying box. Click your newly created account.<\/li>\n
  9. Now you will see the databases list in the area on the left.<\/li>\n<\/ol>\n

    That’s all! Now you know how to connect remotely to your MySQL database.<\/p>\n

    \n","protected":false},"excerpt":{"rendered":"

    General information In this article, we will shed some light on a very useful feature. One of the most useful features of cPanel is the ability to enable remote access to your MySQL Databases. This is important because some third party applications or web developers, for example, \u00a0might need access…<\/p>\n","protected":false},"author":10,"featured_media":0,"comment_status":"open","ping_status":"closed","template":"","format":"standard","meta":{"_crdt_document":"","footnotes":""},"ht-kb-category":[38],"ht-kb-tag":[],"class_list":["post-1023","ht_kb","type-ht_kb","status-publish","format-standard","hentry","ht_kb_category-mysql"],"_links":{"self":[{"href":"https:\/\/chemicloud.com\/kb\/wp-json\/wp\/v2\/ht-kb\/1023","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/chemicloud.com\/kb\/wp-json\/wp\/v2\/ht-kb"}],"about":[{"href":"https:\/\/chemicloud.com\/kb\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"https:\/\/chemicloud.com\/kb\/wp-json\/wp\/v2\/users\/10"}],"replies":[{"embeddable":true,"href":"https:\/\/chemicloud.com\/kb\/wp-json\/wp\/v2\/comments?post=1023"}],"version-history":[{"count":9,"href":"https:\/\/chemicloud.com\/kb\/wp-json\/wp\/v2\/ht-kb\/1023\/revisions"}],"predecessor-version":[{"id":3284,"href":"https:\/\/chemicloud.com\/kb\/wp-json\/wp\/v2\/ht-kb\/1023\/revisions\/3284"}],"wp:attachment":[{"href":"https:\/\/chemicloud.com\/kb\/wp-json\/wp\/v2\/media?parent=1023"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/chemicloud.com\/kb\/wp-json\/wp\/v2\/ht-kb-category?post=1023"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/chemicloud.com\/kb\/wp-json\/wp\/v2\/ht-kb-tag?post=1023"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}