{"id":1091,"date":"2025-07-15T11:20:00","date_gmt":"2025-07-15T10:20:00","guid":{"rendered":"https:\/\/www.4uhosting.co.uk\/articles\/knowledgebase\/manage-mysql-databases\/"},"modified":"2026-08-19T14:01:06","modified_gmt":"2026-08-19T13:01:06","slug":"manage-mysql-databases","status":"publish","type":"kb_article","link":"https:\/\/www.4uhosting.co.uk\/articles\/knowledgebase\/manage-mysql-databases\/","title":{"rendered":"How to Manage MySQL Databases in cPanel"},"content":{"rendered":"
\"Manage<\/a><\/figure>\n

Create a Database<\/h2>\n
    \n
  1. Go to Databases > Manage My Databases<\/strong>.<\/li>\n
  2. Enter the database name.<\/li>\n<\/ol>\n
    \"Create<\/a><\/figure>\n
      \n
    1. Click Create Database<\/strong>.<\/li>\n
    2. Click Go Back<\/strong> when cPanel confirms the database has been created.<\/li>\n<\/ol>\n

      Create a Database User<\/h2>\n
        \n
      1. Scroll to MySQL Users<\/strong>.<\/li>\n
      2. Enter a username.<\/li>\n
      3. Enter and confirm a strong password.<\/li>\n<\/ol>\n
        \"Create<\/a><\/figure>\n
          \n
        1. Click Create User<\/strong>.<\/li>\n
        2. Click Go Back<\/strong>.<\/li>\n<\/ol>\n

          Add a User to a Database<\/h2>\n
            \n
          1. Scroll to Add User To Database<\/strong>.<\/li>\n
          2. Choose the user.<\/li>\n
          3. Choose the database.<\/li>\n
          4. Click Add<\/strong>.<\/li>\n<\/ol>\n
            \"Database<\/a><\/figure>\n
              \n
            1. Choose the privileges the user needs.<\/li>\n
            2. Click Make Changes<\/strong>.<\/li>\n<\/ol>\n

              Change a Database User Password<\/h2>\n
                \n
              1. Scroll to Current Users<\/strong>.<\/li>\n
              2. Find the user.<\/li>\n
              3. Click Change Password<\/strong>.<\/li>\n
              4. Enter and confirm the new password.<\/li>\n
              5. Click Change Password<\/strong>.<\/li>\n<\/ol>\n

                Rename a Database<\/h2>\n
                  \n
                1. Scroll to Current Databases<\/strong>.<\/li>\n
                2. Find the database.<\/li>\n
                3. Click Rename<\/strong>.<\/li>\n
                4. Enter the new database name.<\/li>\n
                5. Confirm the change.<\/li>\n<\/ol>\n

                  Repair a Database<\/h2>\n
                    \n
                  1. Scroll to Modify Databases<\/strong>.<\/li>\n
                  2. Choose the database from Repair Database<\/strong>.<\/li>\n
                  3. Click Repair Database<\/strong>.<\/li>\n<\/ol>\n

                    Delete a Database or User<\/h2>\n
                      \n
                    1. Find the database or user you want to remove.<\/li>\n
                    2. Click Delete<\/strong>.<\/li>\n
                    3. Confirm the deletion.<\/li>\n<\/ol>\n

                      Notes<\/h2>\n
                        \n
                      • Removing a user from a database does not delete the database.<\/li>\n
                      • Deleting a database deletes the data inside it.<\/li>\n
                      • Take a backup before deleting or renaming an important database.<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"

                        Create a Database Go to Databases > Manage My Databases. Enter the database name. Click Create Database. Click Go Back when cPanel confirms the…<\/p>\n","protected":false},"author":1,"featured_media":0,"template":"","kb_category":[19],"class_list":["post-1091","kb_article","type-kb_article","status-publish","hentry","kb_category-cpanel-databases"],"_links":{"self":[{"href":"https:\/\/www.4uhosting.co.uk\/articles\/wp-json\/wp\/v2\/kb_article\/1091","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.4uhosting.co.uk\/articles\/wp-json\/wp\/v2\/kb_article"}],"about":[{"href":"https:\/\/www.4uhosting.co.uk\/articles\/wp-json\/wp\/v2\/types\/kb_article"}],"author":[{"embeddable":true,"href":"https:\/\/www.4uhosting.co.uk\/articles\/wp-json\/wp\/v2\/users\/1"}],"version-history":[{"count":2,"href":"https:\/\/www.4uhosting.co.uk\/articles\/wp-json\/wp\/v2\/kb_article\/1091\/revisions"}],"predecessor-version":[{"id":1280,"href":"https:\/\/www.4uhosting.co.uk\/articles\/wp-json\/wp\/v2\/kb_article\/1091\/revisions\/1280"}],"wp:attachment":[{"href":"https:\/\/www.4uhosting.co.uk\/articles\/wp-json\/wp\/v2\/media?parent=1091"}],"wp:term":[{"taxonomy":"kb_category","embeddable":true,"href":"https:\/\/www.4uhosting.co.uk\/articles\/wp-json\/wp\/v2\/kb_category?post=1091"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}