{"id":3280,"date":"2020-11-28T01:31:19","date_gmt":"2020-11-27T20:01:19","guid":{"rendered":"https:\/\/www.24x7serversupport.com\/blog\/?p=3280"},"modified":"2020-11-28T01:35:15","modified_gmt":"2020-11-27T20:05:15","slug":"database-available-but-not-showing-in-cpanel","status":"publish","type":"post","link":"https:\/\/www.24x7serversupport.com\/blog\/database-available-but-not-showing-in-cpanel\/","title":{"rendered":"Database available but not showing in cPanel"},"content":{"rendered":"\n<p>If the database is not exists in cpanel after update of cpanel software, then first you have to make sure that database is available on server. But if it exists on server and not showing on cpanel server then it happened just because of database mapping. To resolve this issue you have to rebuild database map. In this article we are going to explain about to solve this issue but for that it is must to have root access of server. Let\u2019s see how to solve this:<\/p>\n\n\n\n<p>1. Login to your server via SSH.<\/p>\n\n\n\n<p>2. Then check for the details of database whether they are listed in this file or not.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">\/var\/cpanel\/databases\/username.yaml<\/pre>\n\n\n\n<p>3. If you can\u2019t find out database details in this file then you have to enter below command to fix this problem:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">\/usr\/local\/cpanel\/bin\/setupdb<\/pre>\n\n\n\n<p>4. You have to check for cpanel and database then should be here.<\/p>\n\n\n\n<p>5. If the database listing is 0 here then you have to enter the below command to fix this issue:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">\/scripts\/update_db_cache<\/pre>\n\n\n\n<p>6. If the above command is not works then you have to enter following commands:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">\/scripts\/upcp \u2013force\n\/scripts\/checkperlmodules \u2013force\n\/usr\/local\/cpanel\/bin\/setupdbmap<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>If the database is not exists in cpanel after update of cpanel software, then first you have to make sure that database is available on server. But if it exists on server and not showing on cpanel server then it happened just because of database mapping. To resolve this issue you have to rebuild database [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":3282,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","enabled":false}}},"categories":[30,33,34],"tags":[],"class_list":["post-3280","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-centos","category-cpanel","category-linux"],"jetpack_publicize_connections":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v22.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Database available but not showing in cPanel | 24x7serversupport Blog<\/title>\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.24x7serversupport.com\/blog\/database-available-but-not-showing-in-cpanel\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Database available but not showing in cPanel | 24x7serversupport Blog\" \/>\n<meta property=\"og:description\" content=\"If the database is not exists in cpanel after update of cpanel software, then first you have to make sure that database is available on server. But if it exists on server and not showing on cpanel server then it happened just because of database mapping. To resolve this issue you have to rebuild database [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.24x7serversupport.com\/blog\/database-available-but-not-showing-in-cpanel\/\" \/>\n<meta property=\"og:site_name\" content=\"24x7serversupport Blog\" \/>\n<meta property=\"article:published_time\" content=\"2020-11-27T20:01:19+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2020-11-27T20:05:15+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/i0.wp.com\/www.24x7serversupport.com\/blog\/wp-content\/uploads\/2020\/11\/cpanel-mysql.png?fit=1071%2C392&ssl=1\" \/>\n\t<meta property=\"og:image:width\" content=\"1071\" \/>\n\t<meta property=\"og:image:height\" content=\"392\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"24x7support\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@24x7serversuppo\" \/>\n<meta name=\"twitter:site\" content=\"@24x7serversuppo\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"24x7support\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.24x7serversupport.com\/blog\/database-available-but-not-showing-in-cpanel\/\",\"url\":\"https:\/\/www.24x7serversupport.com\/blog\/database-available-but-not-showing-in-cpanel\/\",\"name\":\"Database available but not showing in cPanel | 24x7serversupport Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.24x7serversupport.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.24x7serversupport.com\/blog\/database-available-but-not-showing-in-cpanel\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.24x7serversupport.com\/blog\/database-available-but-not-showing-in-cpanel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/i0.wp.com\/www.24x7serversupport.com\/blog\/wp-content\/uploads\/2020\/11\/cpanel-mysql.png?fit=1071%2C392&ssl=1\",\"datePublished\":\"2020-11-27T20:01:19+00:00\",\"dateModified\":\"2020-11-27T20:05:15+00:00\",\"author\":{\"@id\":\"https:\/\/www.24x7serversupport.com\/blog\/#\/schema\/person\/decfb5fad6bde6ac6822d4e965c6d401\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.24x7serversupport.com\/blog\/database-available-but-not-showing-in-cpanel\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.24x7serversupport.com\/blog\/database-available-but-not-showing-in-cpanel\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.24x7serversupport.com\/blog\/database-available-but-not-showing-in-cpanel\/#primaryimage\",\"url\":\"https:\/\/i0.wp.com\/www.24x7serversupport.com\/blog\/wp-content\/uploads\/2020\/11\/cpanel-mysql.png?fit=1071%2C392&ssl=1\",\"contentUrl\":\"https:\/\/i0.wp.com\/www.24x7serversupport.com\/blog\/wp-content\/uploads\/2020\/11\/cpanel-mysql.png?fit=1071%2C392&ssl=1\",\"width\":1071,\"height\":392},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.24x7serversupport.com\/blog\/database-available-but-not-showing-in-cpanel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.24x7serversupport.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Database available but not showing in cPanel\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.24x7serversupport.com\/blog\/#website\",\"url\":\"https:\/\/www.24x7serversupport.com\/blog\/\",\"name\":\"24x7serversupport Blog\",\"description\":\"Linux | CPanel | WHM | webhosting| Plesk | DirectAdmin | CentOs | Debian | Ubuntu Blog\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.24x7serversupport.com\/blog\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.24x7serversupport.com\/blog\/#\/schema\/person\/decfb5fad6bde6ac6822d4e965c6d401\",\"name\":\"24x7support\",\"url\":\"https:\/\/www.24x7serversupport.com\/blog\/author\/24x7support\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Database available but not showing in cPanel | 24x7serversupport Blog","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.24x7serversupport.com\/blog\/database-available-but-not-showing-in-cpanel\/","og_locale":"en_US","og_type":"article","og_title":"Database available but not showing in cPanel | 24x7serversupport Blog","og_description":"If the database is not exists in cpanel after update of cpanel software, then first you have to make sure that database is available on server. But if it exists on server and not showing on cpanel server then it happened just because of database mapping. To resolve this issue you have to rebuild database [&hellip;]","og_url":"https:\/\/www.24x7serversupport.com\/blog\/database-available-but-not-showing-in-cpanel\/","og_site_name":"24x7serversupport Blog","article_published_time":"2020-11-27T20:01:19+00:00","article_modified_time":"2020-11-27T20:05:15+00:00","og_image":[{"width":1071,"height":392,"url":"https:\/\/i0.wp.com\/www.24x7serversupport.com\/blog\/wp-content\/uploads\/2020\/11\/cpanel-mysql.png?fit=1071%2C392&ssl=1","type":"image\/png"}],"author":"24x7support","twitter_card":"summary_large_image","twitter_creator":"@24x7serversuppo","twitter_site":"@24x7serversuppo","twitter_misc":{"Written by":"24x7support","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.24x7serversupport.com\/blog\/database-available-but-not-showing-in-cpanel\/","url":"https:\/\/www.24x7serversupport.com\/blog\/database-available-but-not-showing-in-cpanel\/","name":"Database available but not showing in cPanel | 24x7serversupport Blog","isPartOf":{"@id":"https:\/\/www.24x7serversupport.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.24x7serversupport.com\/blog\/database-available-but-not-showing-in-cpanel\/#primaryimage"},"image":{"@id":"https:\/\/www.24x7serversupport.com\/blog\/database-available-but-not-showing-in-cpanel\/#primaryimage"},"thumbnailUrl":"https:\/\/i0.wp.com\/www.24x7serversupport.com\/blog\/wp-content\/uploads\/2020\/11\/cpanel-mysql.png?fit=1071%2C392&ssl=1","datePublished":"2020-11-27T20:01:19+00:00","dateModified":"2020-11-27T20:05:15+00:00","author":{"@id":"https:\/\/www.24x7serversupport.com\/blog\/#\/schema\/person\/decfb5fad6bde6ac6822d4e965c6d401"},"breadcrumb":{"@id":"https:\/\/www.24x7serversupport.com\/blog\/database-available-but-not-showing-in-cpanel\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.24x7serversupport.com\/blog\/database-available-but-not-showing-in-cpanel\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.24x7serversupport.com\/blog\/database-available-but-not-showing-in-cpanel\/#primaryimage","url":"https:\/\/i0.wp.com\/www.24x7serversupport.com\/blog\/wp-content\/uploads\/2020\/11\/cpanel-mysql.png?fit=1071%2C392&ssl=1","contentUrl":"https:\/\/i0.wp.com\/www.24x7serversupport.com\/blog\/wp-content\/uploads\/2020\/11\/cpanel-mysql.png?fit=1071%2C392&ssl=1","width":1071,"height":392},{"@type":"BreadcrumbList","@id":"https:\/\/www.24x7serversupport.com\/blog\/database-available-but-not-showing-in-cpanel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.24x7serversupport.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Database available but not showing in cPanel"}]},{"@type":"WebSite","@id":"https:\/\/www.24x7serversupport.com\/blog\/#website","url":"https:\/\/www.24x7serversupport.com\/blog\/","name":"24x7serversupport Blog","description":"Linux | CPanel | WHM | webhosting| Plesk | DirectAdmin | CentOs | Debian | Ubuntu Blog","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.24x7serversupport.com\/blog\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.24x7serversupport.com\/blog\/#\/schema\/person\/decfb5fad6bde6ac6822d4e965c6d401","name":"24x7support","url":"https:\/\/www.24x7serversupport.com\/blog\/author\/24x7support\/"}]}},"jetpack_featured_media_url":"https:\/\/i0.wp.com\/www.24x7serversupport.com\/blog\/wp-content\/uploads\/2020\/11\/cpanel-mysql.png?fit=1071%2C392&ssl=1","jetpack_sharing_enabled":true,"jetpack_likes_enabled":true,"jetpack-related-posts":[],"_links":{"self":[{"href":"https:\/\/www.24x7serversupport.com\/blog\/wp-json\/wp\/v2\/posts\/3280","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.24x7serversupport.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.24x7serversupport.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.24x7serversupport.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.24x7serversupport.com\/blog\/wp-json\/wp\/v2\/comments?post=3280"}],"version-history":[{"count":1,"href":"https:\/\/www.24x7serversupport.com\/blog\/wp-json\/wp\/v2\/posts\/3280\/revisions"}],"predecessor-version":[{"id":3281,"href":"https:\/\/www.24x7serversupport.com\/blog\/wp-json\/wp\/v2\/posts\/3280\/revisions\/3281"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.24x7serversupport.com\/blog\/wp-json\/wp\/v2\/media\/3282"}],"wp:attachment":[{"href":"https:\/\/www.24x7serversupport.com\/blog\/wp-json\/wp\/v2\/media?parent=3280"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.24x7serversupport.com\/blog\/wp-json\/wp\/v2\/categories?post=3280"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.24x7serversupport.com\/blog\/wp-json\/wp\/v2\/tags?post=3280"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}