{"id":1177,"date":"2020-10-19T06:42:26","date_gmt":"2020-10-19T06:42:26","guid":{"rendered":"https:\/\/blog.hostinger.io\/support\/2020\/10\/19\/4548533-how-to-create-a-new-mysql-database-in-cpanel-at-hostinger\/"},"modified":"2025-08-27T07:09:39","modified_gmt":"2025-08-27T07:09:39","slug":"4548533-how-to-create-a-new-mysql-database-in-cpanel-at-hostinger","status":"publish","type":"post","link":"https:\/\/www.hostinger.com\/support\/4548533-how-to-create-a-new-mysql-database-in-cpanel-at-hostinger\/","title":{"rendered":"How to Create a New MySQL Database in cPanel at Hostinger"},"content":{"rendered":"<p class=\"no-margin\">You can easily create a new <b>MySQL database<\/b> by opening your cPanel and clicking on <b>MySQL Databases<\/b> section:<\/p><p class=\"no-margin\">\n<\/p><div class=\"intercom-container intercom-align-center\"><img decoding=\"async\" src=\"\/support\/wp-content\/uploads\/sites\/55\/2020\/10\/17442cd5-c549-40da-830d-726f40aa40ca.jpg\" alt=\"The MySQL Databases option on cPanel\"><\/div><p class=\"no-margin\">Once there, enter the database name and click on <b>Create Database<\/b>:<\/p><p class=\"no-margin\">\n<\/p><div class=\"intercom-container intercom-align-center\"><img decoding=\"async\" src=\"\/support\/wp-content\/uploads\/sites\/55\/2020\/10\/4baa30e1-26e1-41a9-9ee3-92f43f0bea80.jpg\" alt=\"The Create New Database section showing how to create a database\"><\/div><p class=\"no-margin\">By default, the prefix will be your cPanel username followed by an underscore. eg. <b>user_<\/b> <\/p><p class=\"no-margin\">\n<\/p><p class=\"no-margin\">Select to <b>Go Back<\/b> after creating the database and scroll down to the <b>Add New User <\/b>section, taking the following into consideration:<\/p><ul>\n<li>\n<p class=\"no-margin\">The username name will have the same prefix as the database<\/p>\n<\/li>\n<li>\n<p class=\"no-margin\">Enter the database password twice. It is recommended to use the password generator tool to ensure a strong password is used<\/p>\n<\/li>\n<\/ul><p class=\"no-margin\">Next, click on <b>Create User<\/b>:<\/p><p class=\"no-margin\">\n<\/p><div class=\"intercom-container intercom-align-center\"><img decoding=\"async\" src=\"\/support\/wp-content\/uploads\/sites\/55\/2020\/10\/d5a4f8aa-6830-4149-8133-8bdcc862518f.jpg\" alt=\"The Add New User section showing how to create a database user\"><\/div><p class=\"no-margin\">Finally, on the <b>Add User To Database <\/b>section right below, connect your newly created user with the database. Select the user and database from the dropdownl ist and click on <b>Add<\/b>:<\/p><p class=\"no-margin\">\n<\/p><div class=\"intercom-container intercom-align-center\"><img decoding=\"async\" src=\"\/support\/wp-content\/uploads\/sites\/55\/2020\/10\/f78f0c93-8456-4c73-a0b7-d48bbcb08095.jpg\" alt=\"The Add User To Database section showing how to associate a user to a database\"><\/div><p class=\"no-margin\">That&rsquo;s it! Your MySQL database will be created with a user correctly associated with it.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Creating a new MySQL database at Hostinger using cPanel<\/p>\n","protected":false},"author":581,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"include_on_kodee":true,"footnotes":""},"categories":[195],"tags":[],"class_list":["post-1177","post","type-post","status-publish","format-standard","hentry","category-mysql"],"hreflangs":[{"locale":"en-US","link":"https:\/\/www.hostinger.com\/support\/4548533-how-to-create-a-new-mysql-database-in-cpanel-at-hostinger\/","default":1},{"locale":"es-ES","link":"https:\/\/www.hostinger.com\/es\/support\/4548533-como-puedo-crear-una-nueva-base-de-datos-mysql-en-cpanel-en-hostinger\/","default":0},{"locale":"fr-FR","link":"https:\/\/www.hostinger.com\/fr\/support\/4548533-comment-puis-je-creer-une-nouvelle-base-de-donnees-mysql-dans-cpanel-chez-hostinger\/","default":0},{"locale":"id-ID","link":"https:\/\/www.hostinger.com\/id\/support\/4548533-bagaimana-cara-membuat-database-mysql-baru-di-cpanel-di-hostinger\/","default":0},{"locale":"pt-PT","link":"https:\/\/www.hostinger.com\/br\/support\/4548533-como-criar-um-novo-banco-de-dados-mysql-no-cpanel-hostinger\/","default":0}],"include_on_kodee":true,"_links":{"self":[{"href":"https:\/\/www.hostinger.com\/support\/wp-json\/wp\/v2\/posts\/1177","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.hostinger.com\/support\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.hostinger.com\/support\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.hostinger.com\/support\/wp-json\/wp\/v2\/users\/581"}],"replies":[{"embeddable":true,"href":"https:\/\/www.hostinger.com\/support\/wp-json\/wp\/v2\/comments?post=1177"}],"version-history":[{"count":1,"href":"https:\/\/www.hostinger.com\/support\/wp-json\/wp\/v2\/posts\/1177\/revisions"}],"predecessor-version":[{"id":4622,"href":"https:\/\/www.hostinger.com\/support\/wp-json\/wp\/v2\/posts\/1177\/revisions\/4622"}],"wp:attachment":[{"href":"https:\/\/www.hostinger.com\/support\/wp-json\/wp\/v2\/media?parent=1177"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.hostinger.com\/support\/wp-json\/wp\/v2\/categories?post=1177"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.hostinger.com\/support\/wp-json\/wp\/v2\/tags?post=1177"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}