{"id":24936,"date":"2022-02-02T14:58:34","date_gmt":"2022-02-02T14:58:34","guid":{"rendered":"https:\/\/1-grid.com\/knowledge\/how-to-setup-a-database-using-the-mysql-database-wizard-in-cpanel\/"},"modified":"2023-08-31T08:53:19","modified_gmt":"2023-08-31T08:53:19","slug":"how-to-setup-a-database-using-the-mysql-database-wizard-in-cpanel","status":"publish","type":"ht_kb","link":"https:\/\/1grid.co.za\/knowledge\/how-to-setup-a-database-using-the-mysql-database-wizard-in-cpanel\/","title":{"rendered":"How to Setup a Database using the MySQL Database Wizard in cPanel"},"content":{"rendered":"\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p class=\"has-black-color has-text-color\">This article will show you How to Setup a Database using the MySQL Database Wizard in cPanel&nbsp;<\/p>\n<\/blockquote>\n\n\n\n<p><\/p>\n\n\n\n<p class=\"has-black-color has-text-color\"><strong>Step 1.<\/strong> Log into <strong><a href=\"https:\/\/1-grid.com\/knowledge\/how-to-log-in-to-cpanel-via-your-1-grid-customer-zone\/\">Cpanel<\/a> <\/strong><\/p>\n\n\n\n<p><\/p>\n\n\n\n<p><\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/s3.amazonaws.com\/cdn.freshdesk.com\/data\/helpdesk\/attachments\/production\/33092595781\/original\/clggMLCUSVYYYMSyIbo_7xc04IrhUoYIXA.png?1678165611\" alt=\"\" style=\"width:231px;height:358px\" width=\"231\" height=\"358\"\/><\/figure>\n<\/div>\n\n\n<p><\/p>\n\n\n\n<p class=\"has-black-color has-text-color\"><strong>Step 2.<\/strong> Click on <strong>MySQL database wizard<\/strong> <\/p>\n\n\n\n<p><\/p>\n\n\n\n<p><\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/s3.amazonaws.com\/cdn.freshdesk.com\/data\/helpdesk\/attachments\/production\/33093803154\/original\/Fki1TP-FMfyr89ilph0SIFjUL86jyNr26w.png?1680083270\" alt=\"\" style=\"width:508px;height:119px\" width=\"508\" height=\"119\"\/><\/figure>\n<\/div>\n\n\n<p><\/p>\n\n\n\n<p><\/p>\n\n\n\n<p class=\"has-black-color has-text-color\"><strong>Step 3.<\/strong> Enter the name of the new database, Then click <strong>Next Step<\/strong>.<\/p>\n\n\n\n<p><\/p>\n\n\n\n<p><\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/s3.amazonaws.com\/cdn.freshdesk.com\/data\/helpdesk\/attachments\/production\/33093803270\/original\/gQdSHUv9D73sYkJmzPJ372bs10bv48Tb-Q.png?1680083430\" alt=\"\" style=\"width:474px;height:249px\" width=\"474\" height=\"249\"\/><\/figure>\n<\/div>\n\n\n<p><\/p>\n\n\n\n<p class=\"has-black-color has-text-color\"><strong>Step 4.<\/strong> Enter the <strong>Username and Password<\/strong> then click <strong>Create User<\/strong> <\/p>\n\n\n\n<p><\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/s3.amazonaws.com\/cdn.freshdesk.com\/data\/helpdesk\/attachments\/production\/33093803427\/original\/eaeSxymKfv3vufn5TLeb6ZUuqNCR3Pa_UQ.png?1680083620\" alt=\"\" style=\"width:391px;height:319px\" width=\"391\" height=\"319\"\/><\/figure>\n<\/div>\n\n\n<p><\/p>\n\n\n\n<p><\/p>\n\n\n\n<p class=\"has-black-color has-text-color\"><strong>Step 5.<\/strong> Select <strong>All Privileges&#8217; <\/strong>then click Next Step.<\/p>\n\n\n\n<p><\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/s3.amazonaws.com\/cdn.freshdesk.com\/data\/helpdesk\/attachments\/production\/33093803555\/original\/oKMbXxtcMUW9ghmSzjBBwAqsNva4M8ZY_g.png?1680083782\" alt=\"\" style=\"width:409px;height:292px\" width=\"409\" height=\"292\"\/><\/figure>\n<\/div>\n\n\n<p><\/p>\n\n\n\n<p><\/p>\n\n\n\n<p class=\"has-black-color has-text-color\"><strong>Step 6.<\/strong> That&#8217;s it! My SQL database has been created and the new user added to the database. The database name, username and password will all be needed for scripts and need to connect to the database. Click on <strong>Return home <\/strong><\/p>\n\n\n\n<p><\/p>\n\n\n\n<p><\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/s3.amazonaws.com\/cdn.freshdesk.com\/data\/helpdesk\/attachments\/production\/33093803608\/original\/r_0pnBK6PHS7D1mgs4yfYfppF7llDKIRFQ.png?1680083891\" alt=\"\" style=\"width:381px;height:269px\" width=\"381\" height=\"269\"\/><\/figure>\n<\/div>\n\n\n<p><\/p>\n\n\n\n<p><\/p>\n\n\n\n<p class=\"has-black-color has-text-color\"><strong>Step 7.<\/strong> Now click the <strong>MySQL Database<\/strong> icon on the main page <\/p>\n\n\n\n<p><\/p>\n\n\n\n<p><\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/s3.amazonaws.com\/cdn.freshdesk.com\/data\/helpdesk\/attachments\/production\/33093803875\/original\/4y4lG9kIl0EsOomykCXM5C35dYw9Lo1fwg.png?1680084262\" alt=\"\" style=\"width:483px;height:117px\" width=\"483\" height=\"117\"\/><\/figure>\n<\/div>\n\n\n<p><\/p>\n\n\n\n<p><\/p>\n\n\n\n<p class=\"has-black-color has-text-color\"><strong>Step 8.<\/strong> Here you can see the new database you just setup<\/p>\n\n\n\n<p class=\"has-black-color has-text-color\"> <\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/s3.amazonaws.com\/cdn.freshdesk.com\/data\/helpdesk\/attachments\/production\/33093804008\/original\/MPzD0QWRHcoo2jd4iqZV2BDVk2N1p60XMg.png?1680084401\" alt=\"\" style=\"width:521px;height:146px\" width=\"521\" height=\"146\"\/><\/figure>\n<\/div>\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>This article will show you How to Setup a Database using the MySQL Database Wizard in cPanel&nbsp; Step 1. Log into Cpanel Step 2. Click on MySQL database wizard Step 3. Enter the name of the new database, Then click Next Step. Step 4. Enter the Username and Password then&#8230;<\/p>\n","protected":false},"author":21,"comment_status":"closed","ping_status":"closed","template":"","format":"standard","meta":{"inline_featured_image":false,"footnotes":""},"ht-kb-category":[1198],"ht-kb-tag":[233,238,270,480,662,908,1147],"class_list":["post-24936","ht_kb","type-ht_kb","status-publish","format-standard","hentry","ht_kb_category-cpanel","ht_kb_tag-control-panel","ht_kb_tag-cpanel","ht_kb_tag-database","ht_kb_tag-how-to","ht_kb_tag-mysql","ht_kb_tag-setup","ht_kb_tag-wizard"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v22.0 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>1-grid Knowledge Base - 1-grid Knowledge Base -<\/title>\n<meta name=\"description\" content=\"This article will show you How to Setup a Database using the MySQL Database Wizard in cPanel\u00a01-grid Knowledge Base - 1-grid Knowledge Base\" \/>\n<meta name=\"robots\" content=\"noindex, follow\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"1-grid Knowledge Base - 1-grid Knowledge Base -\" \/>\n<meta property=\"og:description\" content=\"This article will show you How to Setup a Database using the MySQL Database Wizard in cPanel\u00a01-grid Knowledge Base - 1-grid Knowledge Base\" \/>\n<meta property=\"og:url\" content=\"https:\/\/1grid.co.za\/knowledge\/how-to-setup-a-database-using-the-mysql-database-wizard-in-cpanel\/\" \/>\n<meta property=\"og:site_name\" content=\"1-grid Knowledge Base\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/1grid.co.za\/\" \/>\n<meta property=\"article:modified_time\" content=\"2023-08-31T08:53:19+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/s3.amazonaws.com\/cdn.freshdesk.com\/data\/helpdesk\/attachments\/production\/33092595781\/original\/clggMLCUSVYYYMSyIbo_7xc04IrhUoYIXA.png?1678165611\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:site\" content=\"@1grid_hosting\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/1grid.co.za\/knowledge\/how-to-setup-a-database-using-the-mysql-database-wizard-in-cpanel\/\",\"url\":\"https:\/\/1grid.co.za\/knowledge\/how-to-setup-a-database-using-the-mysql-database-wizard-in-cpanel\/\",\"name\":\"1-grid Knowledge Base - 1-grid Knowledge Base -\",\"isPartOf\":{\"@id\":\"https:\/\/1grid.co.za\/knowledge\/#website\"},\"datePublished\":\"2022-02-02T14:58:34+00:00\",\"dateModified\":\"2023-08-31T08:53:19+00:00\",\"description\":\"This article will show you How to Setup a Database using the MySQL Database Wizard in cPanel\u00a01-grid Knowledge Base - 1-grid Knowledge Base\",\"breadcrumb\":{\"@id\":\"https:\/\/1grid.co.za\/knowledge\/how-to-setup-a-database-using-the-mysql-database-wizard-in-cpanel\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/1grid.co.za\/knowledge\/how-to-setup-a-database-using-the-mysql-database-wizard-in-cpanel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/1grid.co.za\/knowledge\/how-to-setup-a-database-using-the-mysql-database-wizard-in-cpanel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/1grid.co.za\/knowledge\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to Setup a Database using the MySQL Database Wizard in cPanel\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/1grid.co.za\/knowledge\/#website\",\"url\":\"https:\/\/1grid.co.za\/knowledge\/\",\"name\":\"1-Grid Domain Hosting Knowledge Base\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/1grid.co.za\/knowledge\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/1grid.co.za\/knowledge\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/1grid.co.za\/knowledge\/#organization\",\"name\":\"1-Grid Domain Hosting Knowledge Base\",\"url\":\"https:\/\/1grid.co.za\/knowledge\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/1grid.co.za\/knowledge\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/1grid.co.za\/knowledge\/wp-content\/uploads\/2023\/01\/1-grid-logo-color.svg\",\"contentUrl\":\"https:\/\/1grid.co.za\/knowledge\/wp-content\/uploads\/2023\/01\/1-grid-logo-color.svg\",\"width\":100,\"height\":100,\"caption\":\"1-Grid Domain Hosting Knowledge Base\"},\"image\":{\"@id\":\"https:\/\/1grid.co.za\/knowledge\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/1grid.co.za\/\",\"https:\/\/twitter.com\/1grid_hosting\",\"https:\/\/www.instagram.com\/1grid_hosting\/\",\"https:\/\/za.linkedin.com\/company\/1-grid\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"1-grid Knowledge Base - 1-grid Knowledge Base -","description":"This article will show you How to Setup a Database using the MySQL Database Wizard in cPanel\u00a01-grid Knowledge Base - 1-grid Knowledge Base","robots":{"index":"noindex","follow":"follow"},"og_locale":"en_US","og_type":"article","og_title":"1-grid Knowledge Base - 1-grid Knowledge Base -","og_description":"This article will show you How to Setup a Database using the MySQL Database Wizard in cPanel\u00a01-grid Knowledge Base - 1-grid Knowledge Base","og_url":"https:\/\/1grid.co.za\/knowledge\/how-to-setup-a-database-using-the-mysql-database-wizard-in-cpanel\/","og_site_name":"1-grid Knowledge Base","article_publisher":"https:\/\/www.facebook.com\/1grid.co.za\/","article_modified_time":"2023-08-31T08:53:19+00:00","og_image":[{"url":"https:\/\/s3.amazonaws.com\/cdn.freshdesk.com\/data\/helpdesk\/attachments\/production\/33092595781\/original\/clggMLCUSVYYYMSyIbo_7xc04IrhUoYIXA.png?1678165611"}],"twitter_card":"summary_large_image","twitter_site":"@1grid_hosting","twitter_misc":{"Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/1grid.co.za\/knowledge\/how-to-setup-a-database-using-the-mysql-database-wizard-in-cpanel\/","url":"https:\/\/1grid.co.za\/knowledge\/how-to-setup-a-database-using-the-mysql-database-wizard-in-cpanel\/","name":"1-grid Knowledge Base - 1-grid Knowledge Base -","isPartOf":{"@id":"https:\/\/1grid.co.za\/knowledge\/#website"},"datePublished":"2022-02-02T14:58:34+00:00","dateModified":"2023-08-31T08:53:19+00:00","description":"This article will show you How to Setup a Database using the MySQL Database Wizard in cPanel\u00a01-grid Knowledge Base - 1-grid Knowledge Base","breadcrumb":{"@id":"https:\/\/1grid.co.za\/knowledge\/how-to-setup-a-database-using-the-mysql-database-wizard-in-cpanel\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/1grid.co.za\/knowledge\/how-to-setup-a-database-using-the-mysql-database-wizard-in-cpanel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/1grid.co.za\/knowledge\/how-to-setup-a-database-using-the-mysql-database-wizard-in-cpanel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/1grid.co.za\/knowledge\/"},{"@type":"ListItem","position":2,"name":"How to Setup a Database using the MySQL Database Wizard in cPanel"}]},{"@type":"WebSite","@id":"https:\/\/1grid.co.za\/knowledge\/#website","url":"https:\/\/1grid.co.za\/knowledge\/","name":"1-Grid Domain Hosting Knowledge Base","description":"","publisher":{"@id":"https:\/\/1grid.co.za\/knowledge\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/1grid.co.za\/knowledge\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/1grid.co.za\/knowledge\/#organization","name":"1-Grid Domain Hosting Knowledge Base","url":"https:\/\/1grid.co.za\/knowledge\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/1grid.co.za\/knowledge\/#\/schema\/logo\/image\/","url":"https:\/\/1grid.co.za\/knowledge\/wp-content\/uploads\/2023\/01\/1-grid-logo-color.svg","contentUrl":"https:\/\/1grid.co.za\/knowledge\/wp-content\/uploads\/2023\/01\/1-grid-logo-color.svg","width":100,"height":100,"caption":"1-Grid Domain Hosting Knowledge Base"},"image":{"@id":"https:\/\/1grid.co.za\/knowledge\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/1grid.co.za\/","https:\/\/twitter.com\/1grid_hosting","https:\/\/www.instagram.com\/1grid_hosting\/","https:\/\/za.linkedin.com\/company\/1-grid"]}]}},"_links":{"self":[{"href":"https:\/\/1grid.co.za\/knowledge\/wp-json\/wp\/v2\/ht-kb\/24936","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/1grid.co.za\/knowledge\/wp-json\/wp\/v2\/ht-kb"}],"about":[{"href":"https:\/\/1grid.co.za\/knowledge\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"https:\/\/1grid.co.za\/knowledge\/wp-json\/wp\/v2\/users\/21"}],"replies":[{"embeddable":true,"href":"https:\/\/1grid.co.za\/knowledge\/wp-json\/wp\/v2\/comments?post=24936"}],"version-history":[{"count":3,"href":"https:\/\/1grid.co.za\/knowledge\/wp-json\/wp\/v2\/ht-kb\/24936\/revisions"}],"predecessor-version":[{"id":32963,"href":"https:\/\/1grid.co.za\/knowledge\/wp-json\/wp\/v2\/ht-kb\/24936\/revisions\/32963"}],"wp:attachment":[{"href":"https:\/\/1grid.co.za\/knowledge\/wp-json\/wp\/v2\/media?parent=24936"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/1grid.co.za\/knowledge\/wp-json\/wp\/v2\/ht-kb-category?post=24936"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/1grid.co.za\/knowledge\/wp-json\/wp\/v2\/ht-kb-tag?post=24936"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}