{"id":448,"date":"2024-08-19T20:43:31","date_gmt":"2024-08-19T20:43:31","guid":{"rendered":"https:\/\/www.fastpanda.co.uk\/knowledge-hub\/?p=448"},"modified":"2024-08-19T20:43:31","modified_gmt":"2024-08-19T20:43:31","slug":"how-to-create-a-new-mysql-database-using-the-wizard-in-cpanel","status":"publish","type":"post","link":"https:\/\/www.fastpanda.co.uk\/knowledge-hub\/how-to-create-a-new-mysql-database-using-the-wizard-in-cpanel\/","title":{"rendered":"How to Create a New MySQL Database Using the Wizard in cPanel?"},"content":{"rendered":"<p>MySQL is a database management system used to store, manage, and query data in an organized manner. MySQL is supported by popular content management systems such as WordPress, Joomla, and Drupal, and is widely used around the world. To create a MySQL database in cPanel, you can follow the steps below.<\/p>\n<ul>\n<li>Access the website www.fastpanda.co.uk<\/li>\n<li>Click on the &#8220;Sign In&#8221; button on the opened page, enter your customer panel information, and click the &#8220;Log in&#8221; button to log in to your account.<\/li>\n<\/ul>\n<p><a href=\"https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-content\/uploads\/2024\/05\/Sign-In-2.png\"><img loading=\"lazy\" decoding=\"async\" class=\"zoooom alignnone wp-image-164\" src=\"https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-content\/uploads\/2024\/05\/Sign-In-2.png\" alt=\"\" width=\"1143\" height=\"503\" srcset=\"https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-content\/uploads\/2024\/05\/Sign-In-2.png 1898w, https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-content\/uploads\/2024\/05\/Sign-In-2-300x132.png 300w, https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-content\/uploads\/2024\/05\/Sign-In-2-1024x450.png 1024w, https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-content\/uploads\/2024\/05\/Sign-In-2-768x338.png 768w, https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-content\/uploads\/2024\/05\/Sign-In-2-1536x676.png 1536w, https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-content\/uploads\/2024\/05\/Sign-In-2-60x26.png 60w, https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-content\/uploads\/2024\/05\/Sign-In-2-150x66.png 150w\" sizes=\"(max-width: 1143px) 100vw, 1143px\" \/><\/a><\/p>\n<p><a href=\"https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-content\/uploads\/2024\/05\/Loginnew.png\"><img loading=\"lazy\" decoding=\"async\" class=\"zoooom alignnone wp-image-195\" src=\"https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-content\/uploads\/2024\/05\/Loginnew.png\" alt=\"\" width=\"1342\" height=\"622\" srcset=\"https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-content\/uploads\/2024\/05\/Loginnew.png 1898w, https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-content\/uploads\/2024\/05\/Loginnew-300x139.png 300w, https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-content\/uploads\/2024\/05\/Loginnew-1024x475.png 1024w, https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-content\/uploads\/2024\/05\/Loginnew-768x356.png 768w, https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-content\/uploads\/2024\/05\/Loginnew-1536x712.png 1536w, https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-content\/uploads\/2024\/05\/Loginnew-60x28.png 60w, https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-content\/uploads\/2024\/05\/Loginnew-150x70.png 150w\" sizes=\"(max-width: 1342px) 100vw, 1342px\" \/><\/a><\/p>\n<ul>\n<li>Click on the &#8220;Web Hosting&#8221; option in the left menu.<\/li>\n<\/ul>\n<p><a href=\"https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-content\/uploads\/2024\/05\/webhosting.png\"><img loading=\"lazy\" decoding=\"async\" class=\"zoooom alignnone wp-image-179\" src=\"https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-content\/uploads\/2024\/05\/webhosting.png\" alt=\"\" width=\"1364\" height=\"630\" srcset=\"https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-content\/uploads\/2024\/05\/webhosting.png 1903w, https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-content\/uploads\/2024\/05\/webhosting-300x139.png 300w, https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-content\/uploads\/2024\/05\/webhosting-1024x473.png 1024w, https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-content\/uploads\/2024\/05\/webhosting-768x355.png 768w, https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-content\/uploads\/2024\/05\/webhosting-1536x709.png 1536w, https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-content\/uploads\/2024\/05\/webhosting-60x28.png 60w, https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-content\/uploads\/2024\/05\/webhosting-150x69.png 150w\" sizes=\"(max-width: 1364px) 100vw, 1364px\" \/><\/a><\/p>\n<ul>\n<li>On the opened page, you will see your existing web hosting packages. Click the &#8220;Manage Product&#8221; button for the service you want to access cPanel.<\/li>\n<\/ul>\n<p><a href=\"https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-content\/uploads\/2024\/05\/hostingmanage.png\"><img loading=\"lazy\" decoding=\"async\" class=\"zoooom alignnone wp-image-180\" src=\"https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-content\/uploads\/2024\/05\/hostingmanage.png\" alt=\"\" width=\"1370\" height=\"634\" srcset=\"https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-content\/uploads\/2024\/05\/hostingmanage.png 1905w, https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-content\/uploads\/2024\/05\/hostingmanage-300x139.png 300w, https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-content\/uploads\/2024\/05\/hostingmanage-1024x474.png 1024w, https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-content\/uploads\/2024\/05\/hostingmanage-768x355.png 768w, https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-content\/uploads\/2024\/05\/hostingmanage-1536x710.png 1536w, https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-content\/uploads\/2024\/05\/hostingmanage-60x28.png 60w, https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-content\/uploads\/2024\/05\/hostingmanage-150x69.png 150w\" sizes=\"(max-width: 1370px) 100vw, 1370px\" \/><\/a><\/p>\n<ul>\n<li>You will see a &#8220;Login to cPanel&#8221; button. Clicking on this button will automatically redirect you to cPanel.<\/li>\n<\/ul>\n<p><a href=\"https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-content\/uploads\/2024\/05\/cpanellogin.png\"><img loading=\"lazy\" decoding=\"async\" class=\"zoooom alignnone wp-image-212\" src=\"https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-content\/uploads\/2024\/05\/cpanellogin.png\" alt=\"\" width=\"1364\" height=\"627\" srcset=\"https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-content\/uploads\/2024\/05\/cpanellogin.png 1906w, https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-content\/uploads\/2024\/05\/cpanellogin-300x138.png 300w, https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-content\/uploads\/2024\/05\/cpanellogin-1024x471.png 1024w, https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-content\/uploads\/2024\/05\/cpanellogin-768x353.png 768w, https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-content\/uploads\/2024\/05\/cpanellogin-1536x706.png 1536w, https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-content\/uploads\/2024\/05\/cpanellogin-60x28.png 60w, https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-content\/uploads\/2024\/05\/cpanellogin-150x69.png 150w\" sizes=\"(max-width: 1364px) 100vw, 1364px\" \/><\/a><\/p>\n<ul>\n<li>On the cPanel home page, under the &#8220;Databases&#8221; section, click on the &#8220;Database Wizard&#8221; option.<\/li>\n<\/ul>\n<p><a href=\"https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-content\/uploads\/2024\/08\/Databasewizard.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-449\" title=\"Databasewizard\" src=\"https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-content\/uploads\/2024\/08\/Databasewizard.png\" alt=\"Databasewizard\" width=\"1919\" height=\"879\" srcset=\"https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-content\/uploads\/2024\/08\/Databasewizard.png 1919w, https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-content\/uploads\/2024\/08\/Databasewizard-300x137.png 300w, https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-content\/uploads\/2024\/08\/Databasewizard-1024x469.png 1024w, https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-content\/uploads\/2024\/08\/Databasewizard-768x352.png 768w, https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-content\/uploads\/2024\/08\/Databasewizard-1536x704.png 1536w, https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-content\/uploads\/2024\/08\/Databasewizard-60x27.png 60w, https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-content\/uploads\/2024\/08\/Databasewizard-150x69.png 150w\" sizes=\"(max-width: 1919px) 100vw, 1919px\" \/><\/a><\/p>\n<ul>\n<li>Enter a name for the new database without using special characters and click the &#8220;Next Step&#8221; button.<\/li>\n<\/ul>\n<p><a href=\"https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-content\/uploads\/2024\/08\/Databasewizard2.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-450\" title=\"Databasewizard2\" src=\"https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-content\/uploads\/2024\/08\/Databasewizard2.png\" alt=\"Databasewizard\" width=\"1919\" height=\"880\" srcset=\"https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-content\/uploads\/2024\/08\/Databasewizard2.png 1919w, https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-content\/uploads\/2024\/08\/Databasewizard2-300x138.png 300w, https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-content\/uploads\/2024\/08\/Databasewizard2-1024x470.png 1024w, https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-content\/uploads\/2024\/08\/Databasewizard2-768x352.png 768w, https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-content\/uploads\/2024\/08\/Databasewizard2-1536x704.png 1536w, https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-content\/uploads\/2024\/08\/Databasewizard2-60x28.png 60w, https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-content\/uploads\/2024\/08\/Databasewizard2-150x69.png 150w\" sizes=\"(max-width: 1919px) 100vw, 1919px\" \/><\/a><\/p>\n<ul>\n<li>The database will be created and the message &#8220;You have created a database named &#8220;xxxxxxx&#8221;&#8216; will appear on the screen. After creating the database, you will need to create a user for the database. Enter a username in the &#8220;Username&#8221; section without using special characters. Set a strong password in the &#8220;Password&#8221; section. If you cannot generate a password, click the &#8220;Password Generator&#8221; button to create a secure password. After confirming the password, click the &#8220;Create User&#8221; button.<\/li>\n<\/ul>\n<p><a href=\"https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-content\/uploads\/2024\/08\/Databasewizard3.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-451\" title=\"Databasewizard3\" src=\"https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-content\/uploads\/2024\/08\/Databasewizard3.png\" alt=\"Databasewizard\" width=\"1919\" height=\"880\" srcset=\"https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-content\/uploads\/2024\/08\/Databasewizard3.png 1919w, https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-content\/uploads\/2024\/08\/Databasewizard3-300x138.png 300w, https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-content\/uploads\/2024\/08\/Databasewizard3-1024x470.png 1024w, https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-content\/uploads\/2024\/08\/Databasewizard3-768x352.png 768w, https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-content\/uploads\/2024\/08\/Databasewizard3-1536x704.png 1536w, https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-content\/uploads\/2024\/08\/Databasewizard3-60x28.png 60w, https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-content\/uploads\/2024\/08\/Databasewizard3-150x69.png 150w\" sizes=\"(max-width: 1919px) 100vw, 1919px\" \/><\/a><\/p>\n<ul>\n<li>On the opened page, check the &#8220;ALL PRIVILEGES&#8221; option to grant all privileges to the user and click the &#8220;Make Changes&#8221; button.<\/li>\n<\/ul>\n<p><a href=\"https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-content\/uploads\/2024\/08\/allprivileges.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-444\" title=\"allprivileges\" src=\"https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-content\/uploads\/2024\/08\/allprivileges.png\" alt=\"allprivileges\" width=\"1919\" height=\"879\" srcset=\"https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-content\/uploads\/2024\/08\/allprivileges.png 1919w, https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-content\/uploads\/2024\/08\/allprivileges-300x137.png 300w, https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-content\/uploads\/2024\/08\/allprivileges-1024x469.png 1024w, https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-content\/uploads\/2024\/08\/allprivileges-768x352.png 768w, https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-content\/uploads\/2024\/08\/allprivileges-1536x704.png 1536w, https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-content\/uploads\/2024\/08\/allprivileges-60x27.png 60w, https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-content\/uploads\/2024\/08\/allprivileges-150x69.png 150w\" sizes=\"(max-width: 1919px) 100vw, 1919px\" \/><\/a><\/p>\n<ul>\n<li>After completing all the steps, the new MySQL database will be ready for use. You can check the database and assigned user information in the &#8220;Current Databases&#8221; section of the Manage My Databases page.<\/li>\n<\/ul>\n<p><a href=\"https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-content\/uploads\/2024\/08\/currentdatabases.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-445\" title=\"currentdatabases\" src=\"https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-content\/uploads\/2024\/08\/currentdatabases.png\" alt=\"currentdatabases\" width=\"1919\" height=\"876\" srcset=\"https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-content\/uploads\/2024\/08\/currentdatabases.png 1919w, https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-content\/uploads\/2024\/08\/currentdatabases-300x137.png 300w, https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-content\/uploads\/2024\/08\/currentdatabases-1024x467.png 1024w, https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-content\/uploads\/2024\/08\/currentdatabases-768x351.png 768w, https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-content\/uploads\/2024\/08\/currentdatabases-1536x701.png 1536w, https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-content\/uploads\/2024\/08\/currentdatabases-60x27.png 60w, https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-content\/uploads\/2024\/08\/currentdatabases-150x68.png 150w\" sizes=\"(max-width: 1919px) 100vw, 1919px\" \/><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>MySQL is a database management system used to store, manage, and query data in an organized manner. MySQL is supported by popular content management systems such as WordPress, Joomla, and Drupal, and is widely used around the world. To create a MySQL database in cPanel, you can follow the steps below. Access the website www.fastpanda.co.uk [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[13,9,22],"tags":[],"_links":{"self":[{"href":"https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-json\/wp\/v2\/posts\/448"}],"collection":[{"href":"https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-json\/wp\/v2\/comments?post=448"}],"version-history":[{"count":2,"href":"https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-json\/wp\/v2\/posts\/448\/revisions"}],"predecessor-version":[{"id":453,"href":"https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-json\/wp\/v2\/posts\/448\/revisions\/453"}],"wp:attachment":[{"href":"https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-json\/wp\/v2\/media?parent=448"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-json\/wp\/v2\/categories?post=448"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-json\/wp\/v2\/tags?post=448"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}