{"id":167,"date":"2025-12-17T09:16:29","date_gmt":"2025-12-17T08:16:29","guid":{"rendered":"https:\/\/mybox.com\/help\/?post_type=manual_kb&#038;p=167"},"modified":"2026-04-02T09:28:21","modified_gmt":"2026-04-02T07:28:21","slug":"creating-a-database-and-a-database-user","status":"publish","type":"manual_kb","link":"https:\/\/mybox.com\/help\/en\/knowledgebase\/creating-a-database-and-a-database-user\/","title":{"rendered":"Creating a database and a database user"},"content":{"rendered":"\n<div class=\"translation-block translation-block-merged\">\n<p class=\"wp-block-paragraph\">A MySQL database is a secure environment used to store your website\u2019s structured data, such as posts, user profiles, and settings. To function, a database requires a dedicated user with specific permissions to access and modify that data.<\/p>\n\n\n\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_86 ez-toc-wrap-left counter-hierarchy ez-toc-counter ez-toc-custom ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/mybox.com\/help\/en\/knowledgebase\/creating-a-database-and-a-database-user\/#Context\" >Context<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/mybox.com\/help\/en\/knowledgebase\/creating-a-database-and-a-database-user\/#Step-by-Step_Configuration\" >Step-by-Step Configuration<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/mybox.com\/help\/en\/knowledgebase\/creating-a-database-and-a-database-user\/#Distinction_Database_vs_Database_User\" >Distinction: Database vs. Database User<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/mybox.com\/help\/en\/knowledgebase\/creating-a-database-and-a-database-user\/#Practical_Implications\" >Practical Implications<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/mybox.com\/help\/en\/knowledgebase\/creating-a-database-and-a-database-user\/#Summary\" >Summary<\/a><\/li><\/ul><\/nav><\/div>\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Context\"><\/span>Context<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">When setting up a new application or website, you typically need both a new database and a new user simultaneously. The <strong>mybox panel<\/strong> provides a streamlined process to create both in a single step, ensuring they are correctly linked from the start.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Step-by-Step_Configuration\"><\/span>Step-by-Step Configuration<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<\/div>\n\n<div id=\"mybox-2170047275\" class=\"mybox-content mybox-entity-placement\"><div class=\"early-access-banner-inpost\">\r\n  <div class=\"banner-left-inpost\">\r\n    <div class=\"icon-box-inpost\">\r\n      <img decoding=\"async\" src=\"https:\/\/mybox.com\/help\/wp-content\/uploads\/2026\/02\/square-info-icon.svg\" alt=\"Info\">\r\n    <\/div>\r\n    <div class=\"text-box-inpost\">\r\n      <span class=\"label-inpost\"><span class=\"translation-block translation-block-banner-text\">Early access<\/span><\/span>\r\n      <h4><span class=\"translation-block translation-block-banner-text\">Still need help?<\/span><\/h4>\r\n      <p><span class=\"translation-block translation-block-banner-text\">Contact our customer service team.<\/span><\/p>\r\n    <\/div>\r\n  <\/div>\r\n\r\n  <div class=\"banner-right-inpost\">\r\n    <a href=\"https:\/\/panel.mybox.com\/helpdesk2\/v\/list\/\" class=\"banner-button-inpost\"><span class=\"translation-block translation-block-banner-text\">Message us<\/span><\/a>\r\n  <\/div>\r\n<\/div><\/div>\n\n<div class=\"translation-block translation-block-merged\"><p class=\"wp-block-paragraph\">To create both components at once, follow these steps in your dashboard:<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Access the Database Section:<\/strong> Log in to the <strong>mybox panel<\/strong> and navigate to the <strong>Databases<\/strong> or <strong>MySQL Users<\/strong> tab.<\/p>\n\n\n\n<ol class=\"wp-block-list\"><\/ol>\n\n\n\n<ol start=\"1\" class=\"wp-block-list\"><\/ol>\n\n\n\n<\/div>\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"946\" height=\"364\" src=\"https:\/\/mybox.com\/help\/wp-content\/uploads\/2025\/12\/image-66.png\" alt=\"\" class=\"wp-image-3699\" srcset=\"https:\/\/mybox.com\/help\/wp-content\/uploads\/2025\/12\/image-66.png 946w, https:\/\/mybox.com\/help\/wp-content\/uploads\/2025\/12\/image-66-300x115.png 300w, https:\/\/mybox.com\/help\/wp-content\/uploads\/2025\/12\/image-66-768x296.png 768w, https:\/\/mybox.com\/help\/wp-content\/uploads\/2025\/12\/image-66-18x7.png 18w\" sizes=\"auto, (max-width: 946px) 100vw, 946px\" \/><\/figure>\n\n<div class=\"translation-block translation-block-merged\">\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Open the Creation Form:<\/strong> Click the <strong>+ Add<\/strong> button and select <strong>Add user and database<\/strong> from the dropdown list.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Complete the Form:<\/strong> * <strong>Database Name:<\/strong> Choose a unique name for your database.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Username:<\/strong> Create a name for the user who will access this database.<\/li>\n\n\n\n<li><strong>Password:<\/strong> Set a strong, unique password for the database user.<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Confirm:<\/strong> Click <strong>Add a Database and User<\/strong> to finalize the process.<\/p>\n\n\n<\/div>\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"592\" height=\"377\" src=\"https:\/\/mybox.com\/help\/wp-content\/uploads\/2025\/12\/image-67.png\" alt=\"\" class=\"wp-image-3701\" srcset=\"https:\/\/mybox.com\/help\/wp-content\/uploads\/2025\/12\/image-67.png 592w, https:\/\/mybox.com\/help\/wp-content\/uploads\/2025\/12\/image-67-300x191.png 300w, https:\/\/mybox.com\/help\/wp-content\/uploads\/2025\/12\/image-67-18x12.png 18w\" sizes=\"auto, (max-width: 592px) 100vw, 592px\" \/><\/figure>\n<\/div>\n\n<div class=\"translation-block translation-block-merged\">\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Distinction_Database_vs_Database_User\"><\/span>Distinction: Database vs. Database User<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Database:<\/strong> The &#8220;container&#8221; where your data is organized into tables.<\/li>\n\n\n\n<li><strong>Database User:<\/strong> The &#8220;keyholder&#8221; or identity used by your website scripts (like WordPress) to connect to that container.<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Practical_Implications\"><\/span>Practical Implications<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Default Permissions:<\/strong> When using the combined creation form, the system automatically links the user to the database. However, specific granular permissions (like &#8220;Read Only&#8221; or &#8220;Drop&#8221;) are set to a standard default.<\/li>\n\n\n\n<li><strong>Adjusting Permissions:<\/strong> If your project requires custom access levels, you must manage these manually in the <strong>MySQL Users<\/strong> tab <em>after<\/em> the initial creation is complete.<\/li>\n\n\n\n<li><strong>Connection Details:<\/strong> Once created, you will use these credentials (Database Name, Username, Password, and the Hostname found in your account details) to configure your website&#8217;s configuration files (e.g., <code>wp-config.php<\/code>).<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Summary\"><\/span>Summary<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Creating a database and user together is the most efficient way to prepare your environment for a new installation. By managing these through the <strong>mybox panel<\/strong>, you ensure that your website has a secure and correctly configured data layer from day one.<\/p>\n<\/div>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"template":"","format":"standard","manualknowledgebasecat":[9,25],"manual_kb_tag":[4020,4021,214,1534,1643,2066,3698,4017,4018,4019],"class_list":["post-167","manual_kb","type-manual_kb","status-publish","format-standard","hentry","manualknowledgebasecat-databases","manualknowledgebasecat-hosting","manual_kb_tag-set-database-permissions","manual_kb_tag-manage-database","manual_kb_tag-create-database","manual_kb_tag-user-management","manual_kb_tag-database-management","manual_kb_tag-database-permissions","manual_kb_tag-create-database-user","manual_kb_tag-add-database","manual_kb_tag-add-user-and-database","manual_kb_tag-database-creation-form"],"_links":{"self":[{"href":"https:\/\/mybox.com\/help\/en\/wp-json\/wp\/v2\/manual_kb\/167","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/mybox.com\/help\/en\/wp-json\/wp\/v2\/manual_kb"}],"about":[{"href":"https:\/\/mybox.com\/help\/en\/wp-json\/wp\/v2\/types\/manual_kb"}],"author":[{"embeddable":true,"href":"https:\/\/mybox.com\/help\/en\/wp-json\/wp\/v2\/users\/1"}],"version-history":[{"count":3,"href":"https:\/\/mybox.com\/help\/en\/wp-json\/wp\/v2\/manual_kb\/167\/revisions"}],"predecessor-version":[{"id":3702,"href":"https:\/\/mybox.com\/help\/en\/wp-json\/wp\/v2\/manual_kb\/167\/revisions\/3702"}],"wp:attachment":[{"href":"https:\/\/mybox.com\/help\/en\/wp-json\/wp\/v2\/media?parent=167"}],"wp:term":[{"taxonomy":"manualknowledgebasecat","embeddable":true,"href":"https:\/\/mybox.com\/help\/en\/wp-json\/wp\/v2\/manualknowledgebasecat?post=167"},{"taxonomy":"manual_kb_tag","embeddable":true,"href":"https:\/\/mybox.com\/help\/en\/wp-json\/wp\/v2\/manual_kb_tag?post=167"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}