{"id":8216,"date":"2020-09-18T10:39:09","date_gmt":"2020-09-18T10:39:09","guid":{"rendered":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/?p=8216"},"modified":"2025-04-07T10:58:04","modified_gmt":"2025-04-07T09:58:04","slug":"how-to-create-a-database-in-cpanel","status":"publish","type":"post","link":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-to-create-a-database-in-cpanel\/","title":{"rendered":"How To Create A Database In cPanel?"},"content":{"rendered":"\n<p>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<h2 class=\"wp-block-heading\">Step 1: Sign into cPanel<\/h2>\n\n\n\n<p>Open your cPanel account.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"442\" height=\"397\" src=\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2020\/09\/sign-into-cpanel.png\" alt=\"Sign into cPanel\" class=\"wp-image-16559\"\/><\/figure>\n\n\n\n<p>Locate the MySQL databases section of the main menu under the Databases category.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1906\" height=\"915\" src=\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2020\/09\/new-database.png\" alt=\"new-database\" class=\"wp-image-16561\"\/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">Step 2: Create a New Database<\/h2>\n\n\n\n<p>Now input the name of your desired database in the Create New Database field.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1348\" height=\"638\" src=\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2020\/09\/mysql-databases-section.png\" alt=\"MySQL databases section\" class=\"wp-image-16560\"\/><\/figure>\n\n\n\n<p>To proceed, click on Create Database.<\/p>\n\n\n\n<p>Confirmatory messages appear, signaling that the database has indeed been successfully created.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1093\" height=\"295\" src=\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2020\/09\/database-created.png\" alt=\"database-created\" class=\"wp-image-16562\"\/><\/figure>\n\n\n\n<p>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<h2 class=\"wp-block-heading\">Step 3: Add New User to the Database<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Located at the bottom of this page is the MySQL Users section.<\/li>\n\n\n\n<li>In the Add New User subsection, input the new username.<\/li>\n\n\n\n<li>Set a strong password using the Password Generator or manually.<\/li>\n\n\n\n<li>To create the user, click on Create User.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1104\" height=\"560\" src=\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2020\/09\/add-new-user-to-the-database-1.png\" alt=\"Add New User to the Database\" class=\"wp-image-16566\"\/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">Step 4: Set Assign User to a Database<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>In the Add User to Database subsection:<\/li>\n\n\n\n<li>Choose the user from the dropdown menu.<\/li>\n\n\n\n<li>Select the database to which the user is to be assigned.<\/li>\n\n\n\n<li>Finally, click on Add.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1016\" height=\"336\" src=\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2020\/09\/add-user-to-a-database.png\" alt=\"Set Assign User to a Database\" class=\"wp-image-16568\"\/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">Step 5: Append User Privileges<\/h2>\n\n\n\n<p>In the following screen, select All Privileges or leave some out as you choose.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"828\" height=\"498\" src=\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2020\/09\/append-user-privileges.png\" alt=\"Append User Privileges\" class=\"wp-image-16570\"\/><\/figure>\n\n\n\n<p>Click on the Make Changes button to save the settings.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1103\" height=\"368\" src=\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2020\/09\/save-the-settings.png\" alt=\"save the settings\" class=\"wp-image-16572\"\/><\/figure>\n\n\n\n<p>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&#8217;ve created.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>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 [&hellip;]<\/p>\n","protected":false},"author":4,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[9],"tags":[152,49,50,1152,205,471],"class_list":["post-8216","post","type-post","status-publish","format-standard","placeholder-for-hentry","category-cpanel-faq","tag-cpanel","tag-cpanel-control-panel","tag-cpanel-hosting-2","tag-database","tag-mysql","tag-mysql-database"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.2 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How 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.co.uk\/hosting-faqs\/how-to-create-a-database-in-cpanel\/\" \/>\n<meta property=\"og:locale\" content=\"en_GB\" \/>\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.co.uk\/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:39:09+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-04-07T09:58:04+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2020\/09\/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=\"Estimated 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\":\"WebPage\",\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-to-create-a-database-in-cpanel\/\",\"url\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-to-create-a-database-in-cpanel\/\",\"name\":\"How To Create A Database In cPanel?\",\"isPartOf\":{\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-to-create-a-database-in-cpanel\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-to-create-a-database-in-cpanel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2020\/09\/sign-into-cpanel.png\",\"datePublished\":\"2020-09-18T10:39:09+00:00\",\"dateModified\":\"2025-04-07T09:58:04+00:00\",\"author\":{\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#\/schema\/person\/485f82549b85b9f4c82dc208c42964a8\"},\"description\":\"Get easy steps for creating a database in cPanel.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-to-create-a-database-in-cpanel\/#breadcrumb\"},\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-to-create-a-database-in-cpanel\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-to-create-a-database-in-cpanel\/#primaryimage\",\"url\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2020\/09\/sign-into-cpanel.png\",\"contentUrl\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2020\/09\/sign-into-cpanel.png\",\"width\":442,\"height\":397,\"caption\":\"Sign into cPanel\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-to-create-a-database-in-cpanel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How To Create A Database In cPanel?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#website\",\"url\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/\",\"name\":\"Web Hosting FAQs by MilesWeb\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-GB\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#\/schema\/person\/485f82549b85b9f4c82dc208c42964a8\",\"name\":\"Ujwala\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/8d26ea4b9b2d83ae90b67f6bf5eefbca?s=96&d=blank&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/8d26ea4b9b2d83ae90b67f6bf5eefbca?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.co.uk\/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.co.uk\/hosting-faqs\/how-to-create-a-database-in-cpanel\/","og_locale":"en_GB","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.co.uk\/hosting-faqs\/how-to-create-a-database-in-cpanel\/","og_site_name":"Web Hosting FAQs by MilesWeb","article_published_time":"2020-09-18T10:39:09+00:00","article_modified_time":"2025-04-07T09:58:04+00:00","og_image":[{"width":442,"height":397,"url":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2020\/09\/sign-into-cpanel.png","type":"image\/png"}],"author":"Ujwala","twitter_misc":{"Written by":"Ujwala","Estimated reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-to-create-a-database-in-cpanel\/","url":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-to-create-a-database-in-cpanel\/","name":"How To Create A Database In cPanel?","isPartOf":{"@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-to-create-a-database-in-cpanel\/#primaryimage"},"image":{"@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-to-create-a-database-in-cpanel\/#primaryimage"},"thumbnailUrl":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2020\/09\/sign-into-cpanel.png","datePublished":"2020-09-18T10:39:09+00:00","dateModified":"2025-04-07T09:58:04+00:00","author":{"@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#\/schema\/person\/485f82549b85b9f4c82dc208c42964a8"},"description":"Get easy steps for creating a database in cPanel.","breadcrumb":{"@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-to-create-a-database-in-cpanel\/#breadcrumb"},"inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-to-create-a-database-in-cpanel\/"]}]},{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-to-create-a-database-in-cpanel\/#primaryimage","url":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2020\/09\/sign-into-cpanel.png","contentUrl":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2020\/09\/sign-into-cpanel.png","width":442,"height":397,"caption":"Sign into cPanel"},{"@type":"BreadcrumbList","@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/how-to-create-a-database-in-cpanel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/"},{"@type":"ListItem","position":2,"name":"How To Create A Database In cPanel?"}]},{"@type":"WebSite","@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#website","url":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/","name":"Web Hosting FAQs by MilesWeb","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-GB"},{"@type":"Person","@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#\/schema\/person\/485f82549b85b9f4c82dc208c42964a8","name":"Ujwala","image":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/8d26ea4b9b2d83ae90b67f6bf5eefbca?s=96&d=blank&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/8d26ea4b9b2d83ae90b67f6bf5eefbca?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.co.uk\/hosting-faqs\/author\/ujwala\/"}]}},"views":448,"_links":{"self":[{"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/posts\/8216","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/comments?post=8216"}],"version-history":[{"count":6,"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/posts\/8216\/revisions"}],"predecessor-version":[{"id":16573,"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/posts\/8216\/revisions\/16573"}],"wp:attachment":[{"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/media?parent=8216"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/categories?post=8216"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/tags?post=8216"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}