{"id":12850,"date":"2023-11-30T08:42:19","date_gmt":"2023-11-30T08:42:19","guid":{"rendered":"https:\/\/www.bodhost.com\/kb\/?p=12850"},"modified":"2026-02-26T14:02:42","modified_gmt":"2026-02-26T14:02:42","slug":"how-to-use-whm-to-create-mysql-profiles","status":"publish","type":"post","link":"https:\/\/www.bodhost.com\/kb\/how-to-use-whm-to-create-mysql-profiles\/","title":{"rendered":"How to Use WHM to Create MySQL Profiles"},"content":{"rendered":"

This tutorial outlines the process of creating MySQL profiles via WHM. MySQL profiles govern the data linking between local or remote MySQL servers, and root users have the ability to both create and manage these profiles.<\/p>\n

Follow the steps-<\/p>\n

    \n
  1. Log in to WHM.<\/li>\n
  2. Select \u201cSQL Services\u201d option and click on the \u201cManage MySQL Profiles\u201d sub-option.
    \n\"Manage-MySQL-Profile\"<\/li>\n
  3. \u00a0Click \u201c+Add Profile\u201d button from the right side of the screen.
    \n\"+Add<\/li>\n
  4. A form type screen will open up. Fill in the information-
    \n\u00a0Profile Settings
    \n<\/strong><\/p>\n
      \n
    1. Profile Name- Enter the profile name.<\/li>\n
    2. Configuration Method- Choose the configuration method. Decide whether you want to create it automatically by generating a MySQL superuser through SSH, or manually input the credentials of an existing MySQL superuser.
      \n\"profile-name\"
      \nHost settings-
      \n<\/strong><\/p>\n
        \n
      1. Host- Input the IP address or hostname of the MySQL server.<\/li>\n
      2. SSH Port- Enter the SSH port.
        \n\"SSH-Port\"
        \nLogin Information-
        \n<\/strong><\/p>\n
          \n
        1. Username- Enter login username.
          \n\"\"
          \nAuthentication Method-
          \n<\/strong><\/p>\n
            \n
          1. If you opt for the \u201cPassword\u201d authentication method, input the \u201cPassword\u201d and \u201cEscalation Method\u201d.
            \n\"password\"<\/li>\n
          2. \u00a0If you choose \u201cSSH Key\u201d as the authentication method, input the \u201cSSH Key\u201d and \u201cEscalation Method\u201d.
            \n\"Key\"<\/li>\n
          3. Click on the \u201cSave\u201d button.<\/li>\n<\/ol>\n<\/li>\n<\/ol>\n<\/li>\n<\/ol>\n<\/li>\n<\/ol>\n<\/li>\n<\/ol>\n
            \n

            By following these steps, the new MySQL profile will be added to the list. Utilise this method to create additional MySQL\u00ae profiles using WHM. For further details, feel free to reach out to our\u00a0bodHOST\u00a0<\/a>support team.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

            This tutorial outlines the process of creating MySQL profiles via WHM. MySQL profiles govern the data linking between local or remote MySQL servers, and root users have the ability to…<\/p>\n

            Read More<\/a><\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[857],"tags":[1497,194],"class_list":["post-12850","post","type-post","status-publish","format-standard","hentry","category-sql","tag-create-mysql-profiles","tag-whm"],"yoast_head":"\nHow to Configure MySQL Profiles via WHM | bodHOST<\/title>\n<meta name=\"description\" content=\"This tutorial outlines the process of creating MySQL profiles via WHM.\" \/>\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-to-use-whm-to-create-mysql-profiles\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Configure MySQL Profiles via WHM | bodHOST\" \/>\n<meta property=\"og:description\" content=\"This tutorial outlines the process of creating MySQL profiles via WHM.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.bodhost.com\/kb\/how-to-use-whm-to-create-mysql-profiles\/\" \/>\n<meta property=\"og:site_name\" content=\"Knowledge Base - bodHOST\" \/>\n<meta property=\"article:published_time\" content=\"2023-11-30T08:42:19+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-02-26T14:02:42+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.bodhost.com\/kb\/wp-content\/uploads\/2024\/03\/Manage-MySQL-Profiles.png\" \/>\n\t<meta property=\"og:image:width\" content=\"221\" \/>\n\t<meta property=\"og:image:height\" content=\"298\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Paul Lopez\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Paul Lopez\" \/>\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-to-use-whm-to-create-mysql-profiles\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.bodhost.com\\\/kb\\\/how-to-use-whm-to-create-mysql-profiles\\\/\"},\"author\":{\"name\":\"Paul Lopez\",\"@id\":\"https:\\\/\\\/www.bodhost.com\\\/kb\\\/#\\\/schema\\\/person\\\/566ccff9a2fae4af852be8097b179813\"},\"headline\":\"How to Use WHM to Create MySQL Profiles\",\"datePublished\":\"2023-11-30T08:42:19+00:00\",\"dateModified\":\"2026-02-26T14:02:42+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.bodhost.com\\\/kb\\\/how-to-use-whm-to-create-mysql-profiles\\\/\"},\"wordCount\":223,\"publisher\":{\"@id\":\"https:\\\/\\\/www.bodhost.com\\\/kb\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.bodhost.com\\\/kb\\\/how-to-use-whm-to-create-mysql-profiles\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.bodhost.com\\\/kb\\\/wp-content\\\/uploads\\\/2024\\\/03\\\/Manage-MySQL-Profiles.png\",\"keywords\":[\"Create MySQL Profiles\",\"WHM\"],\"articleSection\":[\"SQL\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.bodhost.com\\\/kb\\\/how-to-use-whm-to-create-mysql-profiles\\\/\",\"url\":\"https:\\\/\\\/www.bodhost.com\\\/kb\\\/how-to-use-whm-to-create-mysql-profiles\\\/\",\"name\":\"How to Configure MySQL Profiles via WHM | bodHOST\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.bodhost.com\\\/kb\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.bodhost.com\\\/kb\\\/how-to-use-whm-to-create-mysql-profiles\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.bodhost.com\\\/kb\\\/how-to-use-whm-to-create-mysql-profiles\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.bodhost.com\\\/kb\\\/wp-content\\\/uploads\\\/2024\\\/03\\\/Manage-MySQL-Profiles.png\",\"datePublished\":\"2023-11-30T08:42:19+00:00\",\"dateModified\":\"2026-02-26T14:02:42+00:00\",\"description\":\"This tutorial outlines the process of creating MySQL profiles via WHM.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.bodhost.com\\\/kb\\\/how-to-use-whm-to-create-mysql-profiles\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.bodhost.com\\\/kb\\\/how-to-use-whm-to-create-mysql-profiles\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.bodhost.com\\\/kb\\\/how-to-use-whm-to-create-mysql-profiles\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.bodhost.com\\\/kb\\\/wp-content\\\/uploads\\\/2024\\\/03\\\/Manage-MySQL-Profiles.png\",\"contentUrl\":\"https:\\\/\\\/www.bodhost.com\\\/kb\\\/wp-content\\\/uploads\\\/2024\\\/03\\\/Manage-MySQL-Profiles.png\",\"width\":221,\"height\":298,\"caption\":\"Manage-MySQL-Profile\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.bodhost.com\\\/kb\\\/how-to-use-whm-to-create-mysql-profiles\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"SQL\",\"item\":\"https:\\\/\\\/www.bodhost.com\\\/kb\\\/category\\\/sql\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to Use WHM to Create MySQL Profiles\"}]},{\"@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\\\/566ccff9a2fae4af852be8097b179813\",\"name\":\"Paul Lopez\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/c63d9f5400cd5ef87b481a24b2c1a4fb89f1674b6391325326cf13f1e735dff8?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/c63d9f5400cd5ef87b481a24b2c1a4fb89f1674b6391325326cf13f1e735dff8?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/c63d9f5400cd5ef87b481a24b2c1a4fb89f1674b6391325326cf13f1e735dff8?s=96&d=mm&r=g\",\"caption\":\"Paul Lopez\"},\"url\":\"https:\\\/\\\/www.bodhost.com\\\/kb\\\/author\\\/paullopez\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to Configure MySQL Profiles via WHM | bodHOST","description":"This tutorial outlines the process of creating MySQL profiles via WHM.","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-to-use-whm-to-create-mysql-profiles\/","og_locale":"en_US","og_type":"article","og_title":"How to Configure MySQL Profiles via WHM | bodHOST","og_description":"This tutorial outlines the process of creating MySQL profiles via WHM.","og_url":"https:\/\/www.bodhost.com\/kb\/how-to-use-whm-to-create-mysql-profiles\/","og_site_name":"Knowledge Base - bodHOST","article_published_time":"2023-11-30T08:42:19+00:00","article_modified_time":"2026-02-26T14:02:42+00:00","og_image":[{"width":221,"height":298,"url":"https:\/\/www.bodhost.com\/kb\/wp-content\/uploads\/2024\/03\/Manage-MySQL-Profiles.png","type":"image\/png"}],"author":"Paul Lopez","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Paul Lopez","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.bodhost.com\/kb\/how-to-use-whm-to-create-mysql-profiles\/#article","isPartOf":{"@id":"https:\/\/www.bodhost.com\/kb\/how-to-use-whm-to-create-mysql-profiles\/"},"author":{"name":"Paul Lopez","@id":"https:\/\/www.bodhost.com\/kb\/#\/schema\/person\/566ccff9a2fae4af852be8097b179813"},"headline":"How to Use WHM to Create MySQL Profiles","datePublished":"2023-11-30T08:42:19+00:00","dateModified":"2026-02-26T14:02:42+00:00","mainEntityOfPage":{"@id":"https:\/\/www.bodhost.com\/kb\/how-to-use-whm-to-create-mysql-profiles\/"},"wordCount":223,"publisher":{"@id":"https:\/\/www.bodhost.com\/kb\/#organization"},"image":{"@id":"https:\/\/www.bodhost.com\/kb\/how-to-use-whm-to-create-mysql-profiles\/#primaryimage"},"thumbnailUrl":"https:\/\/www.bodhost.com\/kb\/wp-content\/uploads\/2024\/03\/Manage-MySQL-Profiles.png","keywords":["Create MySQL Profiles","WHM"],"articleSection":["SQL"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.bodhost.com\/kb\/how-to-use-whm-to-create-mysql-profiles\/","url":"https:\/\/www.bodhost.com\/kb\/how-to-use-whm-to-create-mysql-profiles\/","name":"How to Configure MySQL Profiles via WHM | bodHOST","isPartOf":{"@id":"https:\/\/www.bodhost.com\/kb\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.bodhost.com\/kb\/how-to-use-whm-to-create-mysql-profiles\/#primaryimage"},"image":{"@id":"https:\/\/www.bodhost.com\/kb\/how-to-use-whm-to-create-mysql-profiles\/#primaryimage"},"thumbnailUrl":"https:\/\/www.bodhost.com\/kb\/wp-content\/uploads\/2024\/03\/Manage-MySQL-Profiles.png","datePublished":"2023-11-30T08:42:19+00:00","dateModified":"2026-02-26T14:02:42+00:00","description":"This tutorial outlines the process of creating MySQL profiles via WHM.","breadcrumb":{"@id":"https:\/\/www.bodhost.com\/kb\/how-to-use-whm-to-create-mysql-profiles\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.bodhost.com\/kb\/how-to-use-whm-to-create-mysql-profiles\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.bodhost.com\/kb\/how-to-use-whm-to-create-mysql-profiles\/#primaryimage","url":"https:\/\/www.bodhost.com\/kb\/wp-content\/uploads\/2024\/03\/Manage-MySQL-Profiles.png","contentUrl":"https:\/\/www.bodhost.com\/kb\/wp-content\/uploads\/2024\/03\/Manage-MySQL-Profiles.png","width":221,"height":298,"caption":"Manage-MySQL-Profile"},{"@type":"BreadcrumbList","@id":"https:\/\/www.bodhost.com\/kb\/how-to-use-whm-to-create-mysql-profiles\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"SQL","item":"https:\/\/www.bodhost.com\/kb\/category\/sql\/"},{"@type":"ListItem","position":2,"name":"How to Use WHM to Create MySQL Profiles"}]},{"@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\/566ccff9a2fae4af852be8097b179813","name":"Paul Lopez","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/c63d9f5400cd5ef87b481a24b2c1a4fb89f1674b6391325326cf13f1e735dff8?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/c63d9f5400cd5ef87b481a24b2c1a4fb89f1674b6391325326cf13f1e735dff8?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c63d9f5400cd5ef87b481a24b2c1a4fb89f1674b6391325326cf13f1e735dff8?s=96&d=mm&r=g","caption":"Paul Lopez"},"url":"https:\/\/www.bodhost.com\/kb\/author\/paullopez\/"}]}},"_links":{"self":[{"href":"https:\/\/www.bodhost.com\/kb\/wp-json\/wp\/v2\/posts\/12850","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\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/www.bodhost.com\/kb\/wp-json\/wp\/v2\/comments?post=12850"}],"version-history":[{"count":1,"href":"https:\/\/www.bodhost.com\/kb\/wp-json\/wp\/v2\/posts\/12850\/revisions"}],"predecessor-version":[{"id":12859,"href":"https:\/\/www.bodhost.com\/kb\/wp-json\/wp\/v2\/posts\/12850\/revisions\/12859"}],"wp:attachment":[{"href":"https:\/\/www.bodhost.com\/kb\/wp-json\/wp\/v2\/media?parent=12850"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.bodhost.com\/kb\/wp-json\/wp\/v2\/categories?post=12850"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.bodhost.com\/kb\/wp-json\/wp\/v2\/tags?post=12850"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}