{"id":1548,"date":"2021-08-31T12:33:53","date_gmt":"2021-08-31T12:33:53","guid":{"rendered":"https:\/\/ownwebservers.com\/kb\/?p=1548"},"modified":"2021-08-31T12:39:21","modified_gmt":"2021-08-31T12:39:21","slug":"how-to-create-a-mysql-database-using-the-cpanel-database-wizard","status":"publish","type":"post","link":"https:\/\/ownwebservers.com\/kb\/how-to-create-a-mysql-database-using-the-cpanel-database-wizard\/","title":{"rendered":"How to Create a MySQL Database Using the cPanel Database Wizard"},"content":{"rendered":"

MySQL databases are the way to manage the information required to control your web site. They’re an important demand for several web site platforms, like WordPress and Magento.<\/p>\n

In this tutorial, we\u2019ll show you the way to create a new MySQL database and originated a username and Password for it using the cPanel Database Wizard.<\/p>\n

1. Log into your cPanel <\/strong>account using Username and Password.<\/p>\n

2. Scroll down to the Databases<\/strong> section and click on the MySQL databases Wizard<\/strong> icon.<\/p>\n

3. In the Create a Database<\/strong> field, type a name for the database and then click on Next Step<\/strong>.<\/p>\n

\"database-1\"<\/p>\n

4. After giving name to database, in the next step, you will need to create a username and password<\/strong> for the database.<\/p>\n

\"database-2\"<\/p>\n

5. In the Username field<\/strong>, enter the username.<\/p>\n

6. Now create a strong password and enter it into the Password<\/strong> and the Password (Again)<\/strong> fields. If required, use the Password Generator<\/strong>.<\/p>\n

7. After that click Create User<\/strong>.<\/p>\n

8. As the User gets created, in the next section, you will decide which privileges<\/strong> the user has.<\/p>\n

\"database-3\"<\/p>\n

9. If you are the web site administrator and are creating the database for yourself to manage, check the ALL PRIVILEGES<\/strong> box at the top of the page.<\/p>\n

If you are creating a username for someone else, only check the privileges you wish them to have.<\/p>\n

10. When finished, click on Next Step<\/strong>.<\/p>\n

11. Now you have completed the set up of the new MySQL database, created a username and password to manage it and assigned privileges to that user.<\/p>\n

12. Frrom the final page of the Database Wizard (as below) that gives you the options to carry out a range of related tasks.<\/p>\n

\"database-4\"<\/p>\n","protected":false},"excerpt":{"rendered":"

MySQL databases are the way to manage the information required to control your web site. They’re an important demand for several web site platforms, like WordPress and Magento. In this tutorial, we\u2019ll show you the way to create a new MySQL database and originated a username and Password for it using the cPanel Database Wizard. […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[],"tags":[],"class_list":["post-1548","post","type-post","status-publish","format-standard","hentry"],"yoast_head":"\nHow to Create a MySQL Database Using the cPanel Database Wizard - OWS KB<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/ownwebservers.com\/kb\/how-to-create-a-mysql-database-using-the-cpanel-database-wizard\/\" \/>\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 MySQL Database Using the cPanel Database Wizard - OWS KB\" \/>\n<meta property=\"og:description\" content=\"MySQL databases are the way to manage the information required to control your web site. They’re an important demand for several web site platforms, like WordPress and Magento. In this tutorial, we\u2019ll show you the way to create a new MySQL database and originated a username and Password for it using the cPanel Database Wizard. […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/ownwebservers.com\/kb\/how-to-create-a-mysql-database-using-the-cpanel-database-wizard\/\" \/>\n<meta property=\"og:site_name\" content=\"OWS KB\" \/>\n<meta property=\"article:published_time\" content=\"2021-08-31T12:33:53+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-08-31T12:39:21+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/ownwebservers.com\/kb\/wp-content\/uploads\/2021\/08\/database-1-300x146.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\">\n\t<meta name=\"twitter:data1\" content=\"admin\">\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\">\n\t<meta name=\"twitter:data2\" content=\"1 minute\">\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebSite\",\"@id\":\"https:\/\/ownwebservers.com\/kb\/#website\",\"url\":\"https:\/\/ownwebservers.com\/kb\/\",\"name\":\"OWS KB\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":\"https:\/\/ownwebservers.com\/kb\/?s={search_term_string}\",\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/ownwebservers.com\/kb\/how-to-create-a-mysql-database-using-the-cpanel-database-wizard\/#primaryimage\",\"inLanguage\":\"en-US\",\"url\":\"https:\/\/ownwebservers.com\/kb\/wp-content\/uploads\/2021\/08\/database-1.png\",\"width\":623,\"height\":304,\"caption\":\"database-1\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/ownwebservers.com\/kb\/how-to-create-a-mysql-database-using-the-cpanel-database-wizard\/#webpage\",\"url\":\"https:\/\/ownwebservers.com\/kb\/how-to-create-a-mysql-database-using-the-cpanel-database-wizard\/\",\"name\":\"How to Create a MySQL Database Using the cPanel Database Wizard - OWS KB\",\"isPartOf\":{\"@id\":\"https:\/\/ownwebservers.com\/kb\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/ownwebservers.com\/kb\/how-to-create-a-mysql-database-using-the-cpanel-database-wizard\/#primaryimage\"},\"datePublished\":\"2021-08-31T12:33:53+00:00\",\"dateModified\":\"2021-08-31T12:39:21+00:00\",\"author\":{\"@id\":\"https:\/\/ownwebservers.com\/kb\/#\/schema\/person\/4a40fe3fe17a08ddd1d7c113668e75f2\"},\"breadcrumb\":{\"@id\":\"https:\/\/ownwebservers.com\/kb\/how-to-create-a-mysql-database-using-the-cpanel-database-wizard\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/ownwebservers.com\/kb\/how-to-create-a-mysql-database-using-the-cpanel-database-wizard\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/ownwebservers.com\/kb\/how-to-create-a-mysql-database-using-the-cpanel-database-wizard\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"item\":{\"@type\":\"WebPage\",\"@id\":\"https:\/\/ownwebservers.com\/kb\/\",\"url\":\"https:\/\/ownwebservers.com\/kb\/\",\"name\":\"Home\"}},{\"@type\":\"ListItem\",\"position\":2,\"item\":{\"@type\":\"WebPage\",\"@id\":\"https:\/\/ownwebservers.com\/kb\/how-to-create-a-mysql-database-using-the-cpanel-database-wizard\/\",\"url\":\"https:\/\/ownwebservers.com\/kb\/how-to-create-a-mysql-database-using-the-cpanel-database-wizard\/\",\"name\":\"How to Create a MySQL Database Using the cPanel Database Wizard\"}}]},{\"@type\":\"Person\",\"@id\":\"https:\/\/ownwebservers.com\/kb\/#\/schema\/person\/4a40fe3fe17a08ddd1d7c113668e75f2\",\"name\":\"admin\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/ownwebservers.com\/kb\/#personlogo\",\"inLanguage\":\"en-US\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/ba5db5841d48bd7517bb2583e13983e6d2fa56a4099a0b3c61ad2daefc321303?s=96&d=mm&r=g\",\"caption\":\"admin\"},\"sameAs\":[\"https:\/\/ownwebservers.com\/kb\"]}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","_links":{"self":[{"href":"https:\/\/ownwebservers.com\/kb\/wp-json\/wp\/v2\/posts\/1548","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ownwebservers.com\/kb\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ownwebservers.com\/kb\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ownwebservers.com\/kb\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/ownwebservers.com\/kb\/wp-json\/wp\/v2\/comments?post=1548"}],"version-history":[{"count":3,"href":"https:\/\/ownwebservers.com\/kb\/wp-json\/wp\/v2\/posts\/1548\/revisions"}],"predecessor-version":[{"id":1555,"href":"https:\/\/ownwebservers.com\/kb\/wp-json\/wp\/v2\/posts\/1548\/revisions\/1555"}],"wp:attachment":[{"href":"https:\/\/ownwebservers.com\/kb\/wp-json\/wp\/v2\/media?parent=1548"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ownwebservers.com\/kb\/wp-json\/wp\/v2\/categories?post=1548"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ownwebservers.com\/kb\/wp-json\/wp\/v2\/tags?post=1548"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}