{"id":1092,"date":"2025-10-25T13:50:00","date_gmt":"2025-10-25T12:50:00","guid":{"rendered":"https:\/\/www.4uhosting.co.uk\/articles\/knowledgebase\/use-mysql-database-wizard\/"},"modified":"2026-08-19T14:00:54","modified_gmt":"2026-08-19T13:00:54","slug":"use-mysql-database-wizard","status":"publish","type":"kb_article","link":"https:\/\/www.4uhosting.co.uk\/articles\/knowledgebase\/use-mysql-database-wizard\/","title":{"rendered":"How to Use MySQL Database Wizard in cPanel"},"content":{"rendered":"
\"MySQL<\/a><\/figure>\n

Create the Database<\/h2>\n
    \n
  1. Go to Databases > MySQL Database Wizard<\/strong>.<\/li>\n
  2. Enter the database name.<\/li>\n<\/ol>\n
    \"Database<\/a><\/figure>\n
      \n
    1. Click Next Step<\/strong>.<\/li>\n<\/ol>\n

      Create the User<\/h2>\n
        \n
      1. Enter the database username.<\/li>\n
      2. Enter and confirm a strong password.<\/li>\n<\/ol>\n
        \"Create<\/a><\/figure>\n
          \n
        1. Click Create User<\/strong>.<\/li>\n<\/ol>\n

          Choose Privileges<\/h2>\n
            \n
          1. Tick All Privileges<\/strong> for a normal website database user.<\/li>\n
          2. Or choose only the privileges required.<\/li>\n<\/ol>\n
            \"MySQL<\/a><\/figure>\n
              \n
            1. Click Next Step<\/strong>.<\/li>\n<\/ol>\n

              Use the Database Details<\/h2>\n
                \n
              1. Copy the full database name.<\/li>\n
              2. Copy the full database username.<\/li>\n
              3. Use the password you created.<\/li>\n
              4. Set the database host to localhost<\/strong> unless your application says otherwise.<\/li>\n<\/ol>\n

                Notes<\/h2>\n
                  \n
                • MySQL Database Wizard is a guided version of the MySQL Databases screen.<\/li>\n
                • The full database name and username usually include your cPanel username as a prefix.<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"

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