{"id":11403,"date":"2021-08-25T09:51:31","date_gmt":"2021-08-25T09:51:31","guid":{"rendered":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/?p=11403"},"modified":"2024-04-24T07:34:49","modified_gmt":"2024-04-24T06:34:49","slug":"disable-username-prefix-databases-database-users-whm","status":"publish","type":"post","link":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/disable-username-prefix-databases-database-users-whm\/","title":{"rendered":"How to Disable Username Prefix for Databases and Database Users in WHM?"},"content":{"rendered":"<p>In cPanel, the names and usernames of databases are prefixed with the account&#8217;s username. To add username prefix is a default setting that you can disable from the WHM panel.<\/p>\n<h2>To Disable Username Prefix for Databases and Database Users<\/h2>\n<p>1. Log in to the WHM panel with your root account.<\/p>\n<p>2. Select <strong>Server Configuration<\/strong> from the navigation menu.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-11806\" src=\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2021\/06\/whm_server_conf.png\" alt=\"\" width=\"1919\" height=\"718\" \/><\/p>\n<p>3. Click on <strong>Tweak Settings<\/strong>.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-12040\" src=\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2021\/06\/whm_tweak_settings.png\" alt=\"\" width=\"1420\" height=\"720\" \/><\/p>\n<p>A panel with many configuration options will appear.<\/p>\n<p>4. Select the <strong>SQL<\/strong> tab.<\/p>\n<p>Here, you will find various options to manage SQL-related settings.<\/p>\n<p>5. Look for the <strong>Require a username prefix on names of new databases and database users\u00a0<\/strong>option and click on the <strong>Off<\/strong> button.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-12631\" src=\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2021\/08\/whm_sql_username_prefix.jpg\" alt=\"\" width=\"1372\" height=\"666\" \/><\/p>\n<p>6. Click the <strong>Save<\/strong> button at the bottom.<\/p>\n<p>With it, the WHM panel will save the settings and disable the username prefixes on names for new databases and database users.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>In cPanel, the names and usernames of databases are prefixed with the account&#8217;s username. To add username prefix is a default setting that you can disable from the WHM panel. To Disable Username Prefix for Databases and Database Users 1. Log in to the WHM panel with your root account. 2. Select Server Configuration from [&hellip;]<\/p>\n","protected":false},"author":27,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[9,41,229],"tags":[152,2374,2400,979,2401,175,194],"class_list":["post-11403","post","type-post","status-publish","format-standard","placeholder-for-hentry","category-cpanel-faq","category-howtos","category-whm","tag-cpanel","tag-cpanel-server","tag-disable-username-prefix","tag-sql","tag-sql-settings","tag-whm","tag-whm-settings"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.2 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Disable Username Prefix for Databases and Database Users in WHM<\/title>\n<meta name=\"description\" content=\"This article will show you the steps to disable username prefix for names and usernames of newly created cPanel databases with 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.milesweb.co.uk\/hosting-faqs\/disable-username-prefix-databases-database-users-whm\/\" \/>\n<meta property=\"og:locale\" content=\"en_GB\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Disable Username Prefix for Databases and Database Users in WHM\" \/>\n<meta property=\"og:description\" content=\"This article will show you the steps to disable username prefix for names and usernames of newly created cPanel databases with WHM.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/disable-username-prefix-databases-database-users-whm\/\" \/>\n<meta property=\"og:site_name\" content=\"Web Hosting FAQs by MilesWeb\" \/>\n<meta property=\"article:published_time\" content=\"2021-08-25T09:51:31+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-04-24T06:34:49+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2021\/06\/whm_server_conf.png\" \/>\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=\"Estimated 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\":\"WebPage\",\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/disable-username-prefix-databases-database-users-whm\/\",\"url\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/disable-username-prefix-databases-database-users-whm\/\",\"name\":\"Disable Username Prefix for Databases and Database Users in WHM\",\"isPartOf\":{\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/disable-username-prefix-databases-database-users-whm\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/disable-username-prefix-databases-database-users-whm\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2021\/06\/whm_server_conf.png\",\"datePublished\":\"2021-08-25T09:51:31+00:00\",\"dateModified\":\"2024-04-24T06:34:49+00:00\",\"author\":{\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#\/schema\/person\/c9138a9488172a8d0aa2d4f40878d83e\"},\"description\":\"This article will show you the steps to disable username prefix for names and usernames of newly created cPanel databases with WHM.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/disable-username-prefix-databases-database-users-whm\/#breadcrumb\"},\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/disable-username-prefix-databases-database-users-whm\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/disable-username-prefix-databases-database-users-whm\/#primaryimage\",\"url\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2021\/06\/whm_server_conf.png\",\"contentUrl\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2021\/06\/whm_server_conf.png\",\"width\":1919,\"height\":718},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/disable-username-prefix-databases-database-users-whm\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to Disable Username Prefix for Databases and Database Users in WHM?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#website\",\"url\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/\",\"name\":\"Web Hosting FAQs by MilesWeb\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-GB\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#\/schema\/person\/c9138a9488172a8d0aa2d4f40878d83e\",\"name\":\"Prasad Khartadkar\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/fafb102a39aa8f8d38a11f3e2dcfa746?s=96&d=blank&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/fafb102a39aa8f8d38a11f3e2dcfa746?s=96&d=blank&r=g\",\"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.\",\"url\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/author\/prasad-khartadkar\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Disable Username Prefix for Databases and Database Users in WHM","description":"This article will show you the steps to disable username prefix for names and usernames of newly created cPanel databases with 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.milesweb.co.uk\/hosting-faqs\/disable-username-prefix-databases-database-users-whm\/","og_locale":"en_GB","og_type":"article","og_title":"Disable Username Prefix for Databases and Database Users in WHM","og_description":"This article will show you the steps to disable username prefix for names and usernames of newly created cPanel databases with WHM.","og_url":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/disable-username-prefix-databases-database-users-whm\/","og_site_name":"Web Hosting FAQs by MilesWeb","article_published_time":"2021-08-25T09:51:31+00:00","article_modified_time":"2024-04-24T06:34:49+00:00","og_image":[{"url":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2021\/06\/whm_server_conf.png","type":"","width":"","height":""}],"author":"Prasad Khartadkar","twitter_misc":{"Written by":"Prasad Khartadkar","Estimated reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/disable-username-prefix-databases-database-users-whm\/","url":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/disable-username-prefix-databases-database-users-whm\/","name":"Disable Username Prefix for Databases and Database Users in WHM","isPartOf":{"@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/disable-username-prefix-databases-database-users-whm\/#primaryimage"},"image":{"@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/disable-username-prefix-databases-database-users-whm\/#primaryimage"},"thumbnailUrl":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2021\/06\/whm_server_conf.png","datePublished":"2021-08-25T09:51:31+00:00","dateModified":"2024-04-24T06:34:49+00:00","author":{"@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#\/schema\/person\/c9138a9488172a8d0aa2d4f40878d83e"},"description":"This article will show you the steps to disable username prefix for names and usernames of newly created cPanel databases with WHM.","breadcrumb":{"@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/disable-username-prefix-databases-database-users-whm\/#breadcrumb"},"inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.milesweb.co.uk\/hosting-faqs\/disable-username-prefix-databases-database-users-whm\/"]}]},{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/disable-username-prefix-databases-database-users-whm\/#primaryimage","url":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2021\/06\/whm_server_conf.png","contentUrl":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2021\/06\/whm_server_conf.png","width":1919,"height":718},{"@type":"BreadcrumbList","@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/disable-username-prefix-databases-database-users-whm\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/"},{"@type":"ListItem","position":2,"name":"How to Disable Username Prefix for Databases and Database Users in WHM?"}]},{"@type":"WebSite","@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#website","url":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/","name":"Web Hosting FAQs by MilesWeb","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-GB"},{"@type":"Person","@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#\/schema\/person\/c9138a9488172a8d0aa2d4f40878d83e","name":"Prasad Khartadkar","image":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/fafb102a39aa8f8d38a11f3e2dcfa746?s=96&d=blank&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/fafb102a39aa8f8d38a11f3e2dcfa746?s=96&d=blank&r=g","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.","url":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/author\/prasad-khartadkar\/"}]}},"views":366,"_links":{"self":[{"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/posts\/11403","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/users\/27"}],"replies":[{"embeddable":true,"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/comments?post=11403"}],"version-history":[{"count":3,"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/posts\/11403\/revisions"}],"predecessor-version":[{"id":15605,"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/posts\/11403\/revisions\/15605"}],"wp:attachment":[{"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/media?parent=11403"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/categories?post=11403"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/tags?post=11403"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}