{"id":3521,"date":"2024-12-27T17:56:14","date_gmt":"2024-12-27T17:56:14","guid":{"rendered":"https:\/\/www.wpconsults.com\/?p=3521"},"modified":"2024-12-27T17:58:43","modified_gmt":"2024-12-27T17:58:43","slug":"find-wordpress-database","status":"publish","type":"post","link":"https:\/\/www.wpconsults.com\/en_gb\/find-wordpress-database\/","title":{"rendered":"How to find which database is assigned to my website?"},"content":{"rendered":"<p class=\"wp-block-paragraph\">I know you might have multiple database and you are in trouble to find which one is for your website. Don&#8217;t worry it is super easy.  You can find it from wp-config.php file<\/p>\n\n\n<style>.kb-table-of-content-nav.kb-table-of-content-id3521_5e4563-2b .kb-table-of-content-wrap{padding-top:var(--global-kb-spacing-sm, 1.5rem);padding-right:var(--global-kb-spacing-sm, 1.5rem);padding-bottom:var(--global-kb-spacing-sm, 1.5rem);padding-left:var(--global-kb-spacing-sm, 1.5rem);}.kb-table-of-content-nav.kb-table-of-content-id3521_5e4563-2b .kb-table-of-contents-title-wrap{padding-top:0px;padding-right:0px;padding-bottom:0px;padding-left:0px;}.kb-table-of-content-nav.kb-table-of-content-id3521_5e4563-2b .kb-table-of-contents-title{font-weight:regular;font-style:normal;}.kb-table-of-content-nav.kb-table-of-content-id3521_5e4563-2b .kb-table-of-content-wrap .kb-table-of-content-list{font-weight:regular;font-style:normal;margin-top:var(--global-kb-spacing-sm, 1.5rem);margin-right:0px;margin-bottom:0px;margin-left:0px;}<\/style>\n\n\n<h2 class=\"wp-block-heading\">Access File Manager<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Just open file manager then go to public_html ( if you have subdomain it can be on same directory where public-html located) <\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img fetchpriority=\"high\" decoding=\"async\" width=\"1016\" height=\"268\" src=\"https:\/\/www.wpconsults.com\/wp-content\/uploads\/2024\/12\/image-16-png.avif\" alt=\"\" class=\"wp-image-3522\" srcset=\"https:\/\/www.wpconsults.com\/wp-content\/uploads\/2024\/12\/image-16-png.avif 1016w, https:\/\/www.wpconsults.com\/wp-content\/uploads\/2024\/12\/image-16-300x79.avif 300w, https:\/\/www.wpconsults.com\/wp-content\/uploads\/2024\/12\/image-16-768x203.avif 768w, https:\/\/www.wpconsults.com\/wp-content\/uploads\/2024\/12\/image-16-18x5.avif 18w\" sizes=\"(max-width: 1016px) 100vw, 1016px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">a stated files for any Sub domain and b stated the main directory<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"451\" src=\"https:\/\/www.wpconsults.com\/wp-content\/uploads\/2024\/12\/image-17-1024x451.avif\" alt=\"\" class=\"wp-image-3523\" srcset=\"https:\/\/www.wpconsults.com\/wp-content\/uploads\/2024\/12\/image-17-1024x451.avif 1024w, https:\/\/www.wpconsults.com\/wp-content\/uploads\/2024\/12\/image-17-300x132.avif 300w, https:\/\/www.wpconsults.com\/wp-content\/uploads\/2024\/12\/image-17-768x338.avif 768w, https:\/\/www.wpconsults.com\/wp-content\/uploads\/2024\/12\/image-17-18x8.avif 18w, https:\/\/www.wpconsults.com\/wp-content\/uploads\/2024\/12\/image-17-png.avif 1026w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">Open wp-config.php File<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Find wp-config file, select and right click to view\/edit it.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"945\" height=\"439\" src=\"https:\/\/www.wpconsults.com\/wp-content\/uploads\/2024\/12\/image-20-png.avif\" alt=\"\" class=\"wp-image-3526\" srcset=\"https:\/\/www.wpconsults.com\/wp-content\/uploads\/2024\/12\/image-20-png.avif 945w, https:\/\/www.wpconsults.com\/wp-content\/uploads\/2024\/12\/image-20-300x139.avif 300w, https:\/\/www.wpconsults.com\/wp-content\/uploads\/2024\/12\/image-20-768x357.avif 768w, https:\/\/www.wpconsults.com\/wp-content\/uploads\/2024\/12\/image-20-18x8.avif 18w\" sizes=\"(max-width: 945px) 100vw, 945px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">You can now see the DB Name there<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"583\" height=\"401\" src=\"https:\/\/i0.wp.com\/www.wpconsults.com\/wp-content\/uploads\/2024\/12\/image-19.png?resize=583%2C401&#038;ssl=1\" alt=\"\" class=\"wp-image-3525\" srcset=\"https:\/\/i0.wp.com\/www.wpconsults.com\/wp-content\/uploads\/2024\/12\/image-19.png?w=583&amp;ssl=1 583w, https:\/\/www.wpconsults.com\/wp-content\/uploads\/2024\/12\/image-19-300x206.avif 300w, https:\/\/www.wpconsults.com\/wp-content\/uploads\/2024\/12\/image-19-18x12.avif 18w\" sizes=\"(max-width: 583px) 100vw, 583px\" \/><\/figure>","protected":false},"excerpt":{"rendered":"<p>I know you might have multiple database and you are in trouble to find which one is for your website. Don&#8217;t worry it is super easy. You can find it from wp-config.php file Access File Manager Just open file manager then go to public_html ( if you have subdomain it can be on same directory&#8230;<\/p>","protected":false},"author":1,"featured_media":3246,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_kad_post_transparent":"","_kad_post_title":"","_kad_post_layout":"","_kad_post_sidebar_id":"","_kad_post_content_style":"","_kad_post_vertical_padding":"","_kad_post_feature":"","_kad_post_feature_position":"","_kad_post_header":false,"_kad_post_footer":false,"_kad_post_classname":"","_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_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","default_image_id":0,"font":"","enabled":false},"version":2},"jetpack_post_was_ever_published":false},"categories":[7],"tags":[],"class_list":["post-3521","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-wordpress-tips-tutorials"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/www.wpconsults.com\/wp-content\/uploads\/2024\/05\/WpConsults-Default-post-thumbnail-jpg.webp?fit=1280%2C720&ssl=1","jetpack_sharing_enabled":true,"jetpack_likes_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/pboFy3-UN","jetpack-related-posts":[{"id":5268,"url":"https:\/\/www.wpconsults.com\/en_gb\/can-a-wordpress-website-handle-1-million-traffic\/","url_meta":{"origin":3521,"position":0},"title":"Can a WordPress Website Handle 1 Million+ Traffic?","author":"Abdullah Nouman","date":"August 27, 2025","format":false,"excerpt":"WordPress is one of the most popular website platforms in the world. Many people use it for blogs, business sites, and even big e-commerce stores. A common question that comes up is: Can a WordPress website really handle more than 1 million visitors? The short answer is yes, it can.\u2026","rel":"","context":"In &quot;WordPress Tips &amp; Tutorials&quot;","block_context":{"text":"WordPress Tips &amp; Tutorials","link":"https:\/\/www.wpconsults.com\/en_gb\/category\/wordpress-tips-tutorials\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/www.wpconsults.com\/wp-content\/uploads\/2024\/05\/WpConsults-Default-post-thumbnail-jpg.webp?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/www.wpconsults.com\/wp-content\/uploads\/2024\/05\/WpConsults-Default-post-thumbnail-jpg.webp?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/www.wpconsults.com\/wp-content\/uploads\/2024\/05\/WpConsults-Default-post-thumbnail-jpg.webp?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/www.wpconsults.com\/wp-content\/uploads\/2024\/05\/WpConsults-Default-post-thumbnail-jpg.webp?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/www.wpconsults.com\/wp-content\/uploads\/2024\/05\/WpConsults-Default-post-thumbnail-jpg.webp?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":3511,"url":"https:\/\/www.wpconsults.com\/en_gb\/reset-wordpress-password-from-file-manager\/","url_meta":{"origin":3521,"position":1},"title":"How to reset WordPress password from file manager manually?","author":"Abdullah Nouman","date":"December 27, 2024","format":false,"excerpt":"This should only be used if you can\u2019t access both your email and your dashboard. With these quick steps in mind, make sure to carefully follow the instructions to avoid any mistakes. 1. Open phpMyAdmin from your Hosting Panel. 2. Select the correct database of the site you want to\u2026","rel":"","context":"In &quot;WordPress Tips &amp; Tutorials&quot;","block_context":{"text":"WordPress Tips &amp; Tutorials","link":"https:\/\/www.wpconsults.com\/en_gb\/category\/wordpress-tips-tutorials\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/www.wpconsults.com\/wp-content\/uploads\/2024\/05\/WpConsults-Default-post-thumbnail-jpg.webp?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/www.wpconsults.com\/wp-content\/uploads\/2024\/05\/WpConsults-Default-post-thumbnail-jpg.webp?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/www.wpconsults.com\/wp-content\/uploads\/2024\/05\/WpConsults-Default-post-thumbnail-jpg.webp?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/www.wpconsults.com\/wp-content\/uploads\/2024\/05\/WpConsults-Default-post-thumbnail-jpg.webp?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/www.wpconsults.com\/wp-content\/uploads\/2024\/05\/WpConsults-Default-post-thumbnail-jpg.webp?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":2692,"url":"https:\/\/www.wpconsults.com\/en_gb\/your-php-installation-appears-to-be-missing-the-mysql-extension\/","url_meta":{"origin":3521,"position":2},"title":"How to Fix &#8220;Your PHP Installation Appears to Be Missing the MySQL Extension Which Is Required by WordPress&#8221; Error","author":"Abdullah Nouman","date":"February 1, 2024","format":false,"excerpt":"If you encounter \"Your PHP Installation Appears to Be Missing the MySQL Extension Which Is Required by WordPress\" error message when trying to install or access your WordPress site, it means that your PHP installation on the server does not have the right MySQL extension to connect your WordPress site\u2026","rel":"","context":"In &quot;WordPress Tips &amp; Tutorials&quot;","block_context":{"text":"WordPress Tips &amp; Tutorials","link":"https:\/\/www.wpconsults.com\/en_gb\/category\/wordpress-tips-tutorials\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/www.wpconsults.com\/wp-content\/uploads\/2024\/01\/how-to-fix-php-installation-appe-jpg.webp?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/www.wpconsults.com\/wp-content\/uploads\/2024\/01\/how-to-fix-php-installation-appe-jpg.webp?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/www.wpconsults.com\/wp-content\/uploads\/2024\/01\/how-to-fix-php-installation-appe-jpg.webp?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/www.wpconsults.com\/wp-content\/uploads\/2024\/01\/how-to-fix-php-installation-appe-jpg.webp?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/www.wpconsults.com\/wp-content\/uploads\/2024\/01\/how-to-fix-php-installation-appe-jpg.webp?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":2444,"url":"https:\/\/www.wpconsults.com\/en_gb\/change-wp-admin-url-without-plugin\/","url_meta":{"origin":3521,"position":3},"title":"Change &#8220;wp-admin&#8221; URL Without Plugin","author":"Abdullah Nouman","date":"December 31, 2023","format":false,"excerpt":"Changing the default WordPress login URL from \"wp-admin\" to a custom URL is a proactive security measure that helps safeguard your site against potential threats. \"There are tons of 3rd party plugin to do it but remember they may slow down your website also may cause security threat.\" 1. Backup\u2026","rel":"","context":"In &quot;WordPress Tips &amp; Tutorials&quot;","block_context":{"text":"WordPress Tips &amp; Tutorials","link":"https:\/\/www.wpconsults.com\/en_gb\/category\/wordpress-tips-tutorials\/"},"img":{"alt_text":"How To Change wp-admin URL Without Plugins","src":"https:\/\/i0.wp.com\/www.wpconsults.com\/wp-content\/uploads\/2023\/12\/change-wp-admin-manually-jpg.webp?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/www.wpconsults.com\/wp-content\/uploads\/2023\/12\/change-wp-admin-manually-jpg.webp?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/www.wpconsults.com\/wp-content\/uploads\/2023\/12\/change-wp-admin-manually-jpg.webp?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/www.wpconsults.com\/wp-content\/uploads\/2023\/12\/change-wp-admin-manually-jpg.webp?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/www.wpconsults.com\/wp-content\/uploads\/2023\/12\/change-wp-admin-manually-jpg.webp?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":4175,"url":"https:\/\/www.wpconsults.com\/en_gb\/wordpress-images-not-loading-after-migration-fixed\/","url_meta":{"origin":3521,"position":4},"title":"WordPress Images Not Loading After Migration (Fixed)","author":"Abdullah Nouman","date":"March 10, 2025","format":false,"excerpt":"Migrating a WordPress website to a new host or domain is a common process, but it can sometimes lead to issues, including images not loading properly. This problem can occur due to incorrect file paths, SSL issues, or missing thumbnails. But don't worry, there are several easy & effective solutions\u2026","rel":"","context":"In &quot;WordPress Tips &amp; Tutorials&quot;","block_context":{"text":"WordPress Tips &amp; Tutorials","link":"https:\/\/www.wpconsults.com\/en_gb\/category\/wordpress-tips-tutorials\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/www.wpconsults.com\/wp-content\/uploads\/2024\/05\/WpConsults-Default-post-thumbnail-jpg.webp?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/www.wpconsults.com\/wp-content\/uploads\/2024\/05\/WpConsults-Default-post-thumbnail-jpg.webp?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/www.wpconsults.com\/wp-content\/uploads\/2024\/05\/WpConsults-Default-post-thumbnail-jpg.webp?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/www.wpconsults.com\/wp-content\/uploads\/2024\/05\/WpConsults-Default-post-thumbnail-jpg.webp?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/www.wpconsults.com\/wp-content\/uploads\/2024\/05\/WpConsults-Default-post-thumbnail-jpg.webp?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":3417,"url":"https:\/\/www.wpconsults.com\/en_gb\/sitemap-couldnt-fetch-issue-solved\/","url_meta":{"origin":3521,"position":5},"title":"How to solve &#8220;Sitemap Couldn&#8217;t Fetch Issue&#8221; in Google Search Console: An In-Depth Guide","author":"Abdullah Nouman","date":"September 10, 2024","format":false,"excerpt":"Follow My blog on Bloglovin The \"sitemap couldn't fetch\" error in Google Search Console can be a frustrating obstacle for webmasters and SEO professionals. This comprehensive guide will walk you through the common causes of this issue and provide advanced solutions to ensure your sitemap is properly crawled and indexed\u2026","rel":"","context":"In &quot;Search Console Tips &amp; Tutorials&quot;","block_context":{"text":"Search Console Tips &amp; Tutorials","link":"https:\/\/www.wpconsults.com\/en_gb\/category\/search-console-tips-and-tutorials\/"},"img":{"alt_text":"Sitemap Couldn't Fetch Issue in Google search console","src":"https:\/\/i0.wp.com\/www.wpconsults.com\/wp-content\/uploads\/2024\/09\/image-8.png?fit=927%2C391&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/www.wpconsults.com\/wp-content\/uploads\/2024\/09\/image-8.png?fit=927%2C391&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/www.wpconsults.com\/wp-content\/uploads\/2024\/09\/image-8.png?fit=927%2C391&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/www.wpconsults.com\/wp-content\/uploads\/2024\/09\/image-8.png?fit=927%2C391&ssl=1&resize=700%2C400 2x"},"classes":[]}],"_links":{"self":[{"href":"https:\/\/www.wpconsults.com\/en_gb\/wp-json\/wp\/v2\/posts\/3521","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.wpconsults.com\/en_gb\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.wpconsults.com\/en_gb\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.wpconsults.com\/en_gb\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.wpconsults.com\/en_gb\/wp-json\/wp\/v2\/comments?post=3521"}],"version-history":[{"count":0,"href":"https:\/\/www.wpconsults.com\/en_gb\/wp-json\/wp\/v2\/posts\/3521\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.wpconsults.com\/en_gb\/wp-json\/wp\/v2\/media\/3246"}],"wp:attachment":[{"href":"https:\/\/www.wpconsults.com\/en_gb\/wp-json\/wp\/v2\/media?parent=3521"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.wpconsults.com\/en_gb\/wp-json\/wp\/v2\/categories?post=3521"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.wpconsults.com\/en_gb\/wp-json\/wp\/v2\/tags?post=3521"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}