{"id":989,"date":"2021-07-23T12:42:54","date_gmt":"2021-07-23T12:42:54","guid":{"rendered":"https:\/\/ssdsunucum.com\/blog\/additional-mysql-access-hosts\/"},"modified":"2021-07-23T12:42:54","modified_gmt":"2021-07-23T12:42:54","slug":"additional-mysql-access-hosts","status":"publish","type":"post","link":"https:\/\/ssdsunucum.com\/blog\/additional-mysql-access-hosts\/","title":{"rendered":"Additional MySQL Access Hosts"},"content":{"rendered":"<\/p>\n
\n
\n
\n

Valid for versions 82 through the latest version<\/em><\/p>\n<\/div>\n

\n

Version:<\/h4>\n

82<\/h4>\n<\/div><\/div>\n
\n

Overview<\/h2>\n

This interface allows you to permit remote hosts (servers) to access MySQL\u00ae databases on your server, or to access a remote MySQL server that you configured via WHM\u2019s Manage MySQL Profiles<\/em> interface (WHM >> Home >> SQL Services >> Manage MySQL Profiles<\/em>). The system applies this list of servers to every cPanel user and every MySQL user that a cPanel user owns.<\/p>\n

\n
Note:<\/div>\n
\n
    \n
  • \n

    cPanel users cannot<\/strong> permanently remove remote hosts that you add through this interface. cPanel accounts can temporarily remove these remote hosts via cPanel\u2019s Remote MySQL<\/em> interface (cPanel >> Home >> Databases >> Remote MySQL<\/em>). However, the system restores these remote hosts when the user accesses cPanel\u2019s MySQL Databases<\/em> interface (cPanel >> Home >> Databases >> MySQL Database<\/em>) or the system administrator clicks the click here<\/em> link in the Additional MySQL Access Hosts<\/em> interface.<\/p>\n

      \n
    • \n

      cPanel accounts can add more remote hosts to their account and their MySQL users via cPanel\u2019s Remote MySQL<\/em> interface (cPanel >> Home >> Databases >> Remote MySQL<\/em>).<\/p>\n<\/li>\n

    • \n

      The system does not<\/strong> allow system accounts and root<\/code>-level users that are not cPanel accounts to use this functionality.<\/p>\n<\/li>\n<\/ul>\n<\/li>\n<\/ul><\/div>\n<\/div>\n

      Configure remote access to MySQL<\/h2>\n

      To configure the list of remote hosts with access to your MySQL databases, perform the following steps:<\/p>\n

        \n
      1. In the text box, enter the hostnames of remote hosts that you wish to access your server\u2019s MySQL databases.\n
          \n
        • You may enter the hostnames as fully qualified domain names (FQDNs) or IP addresses (for example, host.example.com<\/code> or 192.168.0.20<\/code>).\n
          \n
          Warning:<\/div>\n
          \n

          You must<\/strong> specify FQDNs in lowercase letters.<\/p>\n<\/p><\/div>\n<\/div>\n<\/li>\n<\/ul>\n<\/li>\n

        • Click Save<\/em>.<\/li>\n<\/ol>\n

          To add the hostnames to each user\u2019s access list, perform one of the following actions:<\/p>\n

            \n
          • Click click here<\/em> to automatically add the hostnames to each cPanel user\u2019s access list.<\/li>\n
          • Ask your cPanel users to access cPanel\u2019s Remote MySQL<\/em> interface (cPanel >> Home >> Databases >> Remote MySQL<\/em>) to add the hosts.<\/li>\n<\/ul>\n

            Troubleshooting<\/h2>\n

            If you experience issues when you attempt to add additional remote hosts that can access MySQL databases on your server, read our Troubleshoot MySQL Profiles documentation.<\/p>\n<\/p><\/div>\n","protected":false},"excerpt":{"rendered":"

            Valid for versions 82 through the latest version Version: 82 Overview This interface allows you to permit remote hosts (servers) to access MySQL\u00ae databases on your server, or to access a remote MySQL server that you configured via WHM\u2019s Manage MySQL Profiles interface (WHM >> Home >> SQL Services >> Manage MySQL Profiles). The system …<\/p>\n","protected":false},"author":1,"featured_media":990,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[1],"tags":[],"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/ssdsunucum.com\/blog\/wp-json\/wp\/v2\/posts\/989"}],"collection":[{"href":"https:\/\/ssdsunucum.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ssdsunucum.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ssdsunucum.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/ssdsunucum.com\/blog\/wp-json\/wp\/v2\/comments?post=989"}],"version-history":[{"count":0,"href":"https:\/\/ssdsunucum.com\/blog\/wp-json\/wp\/v2\/posts\/989\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/ssdsunucum.com\/blog\/wp-json\/wp\/v2\/media\/990"}],"wp:attachment":[{"href":"https:\/\/ssdsunucum.com\/blog\/wp-json\/wp\/v2\/media?parent=989"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ssdsunucum.com\/blog\/wp-json\/wp\/v2\/categories?post=989"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ssdsunucum.com\/blog\/wp-json\/wp\/v2\/tags?post=989"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}