{"id":295,"date":"2026-02-16T05:11:42","date_gmt":"2026-02-16T05:11:42","guid":{"rendered":"https:\/\/packetra.com\/knowledgebase\/?post_type=ht_kb&p=295"},"modified":"2026-02-16T07:51:07","modified_gmt":"2026-02-16T07:51:07","slug":"how-to-cpanel-create-a-mysql-database","status":"publish","type":"ht_kb","link":"https:\/\/packetra.com\/knowledgebase\/kb\/how-to-cpanel-create-a-mysql-database\/","title":{"rendered":"How to cPanel \u2013 Create a MySQL Database"},"content":{"rendered":"\n

You can manage your databases easily through the cPanel portal.<\/mark> In this guide, we will walk you through how to use the cPanel MySQL Database Wizard to create a cPanel database and user and give it permission in your Packetra cPanel hosting panel. <\/mark><\/p>\n\n\n\n

This article is only applicable to those who have an account with Packetra <\/strong>and it assumes that you are already logged into the cPanel. Don’t have a hosting account yet? Check out our Shared Hosting<\/strong><\/a> or WordPress Hosting<\/strong><\/a>. If you already have one feel free to login<\/a><\/strong> to your portal, click the cPanel hosting service and use one of the quick actions to log onto your cPanel to follow the guide below.<\/p>\n\n\n\n

Find the cPanel Database Section<\/h3>\n\n\n\n

First, under the Databases <\/strong>section, click Database Wizard<\/strong><\/p>\n\n\n\n

\"Under<\/figure>\n\n\n\n

Create Your cPanel Database<\/h3>\n\n\n\n

Next, you set the name of your database, it will be prefixed with the username of your hosting account, we’re going ot create “mydatabase” and the name of that database will then be <username>_mydatabase. When you have set a name, you click the blue Next Step<\/strong> button.<\/p>\n\n\n\n

\"Create<\/figure>\n\n\n\n

Create Database User<\/h3>\n\n\n\n

Next, you set the name of the user for the database connection, this too will be prefixed by your hosting account username, we’re going to create “myuser” and the name of the user will then be <username>_myuser. Then generate a password by clicking the Password Generator<\/strong> or manually set your password. When you filled in the required fields, you click the Create User<\/strong><\/p>\n\n\n\n

\"Create<\/figure>\n\n\n\n

Set User Permissions<\/h3>\n\n\n\n

Finally, we select the database user permissions, by default all boxes are unchecked. You can give it certain permissions while leaving out others but for the sake of this example we’re going to grant the user ALL PRIVILEGES<\/strong> as if you were to install WordPress for example, the last thing you want is to accidentally forget a permission that is required. When you are done you click the blue Next Step<\/strong>.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Your Database is Ready<\/h3>\n\n\n\n
\"\"<\/figure>\n\n\n\n

That is it, now you know how to perform a cPanel MySQL Database setup through your Packetra hosting account.<\/p>\n\n\n\n

Frequently Asked Questions<\/strong>

Can I create multiple databases?<\/strong>
Yes. The number of databases you can create depends on your hosting plan. You can check your limit in cPanel under the MySQL Databases section.

Do I need a separate user for each database?<\/strong>
Not necessarily. One database user can be assigned to multiple databases. However, for security we recommend creating a separate user for each database, especially if you run multiple websites on the same hosting account.

What privileges should I give the user?<\/strong>
For most applications like WordPress, Joomla or Laravel, granting ALL PRIVILEGES is the safest option. Only restrict privileges if you have a specific reason to do so.<\/p>\n\n\n\n

Good to Know<\/strong>
Always write down your database name, username and password somewhere safe. You will need these when configuring your website or application. Additionally, remember that cPanel prefixes both the database name and username with your hosting account username, so the actual names will be longer than what you typed. If you ever need to manage your databases directly, you can use phpMyAdmin<\/em> which is also found under the Databases<\/em> section in cPanel. If you run into any issues, open a support ticket through the client portal<\/strong><\/a> and our team will assist you.<\/p>\n","protected":false},"excerpt":{"rendered":"

You can manage your databases easily through the cPanel portal. In this guide, we will walk you through how to use the cPanel MySQL Database Wizard to create a cPanel database and user and give it permission in your Packetra cPanel hosting panel. Find the cPanel Database Section First, under…<\/p>\n","protected":false},"author":1,"comment_status":"closed","ping_status":"closed","template":"","format":"standard","meta":{"footnotes":""},"ht-kb-category":[67],"ht-kb-tag":[63,64],"class_list":["post-295","ht_kb","type-ht_kb","status-publish","format-standard","hentry","ht_kb_category-cpanel-hosting","ht_kb_tag-cpanel","ht_kb_tag-hosting"],"yoast_head":"\ncPanel Create Database \u2013 MySQL Database Wizard | Packetra<\/title>\n<meta name=\"description\" content=\"Learn how to create a mysql database in cPanel on your Packetra hosting account. A step by step guide for beginners.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/packetra.com\/knowledgebase\/kb\/how-to-cpanel-create-a-mysql-database\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"cPanel Create Database \u2013 MySQL Database Wizard | Packetra\" \/>\n<meta property=\"og:description\" content=\"Learn how to create a mysql database in cPanel on your Packetra hosting account. A step by step guide for beginners.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/packetra.com\/knowledgebase\/kb\/how-to-cpanel-create-a-mysql-database\/\" \/>\n<meta property=\"og:site_name\" content=\"Packetra Knowledgebase\" \/>\n<meta property=\"article:modified_time\" content=\"2026-02-16T07:51:07+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/packetra.com\/knowledgebase\/wp-content\/uploads\/2026\/02\/art_6_cPanel_screen1.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1300\" \/>\n\t<meta property=\"og:image:height\" content=\"305\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/packetra.com\\\/knowledgebase\\\/kb\\\/how-to-cpanel-create-a-mysql-database\\\/\",\"url\":\"https:\\\/\\\/packetra.com\\\/knowledgebase\\\/kb\\\/how-to-cpanel-create-a-mysql-database\\\/\",\"name\":\"cPanel Create Database \u2013 MySQL Database Wizard | Packetra\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/packetra.com\\\/knowledgebase\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/packetra.com\\\/knowledgebase\\\/kb\\\/how-to-cpanel-create-a-mysql-database\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/packetra.com\\\/knowledgebase\\\/kb\\\/how-to-cpanel-create-a-mysql-database\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/packetra.com\\\/knowledgebase\\\/wp-content\\\/uploads\\\/2026\\\/02\\\/art_6_cPanel_screen1-1024x240.png\",\"datePublished\":\"2026-02-16T05:11:42+00:00\",\"dateModified\":\"2026-02-16T07:51:07+00:00\",\"description\":\"Learn how to create a mysql database in cPanel on your Packetra hosting account. A step by step guide for beginners.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/packetra.com\\\/knowledgebase\\\/kb\\\/how-to-cpanel-create-a-mysql-database\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/packetra.com\\\/knowledgebase\\\/kb\\\/how-to-cpanel-create-a-mysql-database\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/packetra.com\\\/knowledgebase\\\/kb\\\/how-to-cpanel-create-a-mysql-database\\\/#primaryimage\",\"url\":\"https:\\\/\\\/packetra.com\\\/knowledgebase\\\/wp-content\\\/uploads\\\/2026\\\/02\\\/art_6_cPanel_screen1.png\",\"contentUrl\":\"https:\\\/\\\/packetra.com\\\/knowledgebase\\\/wp-content\\\/uploads\\\/2026\\\/02\\\/art_6_cPanel_screen1.png\",\"width\":1300,\"height\":305},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/packetra.com\\\/knowledgebase\\\/kb\\\/how-to-cpanel-create-a-mysql-database\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/packetra.com\\\/knowledgebase\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Articles\",\"item\":\"https:\\\/\\\/packetra.com\\\/knowledgebase\\\/kb\\\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"How to cPanel \u2013 Create a MySQL Database\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/packetra.com\\\/knowledgebase\\\/#website\",\"url\":\"https:\\\/\\\/packetra.com\\\/knowledgebase\\\/\",\"name\":\"Packetra Knowledgebase\",\"description\":\"Hosting Guides, VPS Help & Support\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/packetra.com\\\/knowledgebase\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"cPanel Create Database \u2013 MySQL Database Wizard | Packetra","description":"Learn how to create a mysql database in cPanel on your Packetra hosting account. A step by step guide for beginners.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/packetra.com\/knowledgebase\/kb\/how-to-cpanel-create-a-mysql-database\/","og_locale":"en_US","og_type":"article","og_title":"cPanel Create Database \u2013 MySQL Database Wizard | Packetra","og_description":"Learn how to create a mysql database in cPanel on your Packetra hosting account. A step by step guide for beginners.","og_url":"https:\/\/packetra.com\/knowledgebase\/kb\/how-to-cpanel-create-a-mysql-database\/","og_site_name":"Packetra Knowledgebase","article_modified_time":"2026-02-16T07:51:07+00:00","og_image":[{"width":1300,"height":305,"url":"https:\/\/packetra.com\/knowledgebase\/wp-content\/uploads\/2026\/02\/art_6_cPanel_screen1.png","type":"image\/png"}],"twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/packetra.com\/knowledgebase\/kb\/how-to-cpanel-create-a-mysql-database\/","url":"https:\/\/packetra.com\/knowledgebase\/kb\/how-to-cpanel-create-a-mysql-database\/","name":"cPanel Create Database \u2013 MySQL Database Wizard | Packetra","isPartOf":{"@id":"https:\/\/packetra.com\/knowledgebase\/#website"},"primaryImageOfPage":{"@id":"https:\/\/packetra.com\/knowledgebase\/kb\/how-to-cpanel-create-a-mysql-database\/#primaryimage"},"image":{"@id":"https:\/\/packetra.com\/knowledgebase\/kb\/how-to-cpanel-create-a-mysql-database\/#primaryimage"},"thumbnailUrl":"https:\/\/packetra.com\/knowledgebase\/wp-content\/uploads\/2026\/02\/art_6_cPanel_screen1-1024x240.png","datePublished":"2026-02-16T05:11:42+00:00","dateModified":"2026-02-16T07:51:07+00:00","description":"Learn how to create a mysql database in cPanel on your Packetra hosting account. A step by step guide for beginners.","breadcrumb":{"@id":"https:\/\/packetra.com\/knowledgebase\/kb\/how-to-cpanel-create-a-mysql-database\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/packetra.com\/knowledgebase\/kb\/how-to-cpanel-create-a-mysql-database\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/packetra.com\/knowledgebase\/kb\/how-to-cpanel-create-a-mysql-database\/#primaryimage","url":"https:\/\/packetra.com\/knowledgebase\/wp-content\/uploads\/2026\/02\/art_6_cPanel_screen1.png","contentUrl":"https:\/\/packetra.com\/knowledgebase\/wp-content\/uploads\/2026\/02\/art_6_cPanel_screen1.png","width":1300,"height":305},{"@type":"BreadcrumbList","@id":"https:\/\/packetra.com\/knowledgebase\/kb\/how-to-cpanel-create-a-mysql-database\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/packetra.com\/knowledgebase\/"},{"@type":"ListItem","position":2,"name":"Articles","item":"https:\/\/packetra.com\/knowledgebase\/kb\/"},{"@type":"ListItem","position":3,"name":"How to cPanel \u2013 Create a MySQL Database"}]},{"@type":"WebSite","@id":"https:\/\/packetra.com\/knowledgebase\/#website","url":"https:\/\/packetra.com\/knowledgebase\/","name":"Packetra Knowledgebase","description":"Hosting Guides, VPS Help & Support","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/packetra.com\/knowledgebase\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"}]}},"_links":{"self":[{"href":"https:\/\/packetra.com\/knowledgebase\/wp-json\/wp\/v2\/ht-kb\/295","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/packetra.com\/knowledgebase\/wp-json\/wp\/v2\/ht-kb"}],"about":[{"href":"https:\/\/packetra.com\/knowledgebase\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"https:\/\/packetra.com\/knowledgebase\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/packetra.com\/knowledgebase\/wp-json\/wp\/v2\/comments?post=295"}],"version-history":[{"count":5,"href":"https:\/\/packetra.com\/knowledgebase\/wp-json\/wp\/v2\/ht-kb\/295\/revisions"}],"predecessor-version":[{"id":351,"href":"https:\/\/packetra.com\/knowledgebase\/wp-json\/wp\/v2\/ht-kb\/295\/revisions\/351"}],"wp:attachment":[{"href":"https:\/\/packetra.com\/knowledgebase\/wp-json\/wp\/v2\/media?parent=295"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/packetra.com\/knowledgebase\/wp-json\/wp\/v2\/ht-kb-category?post=295"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/packetra.com\/knowledgebase\/wp-json\/wp\/v2\/ht-kb-tag?post=295"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}