{"id":14338,"date":"2023-08-15T10:31:03","date_gmt":"2023-08-15T10:31:03","guid":{"rendered":"https:\/\/www.webhosting.uk.com\/kb\/?p=14338"},"modified":"2026-03-03T11:38:52","modified_gmt":"2026-03-03T11:38:52","slug":"how-to-add-mysql-access-hosts-in-whm","status":"publish","type":"post","link":"https:\/\/www.webhosting.uk.com\/kb\/how-to-add-mysql-access-hosts-in-whm\/","title":{"rendered":"How to add MySQL access hosts in WHM"},"content":{"rendered":"

This article will explain how to add MySQL access hosts in WHM. WHM allows you to specify specific hostnames and IP addresses for automatic inclusion across all users and databases on your server using the MySQL Access Hosts tool.<\/p>\n

Follow the steps-<\/p>\n

    \n
  1. Log in to WHM.<\/li>\n
  2. Select \u201cAdditional MySQL Access Hosts\u201d sub-option under \u201cSQL services\u201d.
    \n\"Additional<\/li>\n
  3. Here, you can add hosts as you want. You should add one on each line.<\/li>\n
  4. Finally, click on the \u201cSave\u201d button.
    \n\"Save\"<\/li>\n
  5. MySQL Access Hosts have been saved. However, one more step is to be followed.
    \n\"MySQL\"<\/li>\n
  6. Go back to the main page. To activate added hosts, users are supposed to log in to their cPanel accounts and enter the MySQL Manager. A tool is available that provides an alternative method to bypass this if desired.<\/li>\n
  7. Click on the link \u201cClick here\u201d below save button.
    \n\"Save\"<\/li>\n
  8. The update is complete, and all accounts on the server now utilise the new hosts.
    \n\"updating\"<\/li>\n<\/ol>\n

    In this manner, you can add MySQL access hosts in WHM. For more information, get in touch with our technical support team.<\/p>\n","protected":false},"excerpt":{"rendered":"

    This article will explain how to add MySQL access hosts in WHM. WHM allows you to specify specific hostnames and IP addresses for automatic inclusion across all users and databases…<\/p>\n

    Read More<\/a><\/p>\n

    <\/div>
    Spread the love<\/div>
    <\/path><\/svg><\/span><\/a><\/path><\/svg><\/span><\/a><\/path><\/svg><\/span><\/a><\/div>
    <\/div><\/div>
    <\/div>","protected":false},"author":28,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1322],"tags":[300,212],"class_list":["post-14338","post","type-post","status-publish","format-standard","hentry","category-database","tag-mysql","tag-whm"],"yoast_head":"\nAdd MySQL Access Hosts in WHM<\/title>\n<meta name=\"description\" content=\"Learn how to add MySQL access hosts in WHM to allow secure remote connections and manage database access for your server effectively\" \/>\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.webhosting.uk.com\/kb\/how-to-add-mysql-access-hosts-in-whm\/\" \/>\n<meta property=\"og:locale\" content=\"en_GB\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to add MySQL access hosts in WHM\" \/>\n<meta property=\"og:description\" content=\"Learn how to add MySQL access hosts in WHM to allow secure remote connections and manage database access for your server effectively\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.webhosting.uk.com\/kb\/how-to-add-mysql-access-hosts-in-whm\/\" \/>\n<meta property=\"og:site_name\" content=\"Webhosting UK Knowledge Base\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/webhostingukcom\" \/>\n<meta property=\"article:published_time\" content=\"2023-08-15T10:31:03+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-03-03T11:38:52+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.webhosting.uk.com\/kb\/wp-content\/uploads\/2023\/08\/Pasted-14.png\" \/>\n\t<meta property=\"og:image:width\" content=\"234\" \/>\n\t<meta property=\"og:image:height\" content=\"371\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Victor G\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@WebhostingUKcom\" \/>\n<meta name=\"twitter:site\" content=\"@WebhostingUKcom\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.webhosting.uk.com\\\/kb\\\/how-to-add-mysql-access-hosts-in-whm\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.webhosting.uk.com\\\/kb\\\/how-to-add-mysql-access-hosts-in-whm\\\/\"},\"author\":{\"name\":\"Victor G\",\"@id\":\"https:\\\/\\\/www.webhosting.uk.com\\\/kb\\\/#\\\/schema\\\/person\\\/ea067684eae84c2b8b49a81c69407297\"},\"headline\":\"How to add MySQL access hosts in WHM\",\"datePublished\":\"2023-08-15T10:31:03+00:00\",\"dateModified\":\"2026-03-03T11:38:52+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.webhosting.uk.com\\\/kb\\\/how-to-add-mysql-access-hosts-in-whm\\\/\"},\"wordCount\":183,\"publisher\":{\"@id\":\"https:\\\/\\\/www.webhosting.uk.com\\\/kb\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.webhosting.uk.com\\\/kb\\\/how-to-add-mysql-access-hosts-in-whm\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.webhosting.uk.com\\\/kb\\\/wp-content\\\/uploads\\\/2023\\\/08\\\/Pasted-14.png\",\"keywords\":[\"MySQL\",\"WHM\"],\"articleSection\":[\"MySQL\"],\"inLanguage\":\"en-GB\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.webhosting.uk.com\\\/kb\\\/how-to-add-mysql-access-hosts-in-whm\\\/\",\"url\":\"https:\\\/\\\/www.webhosting.uk.com\\\/kb\\\/how-to-add-mysql-access-hosts-in-whm\\\/\",\"name\":\"Add MySQL Access Hosts in WHM\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.webhosting.uk.com\\\/kb\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.webhosting.uk.com\\\/kb\\\/how-to-add-mysql-access-hosts-in-whm\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.webhosting.uk.com\\\/kb\\\/how-to-add-mysql-access-hosts-in-whm\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.webhosting.uk.com\\\/kb\\\/wp-content\\\/uploads\\\/2023\\\/08\\\/Pasted-14.png\",\"datePublished\":\"2023-08-15T10:31:03+00:00\",\"dateModified\":\"2026-03-03T11:38:52+00:00\",\"description\":\"Learn how to add MySQL access hosts in WHM to allow secure remote connections and manage database access for your server effectively\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.webhosting.uk.com\\\/kb\\\/how-to-add-mysql-access-hosts-in-whm\\\/#breadcrumb\"},\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.webhosting.uk.com\\\/kb\\\/how-to-add-mysql-access-hosts-in-whm\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\\\/\\\/www.webhosting.uk.com\\\/kb\\\/how-to-add-mysql-access-hosts-in-whm\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.webhosting.uk.com\\\/kb\\\/wp-content\\\/uploads\\\/2023\\\/08\\\/Pasted-14.png\",\"contentUrl\":\"https:\\\/\\\/www.webhosting.uk.com\\\/kb\\\/wp-content\\\/uploads\\\/2023\\\/08\\\/Pasted-14.png\",\"width\":234,\"height\":371},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.webhosting.uk.com\\\/kb\\\/how-to-add-mysql-access-hosts-in-whm\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.webhosting.uk.com\\\/kb\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to add MySQL access hosts in WHM\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.webhosting.uk.com\\\/kb\\\/#website\",\"url\":\"https:\\\/\\\/www.webhosting.uk.com\\\/kb\\\/\",\"name\":\"Webhosting UK Knowledge Base\",\"description\":\"Expert Insights on Hosting, Development, Security, Marketing, and SEO\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.webhosting.uk.com\\\/kb\\\/#organization\"},\"alternateName\":\"WHUK\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.webhosting.uk.com\\\/kb\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-GB\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.webhosting.uk.com\\\/kb\\\/#organization\",\"name\":\"Webhosting UK\",\"alternateName\":\"WHUK\",\"url\":\"https:\\\/\\\/www.webhosting.uk.com\\\/kb\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\\\/\\\/www.webhosting.uk.com\\\/kb\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.webhosting.uk.com\\\/kb\\\/wp-content\\\/uploads\\\/2023\\\/08\\\/WHUK-logo-1.png\",\"contentUrl\":\"https:\\\/\\\/www.webhosting.uk.com\\\/kb\\\/wp-content\\\/uploads\\\/2023\\\/08\\\/WHUK-logo-1.png\",\"width\":1200,\"height\":628,\"caption\":\"Webhosting UK\"},\"image\":{\"@id\":\"https:\\\/\\\/www.webhosting.uk.com\\\/kb\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/webhostingukcom\",\"https:\\\/\\\/x.com\\\/WebhostingUKcom\",\"https:\\\/\\\/www.youtube.com\\\/c\\\/webhostinguk\",\"https:\\\/\\\/www.linkedin.com\\\/company\\\/webhosting-uk-com-ltd\\\/\",\"https:\\\/\\\/www.instagram.com\\\/webhosting_uk\\\/\",\"https:\\\/\\\/www.tiktok.com\\\/@webhostinguk\"],\"description\":\"Fast, reliable, and cost-effective website hosting services with Webhosting UK. Committed to providing you secure support around the clock.\",\"email\":\"sales@webhosting.uk.com\",\"telephone\":\"0800 862 0890\",\"legalName\":\"Webhosting UK\",\"foundingDate\":\"2001-02-07\",\"numberOfEmployees\":{\"@type\":\"QuantitativeValue\",\"minValue\":\"51\",\"maxValue\":\"200\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.webhosting.uk.com\\\/kb\\\/#\\\/schema\\\/person\\\/ea067684eae84c2b8b49a81c69407297\",\"name\":\"Victor G\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/9bf0713adcbaded4878508c93d93927ecbfa4f74548fd9bcee41478d8768bd66?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/9bf0713adcbaded4878508c93d93927ecbfa4f74548fd9bcee41478d8768bd66?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/9bf0713adcbaded4878508c93d93927ecbfa4f74548fd9bcee41478d8768bd66?s=96&d=mm&r=g\",\"caption\":\"Victor G\"}}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Add MySQL Access Hosts in WHM","description":"Learn how to add MySQL access hosts in WHM to allow secure remote connections and manage database access for your server effectively","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.webhosting.uk.com\/kb\/how-to-add-mysql-access-hosts-in-whm\/","og_locale":"en_GB","og_type":"article","og_title":"How to add MySQL access hosts in WHM","og_description":"Learn how to add MySQL access hosts in WHM to allow secure remote connections and manage database access for your server effectively","og_url":"https:\/\/www.webhosting.uk.com\/kb\/how-to-add-mysql-access-hosts-in-whm\/","og_site_name":"Webhosting UK Knowledge Base","article_publisher":"https:\/\/www.facebook.com\/webhostingukcom","article_published_time":"2023-08-15T10:31:03+00:00","article_modified_time":"2026-03-03T11:38:52+00:00","og_image":[{"width":234,"height":371,"url":"https:\/\/www.webhosting.uk.com\/kb\/wp-content\/uploads\/2023\/08\/Pasted-14.png","type":"image\/png"}],"author":"Victor G","twitter_card":"summary_large_image","twitter_creator":"@WebhostingUKcom","twitter_site":"@WebhostingUKcom","schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.webhosting.uk.com\/kb\/how-to-add-mysql-access-hosts-in-whm\/#article","isPartOf":{"@id":"https:\/\/www.webhosting.uk.com\/kb\/how-to-add-mysql-access-hosts-in-whm\/"},"author":{"name":"Victor G","@id":"https:\/\/www.webhosting.uk.com\/kb\/#\/schema\/person\/ea067684eae84c2b8b49a81c69407297"},"headline":"How to add MySQL access hosts in WHM","datePublished":"2023-08-15T10:31:03+00:00","dateModified":"2026-03-03T11:38:52+00:00","mainEntityOfPage":{"@id":"https:\/\/www.webhosting.uk.com\/kb\/how-to-add-mysql-access-hosts-in-whm\/"},"wordCount":183,"publisher":{"@id":"https:\/\/www.webhosting.uk.com\/kb\/#organization"},"image":{"@id":"https:\/\/www.webhosting.uk.com\/kb\/how-to-add-mysql-access-hosts-in-whm\/#primaryimage"},"thumbnailUrl":"https:\/\/www.webhosting.uk.com\/kb\/wp-content\/uploads\/2023\/08\/Pasted-14.png","keywords":["MySQL","WHM"],"articleSection":["MySQL"],"inLanguage":"en-GB"},{"@type":"WebPage","@id":"https:\/\/www.webhosting.uk.com\/kb\/how-to-add-mysql-access-hosts-in-whm\/","url":"https:\/\/www.webhosting.uk.com\/kb\/how-to-add-mysql-access-hosts-in-whm\/","name":"Add MySQL Access Hosts in WHM","isPartOf":{"@id":"https:\/\/www.webhosting.uk.com\/kb\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.webhosting.uk.com\/kb\/how-to-add-mysql-access-hosts-in-whm\/#primaryimage"},"image":{"@id":"https:\/\/www.webhosting.uk.com\/kb\/how-to-add-mysql-access-hosts-in-whm\/#primaryimage"},"thumbnailUrl":"https:\/\/www.webhosting.uk.com\/kb\/wp-content\/uploads\/2023\/08\/Pasted-14.png","datePublished":"2023-08-15T10:31:03+00:00","dateModified":"2026-03-03T11:38:52+00:00","description":"Learn how to add MySQL access hosts in WHM to allow secure remote connections and manage database access for your server effectively","breadcrumb":{"@id":"https:\/\/www.webhosting.uk.com\/kb\/how-to-add-mysql-access-hosts-in-whm\/#breadcrumb"},"inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.webhosting.uk.com\/kb\/how-to-add-mysql-access-hosts-in-whm\/"]}]},{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/www.webhosting.uk.com\/kb\/how-to-add-mysql-access-hosts-in-whm\/#primaryimage","url":"https:\/\/www.webhosting.uk.com\/kb\/wp-content\/uploads\/2023\/08\/Pasted-14.png","contentUrl":"https:\/\/www.webhosting.uk.com\/kb\/wp-content\/uploads\/2023\/08\/Pasted-14.png","width":234,"height":371},{"@type":"BreadcrumbList","@id":"https:\/\/www.webhosting.uk.com\/kb\/how-to-add-mysql-access-hosts-in-whm\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.webhosting.uk.com\/kb\/"},{"@type":"ListItem","position":2,"name":"How to add MySQL access hosts in WHM"}]},{"@type":"WebSite","@id":"https:\/\/www.webhosting.uk.com\/kb\/#website","url":"https:\/\/www.webhosting.uk.com\/kb\/","name":"Webhosting UK Knowledge Base","description":"Expert Insights on Hosting, Development, Security, Marketing, and SEO","publisher":{"@id":"https:\/\/www.webhosting.uk.com\/kb\/#organization"},"alternateName":"WHUK","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.webhosting.uk.com\/kb\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-GB"},{"@type":"Organization","@id":"https:\/\/www.webhosting.uk.com\/kb\/#organization","name":"Webhosting UK","alternateName":"WHUK","url":"https:\/\/www.webhosting.uk.com\/kb\/","logo":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/www.webhosting.uk.com\/kb\/#\/schema\/logo\/image\/","url":"https:\/\/www.webhosting.uk.com\/kb\/wp-content\/uploads\/2023\/08\/WHUK-logo-1.png","contentUrl":"https:\/\/www.webhosting.uk.com\/kb\/wp-content\/uploads\/2023\/08\/WHUK-logo-1.png","width":1200,"height":628,"caption":"Webhosting UK"},"image":{"@id":"https:\/\/www.webhosting.uk.com\/kb\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/webhostingukcom","https:\/\/x.com\/WebhostingUKcom","https:\/\/www.youtube.com\/c\/webhostinguk","https:\/\/www.linkedin.com\/company\/webhosting-uk-com-ltd\/","https:\/\/www.instagram.com\/webhosting_uk\/","https:\/\/www.tiktok.com\/@webhostinguk"],"description":"Fast, reliable, and cost-effective website hosting services with Webhosting UK. Committed to providing you secure support around the clock.","email":"sales@webhosting.uk.com","telephone":"0800 862 0890","legalName":"Webhosting UK","foundingDate":"2001-02-07","numberOfEmployees":{"@type":"QuantitativeValue","minValue":"51","maxValue":"200"}},{"@type":"Person","@id":"https:\/\/www.webhosting.uk.com\/kb\/#\/schema\/person\/ea067684eae84c2b8b49a81c69407297","name":"Victor G","image":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/secure.gravatar.com\/avatar\/9bf0713adcbaded4878508c93d93927ecbfa4f74548fd9bcee41478d8768bd66?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/9bf0713adcbaded4878508c93d93927ecbfa4f74548fd9bcee41478d8768bd66?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/9bf0713adcbaded4878508c93d93927ecbfa4f74548fd9bcee41478d8768bd66?s=96&d=mm&r=g","caption":"Victor G"}}]}},"_links":{"self":[{"href":"https:\/\/www.webhosting.uk.com\/kb\/wp-json\/wp\/v2\/posts\/14338","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.webhosting.uk.com\/kb\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.webhosting.uk.com\/kb\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.webhosting.uk.com\/kb\/wp-json\/wp\/v2\/users\/28"}],"replies":[{"embeddable":true,"href":"https:\/\/www.webhosting.uk.com\/kb\/wp-json\/wp\/v2\/comments?post=14338"}],"version-history":[{"count":3,"href":"https:\/\/www.webhosting.uk.com\/kb\/wp-json\/wp\/v2\/posts\/14338\/revisions"}],"predecessor-version":[{"id":14426,"href":"https:\/\/www.webhosting.uk.com\/kb\/wp-json\/wp\/v2\/posts\/14338\/revisions\/14426"}],"wp:attachment":[{"href":"https:\/\/www.webhosting.uk.com\/kb\/wp-json\/wp\/v2\/media?parent=14338"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.webhosting.uk.com\/kb\/wp-json\/wp\/v2\/categories?post=14338"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.webhosting.uk.com\/kb\/wp-json\/wp\/v2\/tags?post=14338"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}