{"id":439,"date":"2024-08-19T20:16:03","date_gmt":"2024-08-19T20:16:03","guid":{"rendered":"https:\/\/www.fastpanda.co.uk\/knowledge-hub\/?p=439"},"modified":"2024-08-19T20:16:03","modified_gmt":"2024-08-19T20:16:03","slug":"how-to-create-a-new-mysql-database-in-cpanel","status":"publish","type":"post","link":"https:\/\/www.fastpanda.co.uk\/knowledge-hub\/how-to-create-a-new-mysql-database-in-cpanel\/","title":{"rendered":"How to Create a New MySQL Database 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;Manage My Databases&#8221; option.<\/li>\n<\/ul>\n<p><a href=\"https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-content\/uploads\/2024\/08\/Managemydatabases.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-440\" title=\"Managemydatabases\" src=\"https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-content\/uploads\/2024\/08\/Managemydatabases.png\" alt=\"Managemydatabases\" width=\"1914\" height=\"874\" srcset=\"https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-content\/uploads\/2024\/08\/Managemydatabases.png 1914w, https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-content\/uploads\/2024\/08\/Managemydatabases-300x137.png 300w, https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-content\/uploads\/2024\/08\/Managemydatabases-1024x468.png 1024w, https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-content\/uploads\/2024\/08\/Managemydatabases-768x351.png 768w, https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-content\/uploads\/2024\/08\/Managemydatabases-1536x701.png 1536w, https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-content\/uploads\/2024\/08\/Managemydatabases-60x27.png 60w, https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-content\/uploads\/2024\/08\/Managemydatabases-150x68.png 150w\" sizes=\"(max-width: 1914px) 100vw, 1914px\" \/><\/a><\/p>\n<ul>\n<li>On the &#8220;MySQL Databases&#8221; page, go to the &#8220;New Database&#8221; section. Enter a name for the new database. Avoid using special characters in the database name. After deciding on the database name, click the &#8220;Create Database&#8221; button.<\/li>\n<\/ul>\n<p><a href=\"https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-content\/uploads\/2024\/08\/createdatabase.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-441\" title=\"createdatabase\" src=\"https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-content\/uploads\/2024\/08\/createdatabase.png\" alt=\"createdatabase\" width=\"1918\" height=\"880\" srcset=\"https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-content\/uploads\/2024\/08\/createdatabase.png 1918w, https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-content\/uploads\/2024\/08\/createdatabase-300x138.png 300w, https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-content\/uploads\/2024\/08\/createdatabase-1024x470.png 1024w, https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-content\/uploads\/2024\/08\/createdatabase-768x352.png 768w, https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-content\/uploads\/2024\/08\/createdatabase-1536x705.png 1536w, https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-content\/uploads\/2024\/08\/createdatabase-60x28.png 60w, https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-content\/uploads\/2024\/08\/createdatabase-150x69.png 150w\" sizes=\"(max-width: 1918px) 100vw, 1918px\" \/><\/a><\/p>\n<ul>\n<li>After creating a new database, you need to assign a user to this database. Access the &#8220;Database Users&#8221; section on the same page. Fill in the username and password fields located just below the &#8220;Add New User&#8221; heading. Avoid using special characters in the database username. Once you are sure of your password and username, click the &#8220;Create User&#8221; button. The database user will be created after this step.<\/li>\n<\/ul>\n<p><a href=\"https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-content\/uploads\/2024\/08\/database-users.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-442\" title=\"database users\" src=\"https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-content\/uploads\/2024\/08\/database-users.png\" alt=\"database users\" width=\"1917\" height=\"874\" srcset=\"https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-content\/uploads\/2024\/08\/database-users.png 1917w, https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-content\/uploads\/2024\/08\/database-users-300x137.png 300w, https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-content\/uploads\/2024\/08\/database-users-1024x467.png 1024w, https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-content\/uploads\/2024\/08\/database-users-768x350.png 768w, https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-content\/uploads\/2024\/08\/database-users-1536x700.png 1536w, https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-content\/uploads\/2024\/08\/database-users-60x27.png 60w, https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-content\/uploads\/2024\/08\/database-users-150x68.png 150w\" sizes=\"(max-width: 1917px) 100vw, 1917px\" \/><\/a><\/p>\n<ul>\n<li>After the above steps, you need to assign the database user to the database. In the &#8220;Add User To Database&#8221; section, select the username and the database. Click the &#8220;Add&#8221; button.<\/li>\n<\/ul>\n<p><a href=\"https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-content\/uploads\/2024\/08\/addusertodatabase.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-443\" title=\"addusertodatabase\" src=\"https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-content\/uploads\/2024\/08\/addusertodatabase.png\" alt=\"addusertodatabase\" width=\"1919\" height=\"876\" srcset=\"https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-content\/uploads\/2024\/08\/addusertodatabase.png 1919w, https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-content\/uploads\/2024\/08\/addusertodatabase-300x137.png 300w, https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-content\/uploads\/2024\/08\/addusertodatabase-1024x467.png 1024w, https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-content\/uploads\/2024\/08\/addusertodatabase-768x351.png 768w, https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-content\/uploads\/2024\/08\/addusertodatabase-1536x701.png 1536w, https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-content\/uploads\/2024\/08\/addusertodatabase-60x27.png 60w, https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-content\/uploads\/2024\/08\/addusertodatabase-150x68.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\/439"}],"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=439"}],"version-history":[{"count":1,"href":"https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-json\/wp\/v2\/posts\/439\/revisions"}],"predecessor-version":[{"id":446,"href":"https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-json\/wp\/v2\/posts\/439\/revisions\/446"}],"wp:attachment":[{"href":"https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-json\/wp\/v2\/media?parent=439"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-json\/wp\/v2\/categories?post=439"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-json\/wp\/v2\/tags?post=439"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}