{"id":432,"date":"2017-02-19T14:22:09","date_gmt":"2017-02-19T14:22:09","guid":{"rendered":"https:\/\/chemicloud.com\/kb\/?post_type=article&#038;p=432"},"modified":"2020-03-25T14:42:28","modified_gmt":"2020-03-25T14:42:28","slug":"create-mysql-database","status":"publish","type":"ht_kb","link":"https:\/\/chemicloud.com\/kb\/article\/create-mysql-database\/","title":{"rendered":"How to Create a MySQL Database in cPanel"},"content":{"rendered":"<p>You can easily create a MySQL database thanks to the\u00a0MySQL Database Wizard included in cPanel which walks you through each of these steps. Just follow these steps to create the database:<\/p>\n<p><strong>1)<\/strong>\u00a0<a style=\"box-sizing: border-box; text-decoration: none; outline: none; background: none; color: #2a94e5; line-height: 1; display: inline-block;\" href=\"https:\/\/chemicloud.com\/kb\/article\/login-cpanel-whm-account\/\" target=\"_blank\" rel=\"noopener noreferrer\">Log into cPanel<\/a>.<\/p>\n<p><strong>2)<\/strong> Look for the &#8220;<strong>DATABASES<\/strong>&#8221; section and click on\u00a0<strong>&#8220;MySQL\u00ae Database Wizard &#8220;<\/strong>.<\/p>\n<p><strong>3)<\/strong> In the next window enter the name of your database and hit <strong>&#8220;Next Step&#8221;<\/strong>.<\/p>\n<p><strong>4)<\/strong> Here you&#8217;ll need to choose the username and enter the password you want to be associated with the user in both fields. You can also click the <strong>&#8220;Password Generator&#8221;<\/strong> and cPanel generates a random, strong password for your username.<\/p>\n<p><strong>5)<\/strong> On the next page, you&#8217;ll assign privileges for the user to the database. If you want to assign full privileges for the user just check the box next to &#8220;<strong>All Privileges&#8221;<\/strong> and then click Next Step.<\/p>\n<p><strong>6)<\/strong> You&#8217;ll see a confirmation message that the database and username have been created.<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>You can easily create a MySQL database thanks to the\u00a0MySQL Database Wizard included in cPanel which walks you through each of these steps. Just follow these steps to create the database: 1)\u00a0Log into cPanel. 2) Look for the &#8220;DATABASES&#8221; section and click on\u00a0&#8220;MySQL\u00ae Database Wizard &#8220;. 3) In the next&#8230;<\/p>\n","protected":false},"author":10,"featured_media":0,"comment_status":"open","ping_status":"closed","template":"","format":"standard","meta":{"_crdt_document":"","footnotes":""},"ht-kb-category":[38],"ht-kb-tag":[118,122,50],"class_list":["post-432","ht_kb","type-ht_kb","status-publish","format-standard","hentry","ht_kb_category-mysql","ht_kb_tag-create","ht_kb_tag-database","ht_kb_tag-mysql"],"_links":{"self":[{"href":"https:\/\/chemicloud.com\/kb\/wp-json\/wp\/v2\/ht-kb\/432","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/chemicloud.com\/kb\/wp-json\/wp\/v2\/ht-kb"}],"about":[{"href":"https:\/\/chemicloud.com\/kb\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"https:\/\/chemicloud.com\/kb\/wp-json\/wp\/v2\/users\/10"}],"replies":[{"embeddable":true,"href":"https:\/\/chemicloud.com\/kb\/wp-json\/wp\/v2\/comments?post=432"}],"version-history":[{"count":3,"href":"https:\/\/chemicloud.com\/kb\/wp-json\/wp\/v2\/ht-kb\/432\/revisions"}],"predecessor-version":[{"id":2142,"href":"https:\/\/chemicloud.com\/kb\/wp-json\/wp\/v2\/ht-kb\/432\/revisions\/2142"}],"wp:attachment":[{"href":"https:\/\/chemicloud.com\/kb\/wp-json\/wp\/v2\/media?parent=432"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/chemicloud.com\/kb\/wp-json\/wp\/v2\/ht-kb-category?post=432"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/chemicloud.com\/kb\/wp-json\/wp\/v2\/ht-kb-tag?post=432"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}