{"id":239,"date":"2025-12-17T10:25:32","date_gmt":"2025-12-17T09:25:32","guid":{"rendered":"https:\/\/mybox.com\/help\/?post_type=manual_kb&p=239"},"modified":"2026-06-07T14:59:55","modified_gmt":"2026-06-07T12:59:55","slug":"how-can-i-add-a-user-who-will-have-access-to-all-mysql-databases","status":"publish","type":"manual_kb","link":"https:\/\/mybox.com\/help\/en\/knowledgebase\/how-can-i-add-a-user-who-will-have-access-to-all-mysql-databases\/","title":{"rendered":"How can I add a user who will have access to all MySQL databases?"},"content":{"rendered":"\n
\n

In some situations, particularly when managing multiple websites or transferring data between databases, it may be useful to have a single MySQL user with access to all databases associated with your hosting account.<\/p>\n\n\n\n

A Master MySQL User<\/strong> provides this functionality, allowing you to use one set of credentials to connect to and manage all databases assigned to your account.<\/p>\n\n\n\n<\/div>\n\n

\r\n
\r\n
\r\n \"Info\"\r\n <\/div>\r\n
\r\n Early access<\/span><\/span>\r\n

Still need help?<\/span><\/h4>\r\n

Contact our customer service team.<\/span><\/p>\r\n <\/div>\r\n <\/div>\r\n\r\n

\r\n Message us<\/span><\/a>\r\n <\/div>\r\n<\/div><\/div>\n\n

A Master MySQL User has extensive privileges across all databases associated with your hosting account. For security reasons, it should only be used for administrative tasks and by trusted users. Follow the steps below to add a master MySQL user:<\/p>\n\n\n\n

1.<\/strong> Log in to the mybox panel<\/strong> and you will go to the “Databases”<\/strong><\/em> tab.<\/p>\n\n\n<\/div>\n\n

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

2.<\/strong> Then select “MySQL Users”.<\/strong><\/em><\/p>\n\n\n<\/div>\n\n

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

3.<\/strong> On the page that loads, you will find a list of currently existing database users. Click the “+Add”<\/strong><\/em> button to expand the list of possible options.<\/p>\n\n\n<\/div>\n\n

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

4.<\/strong> From the expanded list, select “Add User (Master)”.<\/strong><\/em><\/p>\n\n\n<\/div>\n\n

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

5.<\/strong> In the window that appears, specify the Master user login and define the password<\/strong> that he will be able to use. Click the “Add MySQL User”<\/strong><\/em> button to confirm the operation. That’s all.<\/p>\n\n\n<\/div>\n\n

\n
\"\"<\/figure>\n<\/div>\n\n
\n\n\n
<\/path><\/svg><\/span>
Note:<\/div><\/div>
The MySQL Master user has been granted permissions to all databases assigned to the account. Due to their broad privileges, use this user only for administrative tasks.<\/div><\/div>
<\/div><\/div>\n<\/div>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"template":"","format":"standard","manualknowledgebasecat":[9,25],"manual_kb_tag":[3827,3828,283,1112,2670,3822,3823,3824,3825,3826],"class_list":["post-239","manual_kb","type-manual_kb","status-publish","format-standard","hentry","manualknowledgebasecat-databases","manualknowledgebasecat-hosting","manual_kb_tag-cross-database-access","manual_kb_tag-databases-tab","manual_kb_tag-mybox-panel","manual_kb_tag-database-access","manual_kb_tag-database-user","manual_kb_tag-master-user","manual_kb_tag-master-account","manual_kb_tag-add-master-user","manual_kb_tag-add-my-user","manual_kb_tag-add-user"],"_links":{"self":[{"href":"https:\/\/mybox.com\/help\/en\/wp-json\/wp\/v2\/manual_kb\/239","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":5,"href":"https:\/\/mybox.com\/help\/en\/wp-json\/wp\/v2\/manual_kb\/239\/revisions"}],"predecessor-version":[{"id":3829,"href":"https:\/\/mybox.com\/help\/en\/wp-json\/wp\/v2\/manual_kb\/239\/revisions\/3829"}],"wp:attachment":[{"href":"https:\/\/mybox.com\/help\/en\/wp-json\/wp\/v2\/media?parent=239"}],"wp:term":[{"taxonomy":"manualknowledgebasecat","embeddable":true,"href":"https:\/\/mybox.com\/help\/en\/wp-json\/wp\/v2\/manualknowledgebasecat?post=239"},{"taxonomy":"manual_kb_tag","embeddable":true,"href":"https:\/\/mybox.com\/help\/en\/wp-json\/wp\/v2\/manual_kb_tag?post=239"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}