{"id":1001,"date":"2021-07-23T12:43:11","date_gmt":"2021-07-23T12:43:11","guid":{"rendered":"https:\/\/ssdsunucum.com\/blog\/manage-mysql-profiles\/"},"modified":"2021-07-23T12:43:11","modified_gmt":"2021-07-23T12:43:11","slug":"manage-mysql-profiles","status":"publish","type":"post","link":"https:\/\/ssdsunucum.com\/blog\/manage-mysql-profiles\/","title":{"rendered":"Manage MySQL\u00ae Profiles"},"content":{"rendered":"<\/p>\n
\n
\n
\n

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

\n

Version:<\/h4>\n

82<\/h4>\n

88<\/h4>\n<\/div><\/div>\n
\n

Overview<\/h2>\n

This interface allows you to manage multiple MySQL\u00ae profiles. A profile defines the connection information for a local or remote MySQL server.<\/p>\n

You may wish to use a separate MySQL server if, for example, you manage particularly busy servers or servers with large databases. You can offload MySQL-related work to the remote MySQL server.<\/p>\n

Remote MySQL servers include other cPanel & WHM servers that run MySQL, a dedicated MySQL server, and the Amazon Relational Database\u2122 Service (RDS).<\/p>\n

\n
Warning:<\/div>\n
\n

If both<\/strong> of the following conditions are true, you may introduce a security vulnerability:<\/p>\n

    \n
  • The local server runs MySQL 5.7.<\/li>\n
  • The remote server runs MySQL 8.0 and later or Amazon RDS.<\/li>\n<\/ul>\n
      \n
    • Upgrade the local cPanel & WHM server to MySQL 8.0.<\/li>\n
    • Add a root<\/code> user to the remote server that is only<\/strong> allowed to log in from the local server\u2019s IP address.<\/li>\n<\/ul><\/div>\n<\/div>\n
      \n
      Note:<\/div>\n
      \n

      If the remote server runs MySQL 8.0 installed from the community repository and you have authentication issues, read our Troubleshoot MySQL\u00ae Profiles documentation.<\/p>\n<\/p><\/div>\n<\/div>\n

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

        This feature only<\/strong> allows active connections to servers that run the following database versions:<\/p>\n

          \n
        • MySQL versions 5.6, 5.7, and 8.0.<\/li>\n
        • MariaDB versions 10.1, 10.2, and 10.3.<\/li>\n<\/ul>\n<\/li>\n
        • \n

          You can use MySQL versions 5.7 or 8.0 on Amazon RDS servers. We do not<\/strong> support MariaDB or Amazon Aurora (Aurora) on Amazon RDS servers.<\/p>\n<\/li>\n

        • \n

          A \/root\/.my.cnf<\/code> file must<\/strong> exist on any remote MySQL servers, and this file must<\/strong> contain the MySQL root<\/code> user and password.<\/p>\n<\/li>\n

        • \n

          Amazon RDS uses the plaintext MySQL protocol. For security and performance reasons, we strongly<\/strong> recommend that only you connect to an Amazon RDS from an EC2\u2122 instance in the same availability zone.<\/p>\n<\/li>\n

        • \n

          When you suspend a cPanel account, the system will not<\/strong> suspend any of the account\u2019s Amazon RDS remote databases.<\/p>\n<\/li>\n<\/ul><\/div>\n<\/div>\n

          Remote MySQL server information<\/h2>\n

          The Manage MySQL Profiles<\/em> interface configures the remote server to work with your MySQL setup. After you configure the remote server, you must<\/strong> manually transfer your existing MySQL data to that server and configure your accounts\u2019 applications to use that server. Any new databases that you create will exist on the remote MySQL server.<\/p>\n

          For example, If you move an existing WordPress\u00ae database to the remote server, you must also update the WordPress server\u2019s configuration files to use the new server.<\/p>\n

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

            Before you set up a remote MySQL server, ensure that you install the openssh-clients<\/code> package on your local cPanel & WHM server. You cannot<\/strong> set up a remote MySQL server without this package.<\/p>\n<\/li>\n

          • \n

            We strongly<\/strong> recommend that you only<\/strong> connect one cPanel & WHM server to each remote MySQL server. If you connect multiple cPanel & WHM servers to one remote MySQL server, you may experience database and username conflicts.<\/p>\n<\/li>\n

          • \n

            This feature does not<\/strong> automatically transfer your MySQL data.<\/p>\n<\/li>\n

          • \n

            Do not<\/strong> use the q<\/code> option in your server\u2019s MySQL configuration. This option can cause problems on any<\/strong> server. It will create more<\/strong> problems on remote MySQL servers, during account transfers and restorations, and with phpMyAdmin.<\/p>\n<\/li>\n<\/ul><\/div>\n<\/div>\n

            MySQL profile information<\/h3>\n

            The interface displays the following columns for each MySQL profile:<\/p>\n

              \n
            • \n

              Profile<\/em> \u2014 The name of the MySQL profile.<\/p>\n<\/li>\n

            • \n

              Host<\/em> \u2014 The MySQL server\u2019s IP address or hostname.<\/p>\n<\/li>\n

            • \n

              Port<\/em> \u2014 The MySQL server\u2019s port number.<\/p>\n<\/li>\n

            • \n

              User<\/em> \u2014 The SSH or MySQL username that you will use to authenticate to this host.<\/p>\n<\/li>\n

            • \n

              Type<\/em> \u2014 A description of the profile data.<\/p>\n<\/li>\n

            • \n

              Actions<\/em> \u2014 Click one of the following icons to perform the appropriate action:<\/p>\n

                \n
              • \n

                Validate<\/em> \u2014 Test the profile\u2019s MySQL server settings.<\/p>\n<\/li>\n

              • \n

                Activate<\/em> \u2014 Set this profile as the active profile. A green lightning bolt icon () indicates the currently-active profile. <\/p>\n

                \n
                Note:<\/div>\n
                \n You may only<\/strong> select one active profile at a time.\n <\/div>\n<\/div>\n<\/li>\n
              • \n

                Delete<\/em> \u2014 Delete the profile. <\/p>\n

                \n
                Note:<\/div>\n
                \n You cannot delete the active profile.\n <\/div>\n<\/div>\n<\/li>\n
              • \n

                \u2014 Edit the profile.<\/p>\n<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n

                Add profile<\/h2>\n
                \n
                Note:<\/div>\n
                \n If no active profile exists, the system uses the information in the \/root\/.my.cnf<\/code> file to generate an active profile.\n <\/div>\n<\/div>\n

                To create a new MySQL profile, perform the following steps:<\/p>\n

                  \n
                1. \n

                  Click Add Profile<\/em>. A new interface will appear.<\/p>\n<\/li>\n

                2. \n

                  Enter the desired MySQL profile name in the Profile Name<\/em> text box. <\/p>\n

                  \n
                  Note:<\/div>\n
                  \n After you save the MySQL profile name, you cannot change it.\n <\/div>\n<\/div>\n<\/li>\n
                3. \n

                  Select a method to use to configure the new profile:<\/p>\n

                    \n
                  • \n

                    Automatically create a MySQL superuser via SSH<\/em> \u2014 Select this method to create the new profile manually.<\/p>\n<\/li>\n

                  • \n

                    Manually enter an existing MySQL superuser\u2019s credentials<\/em> \u2014 Select this method to manually enter the new profile\u2019s information. <\/p>\n

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

                      You must<\/strong> select this option if you use Amazon RDS.<\/p>\n<\/li>\n

                    • \n

                      To create a MySQL superuser, make certain that the user possesses the following privileges:<\/p>\n<\/li>\n<\/ul>\n

                      \n

                      Click to view the privilege list…<\/p>\n

                      \n
                      \n
                      \n
                      \n\n\n
                      \n
                       1\n<\/span> 2\n<\/span> 3\n<\/span> 4\n<\/span> 5\n<\/span> 6\n<\/span> 7\n<\/span> 8\n<\/span> 9\n<\/span>10\n<\/span>11\n<\/span>12\n<\/span>13\n<\/span>14\n<\/span>15\n<\/span>16\n<\/span>17\n<\/span>18\n<\/span>19\n<\/span>20\n<\/span>21\n<\/span><\/code><\/pre>\n<\/td>\n
                      		\n
                      SELECT\nALTER\nALTER ROUTINE\nCREATE\nCREATE ROUTINE\nCREATE TEMPORARY TABLES\nCREATE USER\nCREATE VIEW\nDELETE\nDROP\nEXECUTE\nEVENT\nINDEX\nINSERT\nREFERENCES\nRELOAD\nUPDATE\nSHOW DATABASES\nSHOW VIEW\nTRIGGER\nLOCK TABLES<\/code><\/pre>\n<\/td>\n<\/tr>\n<\/table>\n<\/div>\n<\/div><\/div>\n<\/p><\/div>\n<\/div>\n
                        \n
                      • Amazon RDS does not<\/strong> allow you to grant the Super privilege to users.<\/li>\n<\/ul><\/div>\n<\/div>\n
                        \n
                        Note:<\/div>\n
                        \n        If you use Amazon RDS, enter the username and password that you configured when you deployed your Amazon RDS instance.\n    <\/div>\n<\/div>\n<\/li>\n<\/ul>\n<\/li>\n
                      • \n
                        Enter the appropriate information for the configuration method that you selected.<\/p>\n
                          \n
                        • \n
                          Automatically create a MySQL superuser via SSH<\/strong><\/p>\n
                            \n
                          • \n
                            Host<\/em> \u2014 The MySQL server\u2019s IP address or hostname. <\/p>\n
                            \n
                            Warning:<\/div>\n
                            \n        You can enter a public or private IP address. However, make certain that the MySQL server can resolve the cPanel & WHM server\u2019s IP address to its fully-qualified hostname.\n    <\/div>\n<\/div>\n<\/li>\n
                          • \n
                            SSH Port<\/em> \u2014 The SSH service\u2019s port number. You must<\/strong> enter a port number between 1<\/code> and 65535<\/code>.<\/p>\n
                            \n
                            Note:<\/div>\n
                            \n        If the server resides behind a firewall, you will need to configure the firewall to allow traffic through the port that you select. For more information, read our How to Configure Your Firewall for cPanel & WHM Services documentation.\n    <\/div>\n<\/div>\n<\/li>\n
                          • \n
                            Username<\/em> \u2014 The username for the SSH connection.<\/p>\n<\/li>\n
                          • \n
                            Authentication Method<\/em> \u2014 Select the desired authentication method.<\/p>\n<\/li>\n
                          • \n
                            Password<\/em> \u2014 Use a password to authenticate. Enter your SSH password in the Password<\/em> text box.<\/p>\n<\/li>\n
                          • \n
                            SSH Key<\/em> \u2014 Use an SSH key to authenticate. Enter your SSH key\u2019s name in the SSH Key<\/em> text box.<\/p>\n<\/li>\n
                          • \n
                            Password<\/em> \u2014 The password for the SSH connection. <\/p>\n
                            \n
                            Note:<\/div>\n
                            \n        This setting only<\/strong> appears when you select the Password for the Authentication Method<\/em> setting.\n    <\/div>\n<\/div>\n<\/li>\n
                          • \n
                            SSH Key<\/em> \u2014 The name of the SSH key to use to log in to the remote server.<\/p>\n
                            \n
                            Note:<\/div>\n
                            \n
                              \n
                            • This setting only appears when you select the SSH Key for the Authentication Method setting<\/em>.<\/li>\n
                            • Use WHM\u2019s Manage Root\u2019s SSH Keys<\/em> interface (WHM >> Home >> Security >> Manage Root\u2019s SSH Keys<\/em>) to add SSH keys.
                              \n<\/li>\n<\/ul><\/div>\n<\/div>\n<\/li>\n<\/ul>\n<\/li>\n
                            • \n
                              Manually enter an existing MySQL superuser\u2019s credentials<\/strong><\/p>\n
                                \n
                              • \n
                                Host<\/em> \u2014 The MySQL server\u2019s IP address or hostname. <\/p>\n
                                \n
                                Warning:<\/div>\n
                                \n        You can enter a public or private IP address. However, make certain<\/strong> that the MySQL server can resolve the cPanel & WHM server\u2019s IP address to its fully-qualified hostname.\n    <\/div>\n<\/div>\n<\/li>\n
                              • \n
                                Port<\/em> \u2014 The MySQL server\u2019s port number. You must<\/strong> enter a port number between 1<\/code> and 65535<\/code>. <\/p>\n
                                \n
                                Note:<\/div>\n
                                \n        If the server resides behind a firewall, you will need to configure the firewall to allow traffic through the port that you select. For more information, read our How to Configure Your Firewall for cPanel & WHM Services documentation.\n    <\/div>\n<\/div>\n<\/li>\n
                              • \n
                                Username<\/em> \u2014 The MySQL superuser\u2019s username.<\/p>\n<\/li>\n
                              • \n
                                Password<\/em> \u2014 The MySQL superuser\u2019s password.<\/p>\n<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n
                              • \n
                                Click Save<\/em>.<\/p>\n<\/li>\n<\/ol>\n
                                \n
                                Remember:<\/div>\n
                                \n
                                For more information, read our Troubleshoot MySQL\u00ae Profiles documentation.<\/p>\n<\/p><\/div>\n<\/div>\n
                                Edit profile<\/h2>\n
                                To edit a MySQL profile, perform the following steps:<\/p>\n
                                  \n
                                1. \n
                                  Click the arrow icon next to the profile you wish to edit. A new interface will appear. <\/p>\n
                                  \n
                                  Note:<\/div>\n
                                  \n        You cannot<\/strong> change the profile\u2019s name. If you wish to use a different profile name for a connection, you must<\/strong> delete and recreate the profile with a new name.\n    <\/div>\n<\/div>\n<\/li>\n
                                2. \n
                                  If you wish to change the hostname, enter the new MySQL server\u2019s IP address or hostname in the Host text box. <\/p>\n
                                  \n
                                  Warning:<\/div>\n
                                  \n        You can enter a public or private IP address. However, make certain<\/strong> that the MySQL server can resolve the cPanel & WHM server\u2019s IP address to its fully-qualified hostname.\n    <\/div>\n<\/div>\n
                                  :<\/li>\n
                                3. \n
                                  If you wish to change the port number, enter the new port number in the Port<\/em> text box. <\/p>\n
                                  \n
                                  Note:<\/div>\n
                                  \n        If the server resides behind a firewall, you will need to configure the firewall to allow traffic through the port that you select. For more information, read our How to Configure Your Firewall for cPanel & WHM Services documentation.\n    <\/div>\n<\/div>\n<\/li>\n
                                4. \n
                                  If you wish to change the MySQL superuser\u2019s username for the connection, enter the new username in the Username<\/em> text box.<\/p>\n<\/li>\n
                                5. \n
                                  If you wish to change the MySQL superuser\u2019s password for the connection, enter the new password in the Password<\/em> text box.<\/p>\n<\/li>\n
                                6. \n
                                  Click Save<\/em> to save your changes, or click Cancel<\/em> to cancel the changes.<\/p>\n<\/li>\n<\/ol><\/div>\n","protected":false},"excerpt":{"rendered":"
                                  Valid for versions 88 through the latest version Version: 82 88 Overview This interface allows you to manage multiple MySQL\u00ae profiles. A profile defines the connection information for a local or remote MySQL server. You may wish to use a separate MySQL server if, for example, you manage particularly busy servers or servers with large …<\/p>\n","protected":false},"author":1,"featured_media":1002,"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\/1001"}],"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=1001"}],"version-history":[{"count":0,"href":"https:\/\/ssdsunucum.com\/blog\/wp-json\/wp\/v2\/posts\/1001\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/ssdsunucum.com\/blog\/wp-json\/wp\/v2\/media\/1002"}],"wp:attachment":[{"href":"https:\/\/ssdsunucum.com\/blog\/wp-json\/wp\/v2\/media?parent=1001"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ssdsunucum.com\/blog\/wp-json\/wp\/v2\/categories?post=1001"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ssdsunucum.com\/blog\/wp-json\/wp\/v2\/tags?post=1001"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}