Setting An IP Address<\/span><\/h2>\nBefore establishing connection remotely your computer must be added to\u00a0Access Host\u00a0<\/strong>in cPanel.<\/span><\/p>\na. Log into\u00a0\u00a0cPanel and under Databases, click the\u00a0Remote MySQL icon<\/strong>.<\/p>\n![\"\"](\"https:\/\/fortunehost.com\/knowledgebase\/wp-content\/uploads\/2017\/11\/ms1-1-300x119.png\")
<\/p>\n
b. Now insert the remote IP address\u00a0in the\u00a0Add Access Host<\/strong>\u00a0section.<\/p>\n![\"\"](\"https:\/\/fortunehost.com\/knowledgebase\/wp-content\/uploads\/2017\/11\/ms1-3-300x101.png\")
<\/p>\n
c. Click the\u00a0Add Host\u00a0<\/strong>button to add the IP address.<\/p>\n![\"\"](\"https:\/\/fortunehost.com\/knowledgebase\/wp-content\/uploads\/2017\/11\/ms1-4-300x101.png\")
<\/p>\n
d. The completion will appear with below message.<\/p>\n
![\"\"](\"https:\/\/fortunehost.com\/knowledgebase\/wp-content\/uploads\/2017\/11\/ms1-6-300x118.png\")
<\/p>\n
This feature allows numerous IPs be added for remote connection.<\/p>\n
You can now proceed to establish remote connection to MySQL databases.<\/p>\n
Removing an IP Address<\/h2>\n
You may want to remove an IP address when no longer you use it or want to deny remote access.<\/p>\n
Simply click the ‘Delete’\u00a0<\/strong>button next to the IP in the area.<\/p>\n![\"\"](\"https:\/\/fortunehost.com\/knowledgebase\/wp-content\/uploads\/2017\/11\/ms1-9-300x58.png\")
<\/p>\n
That’s it!<\/p>\n
<\/p>\n","protected":false},"excerpt":{"rendered":"
Remote MySQL database connection establishes connection between your local computer to MySQL database.\u00a0 To achieve this we need third party[…]<\/p>\n","protected":false},"author":1,"featured_media":52,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-34","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-cpanel"],"_links":{"self":[{"href":"https:\/\/fortunehost.com\/knowledgebase\/wp-json\/wp\/v2\/posts\/34"}],"collection":[{"href":"https:\/\/fortunehost.com\/knowledgebase\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/fortunehost.com\/knowledgebase\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/fortunehost.com\/knowledgebase\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/fortunehost.com\/knowledgebase\/wp-json\/wp\/v2\/comments?post=34"}],"version-history":[{"count":19,"href":"https:\/\/fortunehost.com\/knowledgebase\/wp-json\/wp\/v2\/posts\/34\/revisions"}],"predecessor-version":[{"id":77,"href":"https:\/\/fortunehost.com\/knowledgebase\/wp-json\/wp\/v2\/posts\/34\/revisions\/77"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/fortunehost.com\/knowledgebase\/wp-json\/wp\/v2\/media\/52"}],"wp:attachment":[{"href":"https:\/\/fortunehost.com\/knowledgebase\/wp-json\/wp\/v2\/media?parent=34"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/fortunehost.com\/knowledgebase\/wp-json\/wp\/v2\/categories?post=34"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/fortunehost.com\/knowledgebase\/wp-json\/wp\/v2\/tags?post=34"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
a. Log into\u00a0\u00a0cPanel and under Databases, click the\u00a0Remote MySQL icon<\/strong>.<\/p>\n b. Now insert the remote IP address\u00a0in the\u00a0Add Access Host<\/strong>\u00a0section.<\/p>\n c. Click the\u00a0Add Host\u00a0<\/strong>button to add the IP address.<\/p>\n d. The completion will appear with below message.<\/p>\n This feature allows numerous IPs be added for remote connection.<\/p>\n You can now proceed to establish remote connection to MySQL databases.<\/p>\n You may want to remove an IP address when no longer you use it or want to deny remote access.<\/p>\n Simply click the ‘Delete’\u00a0<\/strong>button next to the IP in the area.<\/p>\n That’s it!<\/p>\n <\/p>\n","protected":false},"excerpt":{"rendered":" Remote MySQL database connection establishes connection between your local computer to MySQL database.\u00a0 To achieve this we need third party[…]<\/p>\n","protected":false},"author":1,"featured_media":52,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-34","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-cpanel"],"_links":{"self":[{"href":"https:\/\/fortunehost.com\/knowledgebase\/wp-json\/wp\/v2\/posts\/34"}],"collection":[{"href":"https:\/\/fortunehost.com\/knowledgebase\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/fortunehost.com\/knowledgebase\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/fortunehost.com\/knowledgebase\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/fortunehost.com\/knowledgebase\/wp-json\/wp\/v2\/comments?post=34"}],"version-history":[{"count":19,"href":"https:\/\/fortunehost.com\/knowledgebase\/wp-json\/wp\/v2\/posts\/34\/revisions"}],"predecessor-version":[{"id":77,"href":"https:\/\/fortunehost.com\/knowledgebase\/wp-json\/wp\/v2\/posts\/34\/revisions\/77"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/fortunehost.com\/knowledgebase\/wp-json\/wp\/v2\/media\/52"}],"wp:attachment":[{"href":"https:\/\/fortunehost.com\/knowledgebase\/wp-json\/wp\/v2\/media?parent=34"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/fortunehost.com\/knowledgebase\/wp-json\/wp\/v2\/categories?post=34"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/fortunehost.com\/knowledgebase\/wp-json\/wp\/v2\/tags?post=34"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}<\/p>\n<\/p>\n<\/p>\n<\/p>\nRemoving an IP Address<\/h2>\n
<\/p>\n