{"id":10207,"date":"2020-09-18T10:38:43","date_gmt":"2020-09-18T10:38:43","guid":{"rendered":"https:\/\/www.milesweb.in\/hosting-faqs\/?p=10207"},"modified":"2026-02-26T18:55:09","modified_gmt":"2026-02-26T13:25:09","slug":"how-to-create-a-database-in-cpanel","status":"publish","type":"post","link":"https:\/\/www.milesweb.in\/hosting-faqs\/how-to-create-a-database-in-cpanel\/","title":{"rendered":"How To Create A Database In cPanel?"},"content":{"rendered":"\n

Making a MySQL database in cPanel is an easy operation. To make a new database, add a user, and grant the required privileges, follow the instructions below.<\/p>\n\n\n\n

Step 1: Sign into cPanel<\/h2>\n\n\n\n

Open your cPanel account.<\/p>\n\n\n\n

\"Sign<\/figure>\n\n\n\n

Locate the MySQL databases section of the main menu under the Databases category.<\/p>\n\n\n\n

\"new-database\"<\/figure>\n\n\n\n

Step 2: Create a New Database<\/h2>\n\n\n\n

Now input the name of your desired database in the Create New Database field.<\/p>\n\n\n\n

\"MySQL<\/figure>\n\n\n\n

To proceed, click on Create Database.<\/p>\n\n\n\n

Confirmatory messages appear, signaling that the database has indeed been successfully created.<\/p>\n\n\n\n

\"database-created\"<\/figure>\n\n\n\n

Note: It is important that after creating the database, the next step should be creating a user, and the database will be assigned to the user created.<\/p>\n\n\n\n

Step 3: Add New User to the Database<\/h2>\n\n\n\n
    \n
  • Located at the bottom of this page is the MySQL Users section.<\/li>\n\n\n\n
  • In the Add New User subsection, input the new username.<\/li>\n\n\n\n
  • Set a strong password using the Password Generator or manually.<\/li>\n\n\n\n
  • To create the user, click on Create User.<\/li>\n<\/ul>\n\n\n\n
    \"Add<\/figure>\n\n\n\n

    Step 4: Set Assign User to a Database<\/h2>\n\n\n\n
      \n
    • In the Add User to Database subsection:<\/li>\n\n\n\n
    • Choose the user from the dropdown menu.<\/li>\n\n\n\n
    • Select the database to which the user is to be assigned.<\/li>\n\n\n\n
    • Finally, click on Add.<\/li>\n<\/ul>\n\n\n\n
      \"Set<\/figure>\n\n\n\n

      Step 5: Append User Privileges<\/h2>\n\n\n\n

      In the following screen, select All Privileges or leave some out as you choose.<\/p>\n\n\n\n

      \"Append<\/figure>\n\n\n\n

      Click on the Make Changes button to save the settings.<\/p>\n\n\n\n

      \"save<\/figure>\n\n\n\n

      Your user and database are now ready and in place. You may now connect your website or application to the database with the credentials you’ve created.<\/p>\n","protected":false},"excerpt":{"rendered":"

      Making a MySQL database in cPanel is an easy operation. To make a new database, add a user, and grant the required privileges, follow the instructions below. Step 1: Sign into cPanel Open your cPanel account. Locate the MySQL databases section of the main menu under the Databases category. Step 2: Create a New Database […]<\/p>\n","protected":false},"author":4,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3047],"tags":[152,49,50,1170,205,469],"class_list":["post-10207","post","type-post","status-publish","format-standard","placeholder-for-hentry","category-databases-mysql-mariadb","tag-cpanel","tag-cpanel-control-panel","tag-cpanel-hosting-2","tag-database","tag-mysql","tag-mysql-database"],"yoast_head":"\nHow To Create A Database In cPanel?<\/title>\n<meta name=\"description\" content=\"Get easy steps for creating a database in cPanel.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.milesweb.in\/hosting-faqs\/how-to-create-a-database-in-cpanel\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How To Create A Database In cPanel?\" \/>\n<meta property=\"og:description\" content=\"Get easy steps for creating a database in cPanel.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.milesweb.in\/hosting-faqs\/how-to-create-a-database-in-cpanel\/\" \/>\n<meta property=\"og:site_name\" content=\"Web Hosting FAQs by MilesWeb\" \/>\n<meta property=\"article:published_time\" content=\"2020-09-18T10:38:43+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-02-26T13:25:09+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2025\/04\/sign-into-cpanel.png\" \/>\n\t<meta property=\"og:image:width\" content=\"442\" \/>\n\t<meta property=\"og:image:height\" content=\"397\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Ujwala\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Ujwala\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.milesweb.in\/hosting-faqs\/how-to-create-a-database-in-cpanel\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.milesweb.in\/hosting-faqs\/how-to-create-a-database-in-cpanel\/\"},\"author\":{\"name\":\"Ujwala\",\"@id\":\"https:\/\/www.milesweb.in\/hosting-faqs\/#\/schema\/person\/485f82549b85b9f4c82dc208c42964a8\"},\"headline\":\"How To Create A Database In cPanel?\",\"datePublished\":\"2020-09-18T10:38:43+00:00\",\"dateModified\":\"2026-02-26T13:25:09+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.milesweb.in\/hosting-faqs\/how-to-create-a-database-in-cpanel\/\"},\"wordCount\":257,\"commentCount\":0,\"image\":{\"@id\":\"https:\/\/www.milesweb.in\/hosting-faqs\/how-to-create-a-database-in-cpanel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2025\/04\/sign-into-cpanel.png\",\"keywords\":[\"cPanel\",\"cPanel control panel\",\"cPanel hosting\",\"database\",\"MySQL\",\"MySQL database\"],\"articleSection\":[\"Databases (MySQL \/ MariaDB)\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.milesweb.in\/hosting-faqs\/how-to-create-a-database-in-cpanel\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.milesweb.in\/hosting-faqs\/how-to-create-a-database-in-cpanel\/\",\"url\":\"https:\/\/www.milesweb.in\/hosting-faqs\/how-to-create-a-database-in-cpanel\/\",\"name\":\"How To Create A Database In cPanel?\",\"isPartOf\":{\"@id\":\"https:\/\/www.milesweb.in\/hosting-faqs\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.milesweb.in\/hosting-faqs\/how-to-create-a-database-in-cpanel\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.milesweb.in\/hosting-faqs\/how-to-create-a-database-in-cpanel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2025\/04\/sign-into-cpanel.png\",\"datePublished\":\"2020-09-18T10:38:43+00:00\",\"dateModified\":\"2026-02-26T13:25:09+00:00\",\"author\":{\"@id\":\"https:\/\/www.milesweb.in\/hosting-faqs\/#\/schema\/person\/485f82549b85b9f4c82dc208c42964a8\"},\"description\":\"Get easy steps for creating a database in cPanel.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.milesweb.in\/hosting-faqs\/how-to-create-a-database-in-cpanel\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.milesweb.in\/hosting-faqs\/how-to-create-a-database-in-cpanel\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.milesweb.in\/hosting-faqs\/how-to-create-a-database-in-cpanel\/#primaryimage\",\"url\":\"https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2025\/04\/sign-into-cpanel.png\",\"contentUrl\":\"https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2025\/04\/sign-into-cpanel.png\",\"width\":442,\"height\":397,\"caption\":\"Sign into cPanel\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.milesweb.in\/hosting-faqs\/how-to-create-a-database-in-cpanel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.milesweb.in\/hosting-faqs\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How To Create A Database In cPanel?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.milesweb.in\/hosting-faqs\/#website\",\"url\":\"https:\/\/www.milesweb.in\/hosting-faqs\/\",\"name\":\"Web Hosting FAQs by MilesWeb\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.milesweb.in\/hosting-faqs\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.milesweb.in\/hosting-faqs\/#\/schema\/person\/485f82549b85b9f4c82dc208c42964a8\",\"name\":\"Ujwala\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.milesweb.in\/hosting-faqs\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/3688a73ea9910afb426b453e227deb5300ca470f5518aac6c3b676a5b0acfee5?s=96&d=blank&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/3688a73ea9910afb426b453e227deb5300ca470f5518aac6c3b676a5b0acfee5?s=96&d=blank&r=g\",\"caption\":\"Ujwala\"},\"description\":\"My aim is to create enriching content on topics related to SEO, web hosting and social media. The idea is to elevate the readers to new levels of usability, accessibility and understanding.\",\"url\":\"https:\/\/www.milesweb.in\/hosting-faqs\/author\/ujwala\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How To Create A Database In cPanel?","description":"Get easy steps for creating a database in cPanel.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.milesweb.in\/hosting-faqs\/how-to-create-a-database-in-cpanel\/","og_locale":"en_US","og_type":"article","og_title":"How To Create A Database In cPanel?","og_description":"Get easy steps for creating a database in cPanel.","og_url":"https:\/\/www.milesweb.in\/hosting-faqs\/how-to-create-a-database-in-cpanel\/","og_site_name":"Web Hosting FAQs by MilesWeb","article_published_time":"2020-09-18T10:38:43+00:00","article_modified_time":"2026-02-26T13:25:09+00:00","og_image":[{"width":442,"height":397,"url":"https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2025\/04\/sign-into-cpanel.png","type":"image\/png"}],"author":"Ujwala","twitter_misc":{"Written by":"Ujwala","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.milesweb.in\/hosting-faqs\/how-to-create-a-database-in-cpanel\/#article","isPartOf":{"@id":"https:\/\/www.milesweb.in\/hosting-faqs\/how-to-create-a-database-in-cpanel\/"},"author":{"name":"Ujwala","@id":"https:\/\/www.milesweb.in\/hosting-faqs\/#\/schema\/person\/485f82549b85b9f4c82dc208c42964a8"},"headline":"How To Create A Database In cPanel?","datePublished":"2020-09-18T10:38:43+00:00","dateModified":"2026-02-26T13:25:09+00:00","mainEntityOfPage":{"@id":"https:\/\/www.milesweb.in\/hosting-faqs\/how-to-create-a-database-in-cpanel\/"},"wordCount":257,"commentCount":0,"image":{"@id":"https:\/\/www.milesweb.in\/hosting-faqs\/how-to-create-a-database-in-cpanel\/#primaryimage"},"thumbnailUrl":"https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2025\/04\/sign-into-cpanel.png","keywords":["cPanel","cPanel control panel","cPanel hosting","database","MySQL","MySQL database"],"articleSection":["Databases (MySQL \/ MariaDB)"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.milesweb.in\/hosting-faqs\/how-to-create-a-database-in-cpanel\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.milesweb.in\/hosting-faqs\/how-to-create-a-database-in-cpanel\/","url":"https:\/\/www.milesweb.in\/hosting-faqs\/how-to-create-a-database-in-cpanel\/","name":"How To Create A Database In cPanel?","isPartOf":{"@id":"https:\/\/www.milesweb.in\/hosting-faqs\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.milesweb.in\/hosting-faqs\/how-to-create-a-database-in-cpanel\/#primaryimage"},"image":{"@id":"https:\/\/www.milesweb.in\/hosting-faqs\/how-to-create-a-database-in-cpanel\/#primaryimage"},"thumbnailUrl":"https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2025\/04\/sign-into-cpanel.png","datePublished":"2020-09-18T10:38:43+00:00","dateModified":"2026-02-26T13:25:09+00:00","author":{"@id":"https:\/\/www.milesweb.in\/hosting-faqs\/#\/schema\/person\/485f82549b85b9f4c82dc208c42964a8"},"description":"Get easy steps for creating a database in cPanel.","breadcrumb":{"@id":"https:\/\/www.milesweb.in\/hosting-faqs\/how-to-create-a-database-in-cpanel\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.milesweb.in\/hosting-faqs\/how-to-create-a-database-in-cpanel\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.milesweb.in\/hosting-faqs\/how-to-create-a-database-in-cpanel\/#primaryimage","url":"https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2025\/04\/sign-into-cpanel.png","contentUrl":"https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2025\/04\/sign-into-cpanel.png","width":442,"height":397,"caption":"Sign into cPanel"},{"@type":"BreadcrumbList","@id":"https:\/\/www.milesweb.in\/hosting-faqs\/how-to-create-a-database-in-cpanel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.milesweb.in\/hosting-faqs\/"},{"@type":"ListItem","position":2,"name":"How To Create A Database In cPanel?"}]},{"@type":"WebSite","@id":"https:\/\/www.milesweb.in\/hosting-faqs\/#website","url":"https:\/\/www.milesweb.in\/hosting-faqs\/","name":"Web Hosting FAQs by MilesWeb","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.milesweb.in\/hosting-faqs\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.milesweb.in\/hosting-faqs\/#\/schema\/person\/485f82549b85b9f4c82dc208c42964a8","name":"Ujwala","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.milesweb.in\/hosting-faqs\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/3688a73ea9910afb426b453e227deb5300ca470f5518aac6c3b676a5b0acfee5?s=96&d=blank&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/3688a73ea9910afb426b453e227deb5300ca470f5518aac6c3b676a5b0acfee5?s=96&d=blank&r=g","caption":"Ujwala"},"description":"My aim is to create enriching content on topics related to SEO, web hosting and social media. The idea is to elevate the readers to new levels of usability, accessibility and understanding.","url":"https:\/\/www.milesweb.in\/hosting-faqs\/author\/ujwala\/"}]}},"_links":{"self":[{"href":"https:\/\/www.milesweb.in\/hosting-faqs\/wp-json\/wp\/v2\/posts\/10207","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.milesweb.in\/hosting-faqs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.milesweb.in\/hosting-faqs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.milesweb.in\/hosting-faqs\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/www.milesweb.in\/hosting-faqs\/wp-json\/wp\/v2\/comments?post=10207"}],"version-history":[{"count":5,"href":"https:\/\/www.milesweb.in\/hosting-faqs\/wp-json\/wp\/v2\/posts\/10207\/revisions"}],"predecessor-version":[{"id":19047,"href":"https:\/\/www.milesweb.in\/hosting-faqs\/wp-json\/wp\/v2\/posts\/10207\/revisions\/19047"}],"wp:attachment":[{"href":"https:\/\/www.milesweb.in\/hosting-faqs\/wp-json\/wp\/v2\/media?parent=10207"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.milesweb.in\/hosting-faqs\/wp-json\/wp\/v2\/categories?post=10207"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.milesweb.in\/hosting-faqs\/wp-json\/wp\/v2\/tags?post=10207"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}