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

Create a MySQL Database<\/h2>\n
    \n
  1. Go to Databases > MySQL 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>.<\/li>\n<\/ol>\n

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

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

          Create a MySQL User<\/h2>\n
            \n
          1. Scroll to MySQL Users<\/strong>.<\/li>\n
          2. Enter the 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. Select the user.<\/li>\n
              3. Select the database.<\/li>\n
              4. Click Add<\/strong>.<\/li>\n<\/ol>\n
                \"MySQL<\/a><\/figure>\n
                  \n
                1. Tick the privileges the user needs.<\/li>\n
                2. Click Make Changes<\/strong>.<\/li>\n<\/ol>\n

                  Remove a User from a Database<\/h2>\n
                    \n
                  1. Scroll to Current Databases<\/strong>.<\/li>\n
                  2. Find the database.<\/li>\n
                  3. Find the user under that database.<\/li>\n
                  4. Click the remove option next to the user.<\/li>\n
                  5. Confirm the change.<\/li>\n<\/ol>\n

                    Delete a Database<\/h2>\n
                      \n
                    1. Scroll to Current Databases<\/strong>.<\/li>\n
                    2. Find the database.<\/li>\n
                    3. Click Delete<\/strong>.<\/li>\n
                    4. Confirm the deletion.<\/li>\n<\/ol>\n

                      Notes<\/h2>\n
                        \n
                      • Most websites need a database, a database user, and privileges linking the two together.<\/li>\n
                      • Keep database passwords somewhere secure.<\/li>\n
                      • Do not delete a database unless you are certain it is no longer needed.<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"

                        Create a MySQL Database Go to Databases > MySQL Databases. Enter the database name. Click Create Database. Click Go Back. Check a Database Find…<\/p>\n","protected":false},"author":1,"featured_media":0,"template":"","kb_category":[19],"class_list":["post-1093","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\/1093","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\/1093\/revisions"}],"predecessor-version":[{"id":1278,"href":"https:\/\/www.4uhosting.co.uk\/articles\/wp-json\/wp\/v2\/kb_article\/1093\/revisions\/1278"}],"wp:attachment":[{"href":"https:\/\/www.4uhosting.co.uk\/articles\/wp-json\/wp\/v2\/media?parent=1093"}],"wp:term":[{"taxonomy":"kb_category","embeddable":true,"href":"https:\/\/www.4uhosting.co.uk\/articles\/wp-json\/wp\/v2\/kb_category?post=1093"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}