{"id":6746,"date":"2021-12-20T12:01:02","date_gmt":"2021-12-20T12:01:02","guid":{"rendered":"https:\/\/www.bodhost.com\/kb\/?p=6746"},"modified":"2026-02-26T14:03:07","modified_gmt":"2026-02-26T14:03:07","slug":"how-can-you-map-mysql-databases-and-users-to-cpanel-users","status":"publish","type":"post","link":"https:\/\/www.bodhost.com\/kb\/how-can-you-map-mysql-databases-and-users-to-cpanel-users\/","title":{"rendered":"How can you map MySQL databases and users to cPanel users?"},"content":{"rendered":"

<\/strong><\/p>\r\n

In this tutorial, we\u2019ll explain how you can map MySQL databases and users to cPanel users.<\/p>\r\n\r\n\r\n\r\n

MySQL doesn\u2019t have any kind of concept of database ownership; for this reason, cPanel stores the database mappings in the \/var\/cpanel\/databases folder.<\/p>\r\n\r\n\r\n\r\n

If you want to restore the database manually, you need to map the databases and the usernames to the cPanel accounts.<\/p>\r\n\r\n\r\n\r\n

Follow the Procedure to map the database:<\/strong><\/p>\r\n\r\n\r\n\r\n

Mapping the MySQL databases can be done in WHM:<\/p>\r\n\r\n\r\n\r\n

    \r\n
  1. Log in to WHM<\/li>\r\n
  2. Click on the SQL Services\u00a0
    \"\"<\/li>\r\n
  3. \r\n
    You can see the Database Map Tool
    \"\"<\/figure>\r\n<\/li>\r\n
  4. \r\n
    You must choose either the cPanel user’s domain name or username here. You can also search the list of domains or users using the “Search by” tool. Then press the “Select” key.
    \"\"<\/figure>\r\n<\/li>\r\n
  5. In the “Database users” text box on this page, you can enter a comma-separated list of database users that the cPanel user should own.
    \"\"<\/li>\r\n
  6. \r\n
    In the Database names text box, you need to enter a comma-separated list of databases that you want the cPanel user to own.
    \"\"<\/figure>\r\n<\/li>\r\n
  7. \r\n
    To save your changes, click the “Submit” button.<\/figure>\r\n<\/li>\r\n<\/ol>\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n

    Related documentation: Database Map Tool<\/a><\/strong><\/p>\r\n\r\n\r\n\r\n

    We sincerely hope that you now have a clear idea regarding How can you map MySQL databases and users to cPanel users. However, if you are still facing any difficulty in the procedure mentioned above, feel free to reach out to the bodHOST<\/a> Team for proactive support 24\u00d77. Additionally, find out more about How to Inspect the Sizes of MySQL Databases and Tables<\/a><\/p>\r\n

    <\/strong><\/p>","protected":false},"excerpt":{"rendered":"

    In this tutorial, we\u2019ll explain how you can map MySQL databases and users to cPanel users. MySQL doesn\u2019t have any kind of concept of database ownership; for this reason, cPanel…<\/p>\n

    Read More<\/a><\/p>\n","protected":false},"author":22,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[857],"tags":[193,988,987],"class_list":["post-6746","post","type-post","status-publish","format-standard","hentry","category-sql","tag-cpanel","tag-database","tag-map-mysql-databases"],"yoast_head":"\nMap MySQL databases and users to cPanel users?<\/title>\n<meta name=\"description\" content=\"In this tutorial, we explain how you can map your MySQL databases and users to cPanel users. For more information, you can visit our site.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.bodhost.com\/kb\/how-can-you-map-mysql-databases-and-users-to-cpanel-users\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Map MySQL databases and users to cPanel users?\" \/>\n<meta property=\"og:description\" content=\"In this tutorial, we explain how you can map your MySQL databases and users to cPanel users. For more information, you can visit our site.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.bodhost.com\/kb\/how-can-you-map-mysql-databases-and-users-to-cpanel-users\/\" \/>\n<meta property=\"og:site_name\" content=\"Knowledge Base - bodHOST\" \/>\n<meta property=\"article:published_time\" content=\"2021-12-20T12:01:02+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-02-26T14:03:07+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.bodhost.com\/kb\/wp-content\/uploads\/2021\/04\/Screenshot_7-3.png\" \/>\n\t<meta property=\"og:image:width\" content=\"511\" \/>\n\t<meta property=\"og:image:height\" content=\"291\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Vincer\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Vincer\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.bodhost.com\\\/kb\\\/how-can-you-map-mysql-databases-and-users-to-cpanel-users\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.bodhost.com\\\/kb\\\/how-can-you-map-mysql-databases-and-users-to-cpanel-users\\\/\"},\"author\":{\"name\":\"Vincer\",\"@id\":\"https:\\\/\\\/www.bodhost.com\\\/kb\\\/#\\\/schema\\\/person\\\/f3852d74aeac480763235276b5faddd0\"},\"headline\":\"How can you map MySQL databases and users to cPanel users?\",\"datePublished\":\"2021-12-20T12:01:02+00:00\",\"dateModified\":\"2026-02-26T14:03:07+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.bodhost.com\\\/kb\\\/how-can-you-map-mysql-databases-and-users-to-cpanel-users\\\/\"},\"wordCount\":261,\"publisher\":{\"@id\":\"https:\\\/\\\/www.bodhost.com\\\/kb\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.bodhost.com\\\/kb\\\/how-can-you-map-mysql-databases-and-users-to-cpanel-users\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.bodhost.com\\\/kb\\\/wp-content\\\/uploads\\\/2021\\\/04\\\/Screenshot_7-3.png\",\"keywords\":[\"cPanel\",\"Database\",\"map MySQL databases\"],\"articleSection\":[\"SQL\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.bodhost.com\\\/kb\\\/how-can-you-map-mysql-databases-and-users-to-cpanel-users\\\/\",\"url\":\"https:\\\/\\\/www.bodhost.com\\\/kb\\\/how-can-you-map-mysql-databases-and-users-to-cpanel-users\\\/\",\"name\":\"Map MySQL databases and users to cPanel users?\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.bodhost.com\\\/kb\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.bodhost.com\\\/kb\\\/how-can-you-map-mysql-databases-and-users-to-cpanel-users\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.bodhost.com\\\/kb\\\/how-can-you-map-mysql-databases-and-users-to-cpanel-users\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.bodhost.com\\\/kb\\\/wp-content\\\/uploads\\\/2021\\\/04\\\/Screenshot_7-3.png\",\"datePublished\":\"2021-12-20T12:01:02+00:00\",\"dateModified\":\"2026-02-26T14:03:07+00:00\",\"description\":\"In this tutorial, we explain how you can map your MySQL databases and users to cPanel users. For more information, you can visit our site.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.bodhost.com\\\/kb\\\/how-can-you-map-mysql-databases-and-users-to-cpanel-users\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.bodhost.com\\\/kb\\\/how-can-you-map-mysql-databases-and-users-to-cpanel-users\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.bodhost.com\\\/kb\\\/how-can-you-map-mysql-databases-and-users-to-cpanel-users\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.bodhost.com\\\/kb\\\/wp-content\\\/uploads\\\/2021\\\/04\\\/Screenshot_7-3.png\",\"contentUrl\":\"https:\\\/\\\/www.bodhost.com\\\/kb\\\/wp-content\\\/uploads\\\/2021\\\/04\\\/Screenshot_7-3.png\",\"width\":511,\"height\":291},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.bodhost.com\\\/kb\\\/how-can-you-map-mysql-databases-and-users-to-cpanel-users\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"SQL\",\"item\":\"https:\\\/\\\/www.bodhost.com\\\/kb\\\/category\\\/sql\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How can you map MySQL databases and users to cPanel users?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.bodhost.com\\\/kb\\\/#website\",\"url\":\"https:\\\/\\\/www.bodhost.com\\\/kb\\\/\",\"name\":\"Web Hosting Knowledge Base | bodHOST Hosting FAQ\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.bodhost.com\\\/kb\\\/#organization\"},\"alternateName\":\"Web Hosting Knowledge Base | bodHOST Hosting FAQ\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.bodhost.com\\\/kb\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.bodhost.com\\\/kb\\\/#organization\",\"name\":\"Web Hosting Knowledge Base | bodHOST Hosting FAQ\",\"url\":\"https:\\\/\\\/www.bodhost.com\\\/kb\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.bodhost.com\\\/kb\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.bodhost.com\\\/kb\\\/wp-content\\\/uploads\\\/2025\\\/10\\\/Profile-Pic.png\",\"contentUrl\":\"https:\\\/\\\/www.bodhost.com\\\/kb\\\/wp-content\\\/uploads\\\/2025\\\/10\\\/Profile-Pic.png\",\"width\":240,\"height\":240,\"caption\":\"Web Hosting Knowledge Base | bodHOST Hosting FAQ\"},\"image\":{\"@id\":\"https:\\\/\\\/www.bodhost.com\\\/kb\\\/#\\\/schema\\\/logo\\\/image\\\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.bodhost.com\\\/kb\\\/#\\\/schema\\\/person\\\/f3852d74aeac480763235276b5faddd0\",\"name\":\"Vincer\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/bb5079f76e01aaa97b2ffcb7a562292482693b395aba4a4214c98f006c07d352?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/bb5079f76e01aaa97b2ffcb7a562292482693b395aba4a4214c98f006c07d352?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/bb5079f76e01aaa97b2ffcb7a562292482693b395aba4a4214c98f006c07d352?s=96&d=mm&r=g\",\"caption\":\"Vincer\"},\"url\":\"https:\\\/\\\/www.bodhost.com\\\/kb\\\/author\\\/vinayak\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Map MySQL databases and users to cPanel users?","description":"In this tutorial, we explain how you can map your MySQL databases and users to cPanel users. For more information, you can visit our site.","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:\/\/www.bodhost.com\/kb\/how-can-you-map-mysql-databases-and-users-to-cpanel-users\/","og_locale":"en_US","og_type":"article","og_title":"Map MySQL databases and users to cPanel users?","og_description":"In this tutorial, we explain how you can map your MySQL databases and users to cPanel users. For more information, you can visit our site.","og_url":"https:\/\/www.bodhost.com\/kb\/how-can-you-map-mysql-databases-and-users-to-cpanel-users\/","og_site_name":"Knowledge Base - bodHOST","article_published_time":"2021-12-20T12:01:02+00:00","article_modified_time":"2026-02-26T14:03:07+00:00","og_image":[{"width":511,"height":291,"url":"https:\/\/www.bodhost.com\/kb\/wp-content\/uploads\/2021\/04\/Screenshot_7-3.png","type":"image\/png"}],"author":"Vincer","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Vincer","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.bodhost.com\/kb\/how-can-you-map-mysql-databases-and-users-to-cpanel-users\/#article","isPartOf":{"@id":"https:\/\/www.bodhost.com\/kb\/how-can-you-map-mysql-databases-and-users-to-cpanel-users\/"},"author":{"name":"Vincer","@id":"https:\/\/www.bodhost.com\/kb\/#\/schema\/person\/f3852d74aeac480763235276b5faddd0"},"headline":"How can you map MySQL databases and users to cPanel users?","datePublished":"2021-12-20T12:01:02+00:00","dateModified":"2026-02-26T14:03:07+00:00","mainEntityOfPage":{"@id":"https:\/\/www.bodhost.com\/kb\/how-can-you-map-mysql-databases-and-users-to-cpanel-users\/"},"wordCount":261,"publisher":{"@id":"https:\/\/www.bodhost.com\/kb\/#organization"},"image":{"@id":"https:\/\/www.bodhost.com\/kb\/how-can-you-map-mysql-databases-and-users-to-cpanel-users\/#primaryimage"},"thumbnailUrl":"https:\/\/www.bodhost.com\/kb\/wp-content\/uploads\/2021\/04\/Screenshot_7-3.png","keywords":["cPanel","Database","map MySQL databases"],"articleSection":["SQL"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.bodhost.com\/kb\/how-can-you-map-mysql-databases-and-users-to-cpanel-users\/","url":"https:\/\/www.bodhost.com\/kb\/how-can-you-map-mysql-databases-and-users-to-cpanel-users\/","name":"Map MySQL databases and users to cPanel users?","isPartOf":{"@id":"https:\/\/www.bodhost.com\/kb\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.bodhost.com\/kb\/how-can-you-map-mysql-databases-and-users-to-cpanel-users\/#primaryimage"},"image":{"@id":"https:\/\/www.bodhost.com\/kb\/how-can-you-map-mysql-databases-and-users-to-cpanel-users\/#primaryimage"},"thumbnailUrl":"https:\/\/www.bodhost.com\/kb\/wp-content\/uploads\/2021\/04\/Screenshot_7-3.png","datePublished":"2021-12-20T12:01:02+00:00","dateModified":"2026-02-26T14:03:07+00:00","description":"In this tutorial, we explain how you can map your MySQL databases and users to cPanel users. For more information, you can visit our site.","breadcrumb":{"@id":"https:\/\/www.bodhost.com\/kb\/how-can-you-map-mysql-databases-and-users-to-cpanel-users\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.bodhost.com\/kb\/how-can-you-map-mysql-databases-and-users-to-cpanel-users\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.bodhost.com\/kb\/how-can-you-map-mysql-databases-and-users-to-cpanel-users\/#primaryimage","url":"https:\/\/www.bodhost.com\/kb\/wp-content\/uploads\/2021\/04\/Screenshot_7-3.png","contentUrl":"https:\/\/www.bodhost.com\/kb\/wp-content\/uploads\/2021\/04\/Screenshot_7-3.png","width":511,"height":291},{"@type":"BreadcrumbList","@id":"https:\/\/www.bodhost.com\/kb\/how-can-you-map-mysql-databases-and-users-to-cpanel-users\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"SQL","item":"https:\/\/www.bodhost.com\/kb\/category\/sql\/"},{"@type":"ListItem","position":2,"name":"How can you map MySQL databases and users to cPanel users?"}]},{"@type":"WebSite","@id":"https:\/\/www.bodhost.com\/kb\/#website","url":"https:\/\/www.bodhost.com\/kb\/","name":"Web Hosting Knowledge Base | bodHOST Hosting FAQ","description":"","publisher":{"@id":"https:\/\/www.bodhost.com\/kb\/#organization"},"alternateName":"Web Hosting Knowledge Base | bodHOST Hosting FAQ","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.bodhost.com\/kb\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.bodhost.com\/kb\/#organization","name":"Web Hosting Knowledge Base | bodHOST Hosting FAQ","url":"https:\/\/www.bodhost.com\/kb\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.bodhost.com\/kb\/#\/schema\/logo\/image\/","url":"https:\/\/www.bodhost.com\/kb\/wp-content\/uploads\/2025\/10\/Profile-Pic.png","contentUrl":"https:\/\/www.bodhost.com\/kb\/wp-content\/uploads\/2025\/10\/Profile-Pic.png","width":240,"height":240,"caption":"Web Hosting Knowledge Base | bodHOST Hosting FAQ"},"image":{"@id":"https:\/\/www.bodhost.com\/kb\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/www.bodhost.com\/kb\/#\/schema\/person\/f3852d74aeac480763235276b5faddd0","name":"Vincer","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/bb5079f76e01aaa97b2ffcb7a562292482693b395aba4a4214c98f006c07d352?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/bb5079f76e01aaa97b2ffcb7a562292482693b395aba4a4214c98f006c07d352?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/bb5079f76e01aaa97b2ffcb7a562292482693b395aba4a4214c98f006c07d352?s=96&d=mm&r=g","caption":"Vincer"},"url":"https:\/\/www.bodhost.com\/kb\/author\/vinayak\/"}]}},"_links":{"self":[{"href":"https:\/\/www.bodhost.com\/kb\/wp-json\/wp\/v2\/posts\/6746","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.bodhost.com\/kb\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.bodhost.com\/kb\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.bodhost.com\/kb\/wp-json\/wp\/v2\/users\/22"}],"replies":[{"embeddable":true,"href":"https:\/\/www.bodhost.com\/kb\/wp-json\/wp\/v2\/comments?post=6746"}],"version-history":[{"count":11,"href":"https:\/\/www.bodhost.com\/kb\/wp-json\/wp\/v2\/posts\/6746\/revisions"}],"predecessor-version":[{"id":12935,"href":"https:\/\/www.bodhost.com\/kb\/wp-json\/wp\/v2\/posts\/6746\/revisions\/12935"}],"wp:attachment":[{"href":"https:\/\/www.bodhost.com\/kb\/wp-json\/wp\/v2\/media?parent=6746"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.bodhost.com\/kb\/wp-json\/wp\/v2\/categories?post=6746"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.bodhost.com\/kb\/wp-json\/wp\/v2\/tags?post=6746"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}