{"id":15334,"date":"2021-12-29T12:04:49","date_gmt":"2021-12-29T06:34:49","guid":{"rendered":"https:\/\/www.milesweb.in\/hosting-faqs\/?p=15334"},"modified":"2026-03-10T15:40:18","modified_gmt":"2026-03-10T10:10:18","slug":"create-mysql-profiles-whm","status":"publish","type":"post","link":"https:\/\/www.milesweb.in\/hosting-faqs\/create-mysql-profiles-whm\/","title":{"rendered":"How to Create MySQL\u00ae Profiles via WHM?"},"content":{"rendered":"\n<p>MySQL profiles determine all the information for the connection between the local or remote <a href=\"http:\/\/www.milesweb.in\/hosting\/mysql-hosting\">MySQL server<\/a>. With WHM, root users can create and manage new MySQL\u00ae profiles.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">To Create MySQL\u00ae Profiles<\/h2>\n\n\n\n<p>1. Log in to your WHM <em>root<\/em> account.<\/p>\n\n\n\n<p>2. Select the <strong>SQL Services<\/strong> option from the navigation menu.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><a href=\"https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2021\/09\/whm_sql_services.png\"><img decoding=\"async\" src=\"https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2021\/09\/whm_sql_services-1024x467.png\" alt=\"\" class=\"wp-image-12859\"\/><\/a><\/figure><\/div>\n\n\n<p>3. Click on <strong>Manage MySQL\u00ae Profiles<\/strong>.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><a href=\"https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2021\/12\/whm_manage_mysql_profiles.png\"><img decoding=\"async\" src=\"https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2021\/12\/whm_manage_mysql_profiles-1024x301.png\" alt=\"\" class=\"wp-image-14705\"\/><\/a><\/figure><\/div>\n\n\n<p>The list of existing MySQL\u00ae profiles will appear.<\/p>\n\n\n\n<p>4. Click on the <strong>+Add Profile<\/strong> button.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2021\/12\/whm_mysql_add_profile.png\"><img decoding=\"async\" src=\"https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2021\/12\/whm_mysql_add_profile-1024x304.png\" alt=\"\" class=\"wp-image-14706\"\/><\/a><\/figure>\n\n\n\n<p>A form will appear with these fields:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Profile Name<\/strong>: Name for the MySQL profile<\/li>\n\n\n\n<li><strong>Configuration Method<\/strong>: Choose if you want to automatically or manually create a MySQL superuser<\/li>\n\n\n\n<li><strong>Host<\/strong>: Enter the IP address or hostname of the MySQL server<\/li>\n\n\n\n<li><strong>SSH Port<\/strong>: SSH server port<\/li>\n\n\n\n<li><strong>Username<\/strong>: Login user <\/li>\n\n\n\n<li><strong>Authentication Method<\/strong>: Choose to login by <em>Password\/SSH<\/em> <em>Key<\/em><\/li>\n\n\n\n<li><strong>Password<\/strong>: Password for profile(If selected <strong>Authentication Method<\/strong> is <em>Password<\/em><\/li>\n\n\n\n<li><strong>Escalation Method<\/strong>: Enhance privileges for non-root users to access MySQL superuser account<\/li>\n<\/ul>\n\n\n\n<p>5. Enter the appropriate details in the fields and click on <strong>Save<\/strong>.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2021\/12\/whm_save_mysql_profile.png\"><img decoding=\"async\" src=\"https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2021\/12\/whm_save_mysql_profile.png\" alt=\"\" class=\"wp-image-14707\"\/><\/a><\/figure>\n\n\n\n<p>The system will save the details and add the new profile to the list.<\/p>\n\n\n\n<p>You can use this method and create new MySQL\u00ae profiles with WHM.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>MySQL profiles determine all the information for the connection between the local or remote MySQL server. With WHM, root users can create and manage new MySQL\u00ae profiles. To Create MySQL\u00ae Profiles 1. Log in to your WHM root account. 2. Select the SQL Services option from the navigation menu. 3. Click on Manage MySQL\u00ae Profiles. [&hellip;]<\/p>\n","protected":false},"author":27,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[41,967,229],"tags":[2896,2897,2426,541,999,1639,1446],"class_list":["post-15334","post","type-post","status-publish","format-standard","placeholder-for-hentry","category-howtos","category-mysql","category-whm","tag-create-mysql-profiles-whm","tag-mysql-profile","tag-mysql-server","tag-remote-mysql","tag-sql","tag-whm-hosting-account","tag-whm-root"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.1.1 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Create MySQL\u00ae Profiles via WHM - Web Hosting FAQs by MilesWeb<\/title>\n<meta name=\"description\" content=\"As a WHM root user, you can create and MySQL\u00ae profiles for your remote SQL servers. Click the article to know more.\" \/>\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.milesweb.in\/hosting-faqs\/create-mysql-profiles-whm\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Create MySQL\u00ae Profiles via WHM - Web Hosting FAQs by MilesWeb\" \/>\n<meta property=\"og:description\" content=\"As a WHM root user, you can create and MySQL\u00ae profiles for your remote SQL servers. Click the article to know more.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.milesweb.in\/hosting-faqs\/create-mysql-profiles-whm\/\" \/>\n<meta property=\"og:site_name\" content=\"Web Hosting FAQs by MilesWeb\" \/>\n<meta property=\"article:published_time\" content=\"2021-12-29T06:34:49+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-03-10T10:10:18+00:00\" \/>\n<meta name=\"author\" content=\"Prasad Khartadkar\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Prasad Khartadkar\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.milesweb.in\/hosting-faqs\/create-mysql-profiles-whm\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.milesweb.in\/hosting-faqs\/create-mysql-profiles-whm\/\"},\"author\":{\"name\":\"Prasad Khartadkar\",\"@id\":\"https:\/\/www.milesweb.in\/hosting-faqs\/#\/schema\/person\/c9138a9488172a8d0aa2d4f40878d83e\"},\"headline\":\"How to Create MySQL\u00ae Profiles via WHM?\",\"datePublished\":\"2021-12-29T06:34:49+00:00\",\"dateModified\":\"2026-03-10T10:10:18+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.milesweb.in\/hosting-faqs\/create-mysql-profiles-whm\/\"},\"wordCount\":188,\"commentCount\":0,\"image\":{\"@id\":\"https:\/\/www.milesweb.in\/hosting-faqs\/create-mysql-profiles-whm\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2021\/09\/whm_sql_services-1024x467.png\",\"keywords\":[\"create mysql profiles whm\",\"mysql profile\",\"MySQL server\",\"remote MySQL\",\"sql\",\"whm hosting account\",\"whm root\"],\"articleSection\":[\"How-Tos\",\"MySQL\",\"Web Host Manager\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.milesweb.in\/hosting-faqs\/create-mysql-profiles-whm\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.milesweb.in\/hosting-faqs\/create-mysql-profiles-whm\/\",\"url\":\"https:\/\/www.milesweb.in\/hosting-faqs\/create-mysql-profiles-whm\/\",\"name\":\"Create MySQL\u00ae Profiles via WHM - Web Hosting FAQs by MilesWeb\",\"isPartOf\":{\"@id\":\"https:\/\/www.milesweb.in\/hosting-faqs\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.milesweb.in\/hosting-faqs\/create-mysql-profiles-whm\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.milesweb.in\/hosting-faqs\/create-mysql-profiles-whm\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2021\/09\/whm_sql_services-1024x467.png\",\"datePublished\":\"2021-12-29T06:34:49+00:00\",\"dateModified\":\"2026-03-10T10:10:18+00:00\",\"author\":{\"@id\":\"https:\/\/www.milesweb.in\/hosting-faqs\/#\/schema\/person\/c9138a9488172a8d0aa2d4f40878d83e\"},\"description\":\"As a WHM root user, you can create and MySQL\u00ae profiles for your remote SQL servers. Click the article to know more.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.milesweb.in\/hosting-faqs\/create-mysql-profiles-whm\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.milesweb.in\/hosting-faqs\/create-mysql-profiles-whm\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.milesweb.in\/hosting-faqs\/create-mysql-profiles-whm\/#primaryimage\",\"url\":\"https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2021\/09\/whm_sql_services.png\",\"contentUrl\":\"https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2021\/09\/whm_sql_services.png\",\"width\":1599,\"height\":730},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.milesweb.in\/hosting-faqs\/create-mysql-profiles-whm\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.milesweb.in\/hosting-faqs\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to Create MySQL\u00ae Profiles via WHM?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.milesweb.in\/hosting-faqs\/#website\",\"url\":\"https:\/\/www.milesweb.in\/hosting-faqs\/\",\"name\":\"Web Hosting FAQs by MilesWeb\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.milesweb.in\/hosting-faqs\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.milesweb.in\/hosting-faqs\/#\/schema\/person\/c9138a9488172a8d0aa2d4f40878d83e\",\"name\":\"Prasad Khartadkar\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.milesweb.in\/hosting-faqs\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2021\/08\/Prasad-K.-1-150x150.jpg\",\"contentUrl\":\"https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2021\/08\/Prasad-K.-1-150x150.jpg\",\"caption\":\"Prasad Khartadkar\"},\"description\":\"Prasad is a business grad specialized in Marketing. He has garnered experience as a technical content writer and a digital marketer that he brings out in his work. He likes reading classics and travel in his free time.\",\"sameAs\":[\"https:\/\/www.milesweb.in\"],\"url\":\"https:\/\/www.milesweb.in\/hosting-faqs\/author\/prasad-khartadkar\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Create MySQL\u00ae Profiles via WHM - Web Hosting FAQs by MilesWeb","description":"As a WHM root user, you can create and MySQL\u00ae profiles for your remote SQL servers. Click the article to know more.","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.milesweb.in\/hosting-faqs\/create-mysql-profiles-whm\/","og_locale":"en_US","og_type":"article","og_title":"Create MySQL\u00ae Profiles via WHM - Web Hosting FAQs by MilesWeb","og_description":"As a WHM root user, you can create and MySQL\u00ae profiles for your remote SQL servers. Click the article to know more.","og_url":"https:\/\/www.milesweb.in\/hosting-faqs\/create-mysql-profiles-whm\/","og_site_name":"Web Hosting FAQs by MilesWeb","article_published_time":"2021-12-29T06:34:49+00:00","article_modified_time":"2026-03-10T10:10:18+00:00","author":"Prasad Khartadkar","twitter_misc":{"Written by":"Prasad Khartadkar","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.milesweb.in\/hosting-faqs\/create-mysql-profiles-whm\/#article","isPartOf":{"@id":"https:\/\/www.milesweb.in\/hosting-faqs\/create-mysql-profiles-whm\/"},"author":{"name":"Prasad Khartadkar","@id":"https:\/\/www.milesweb.in\/hosting-faqs\/#\/schema\/person\/c9138a9488172a8d0aa2d4f40878d83e"},"headline":"How to Create MySQL\u00ae Profiles via WHM?","datePublished":"2021-12-29T06:34:49+00:00","dateModified":"2026-03-10T10:10:18+00:00","mainEntityOfPage":{"@id":"https:\/\/www.milesweb.in\/hosting-faqs\/create-mysql-profiles-whm\/"},"wordCount":188,"commentCount":0,"image":{"@id":"https:\/\/www.milesweb.in\/hosting-faqs\/create-mysql-profiles-whm\/#primaryimage"},"thumbnailUrl":"https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2021\/09\/whm_sql_services-1024x467.png","keywords":["create mysql profiles whm","mysql profile","MySQL server","remote MySQL","sql","whm hosting account","whm root"],"articleSection":["How-Tos","MySQL","Web Host Manager"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.milesweb.in\/hosting-faqs\/create-mysql-profiles-whm\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.milesweb.in\/hosting-faqs\/create-mysql-profiles-whm\/","url":"https:\/\/www.milesweb.in\/hosting-faqs\/create-mysql-profiles-whm\/","name":"Create MySQL\u00ae Profiles via WHM - Web Hosting FAQs by MilesWeb","isPartOf":{"@id":"https:\/\/www.milesweb.in\/hosting-faqs\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.milesweb.in\/hosting-faqs\/create-mysql-profiles-whm\/#primaryimage"},"image":{"@id":"https:\/\/www.milesweb.in\/hosting-faqs\/create-mysql-profiles-whm\/#primaryimage"},"thumbnailUrl":"https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2021\/09\/whm_sql_services-1024x467.png","datePublished":"2021-12-29T06:34:49+00:00","dateModified":"2026-03-10T10:10:18+00:00","author":{"@id":"https:\/\/www.milesweb.in\/hosting-faqs\/#\/schema\/person\/c9138a9488172a8d0aa2d4f40878d83e"},"description":"As a WHM root user, you can create and MySQL\u00ae profiles for your remote SQL servers. Click the article to know more.","breadcrumb":{"@id":"https:\/\/www.milesweb.in\/hosting-faqs\/create-mysql-profiles-whm\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.milesweb.in\/hosting-faqs\/create-mysql-profiles-whm\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.milesweb.in\/hosting-faqs\/create-mysql-profiles-whm\/#primaryimage","url":"https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2021\/09\/whm_sql_services.png","contentUrl":"https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2021\/09\/whm_sql_services.png","width":1599,"height":730},{"@type":"BreadcrumbList","@id":"https:\/\/www.milesweb.in\/hosting-faqs\/create-mysql-profiles-whm\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.milesweb.in\/hosting-faqs\/"},{"@type":"ListItem","position":2,"name":"How to Create MySQL\u00ae Profiles via WHM?"}]},{"@type":"WebSite","@id":"https:\/\/www.milesweb.in\/hosting-faqs\/#website","url":"https:\/\/www.milesweb.in\/hosting-faqs\/","name":"Web Hosting FAQs by MilesWeb","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.milesweb.in\/hosting-faqs\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.milesweb.in\/hosting-faqs\/#\/schema\/person\/c9138a9488172a8d0aa2d4f40878d83e","name":"Prasad Khartadkar","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.milesweb.in\/hosting-faqs\/#\/schema\/person\/image\/","url":"https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2021\/08\/Prasad-K.-1-150x150.jpg","contentUrl":"https:\/\/www.milesweb.in\/hosting-faqs\/wp-content\/uploads\/2021\/08\/Prasad-K.-1-150x150.jpg","caption":"Prasad Khartadkar"},"description":"Prasad is a business grad specialized in Marketing. He has garnered experience as a technical content writer and a digital marketer that he brings out in his work. He likes reading classics and travel in his free time.","sameAs":["https:\/\/www.milesweb.in"],"url":"https:\/\/www.milesweb.in\/hosting-faqs\/author\/prasad-khartadkar\/"}]}},"_links":{"self":[{"href":"https:\/\/www.milesweb.in\/hosting-faqs\/wp-json\/wp\/v2\/posts\/15334","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.milesweb.in\/hosting-faqs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.milesweb.in\/hosting-faqs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.milesweb.in\/hosting-faqs\/wp-json\/wp\/v2\/users\/27"}],"replies":[{"embeddable":true,"href":"https:\/\/www.milesweb.in\/hosting-faqs\/wp-json\/wp\/v2\/comments?post=15334"}],"version-history":[{"count":2,"href":"https:\/\/www.milesweb.in\/hosting-faqs\/wp-json\/wp\/v2\/posts\/15334\/revisions"}],"predecessor-version":[{"id":20057,"href":"https:\/\/www.milesweb.in\/hosting-faqs\/wp-json\/wp\/v2\/posts\/15334\/revisions\/20057"}],"wp:attachment":[{"href":"https:\/\/www.milesweb.in\/hosting-faqs\/wp-json\/wp\/v2\/media?parent=15334"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.milesweb.in\/hosting-faqs\/wp-json\/wp\/v2\/categories?post=15334"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.milesweb.in\/hosting-faqs\/wp-json\/wp\/v2\/tags?post=15334"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}