{"id":5410,"date":"2025-06-13T14:27:54","date_gmt":"2025-06-13T14:27:54","guid":{"rendered":"https:\/\/www.hostarmada.com\/blog\/?p=5410"},"modified":"2026-01-16T22:56:42","modified_gmt":"2026-01-16T22:56:42","slug":"show-databases-guide","status":"publish","type":"post","link":"https:\/\/www.hostarmada.com\/blog\/show-databases-guide\/","title":{"rendered":"How To Show MySQL Databases Using Command Line and cPanel"},"content":{"rendered":"\n<p>Listing databases from the command line allows you to quickly verify available MySQL databases and confirm access permissions.<\/p>\n\n\n\n<p><span style=\"font-weight: 400\">For many beginners, MySQL can become intimidating. You didn&#8217;t sign up to be a database admin. You just want to run your website, manage your content, or launch your online store. However, without knowing how to list your MySQL databases, you&#8217;re left to guess. That&#8217;s risky and impractical.<\/span><\/p>\n\n\n\n<p><span style=\"font-weight: 400\">To help you get through this otherwise easy process, we created an extensive guide on how to extract a list both in the Command line and cPanel.<\/span><\/p>\n\n\n\n<p><span style=\"font-weight: 400\">So, regardless of whether you&#8217;re cleaning up unused databases, verifying an installation, or just trying to learn the basics, this is a core skill every site owner should have.<\/span><\/p>\n\n\n\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_82_2 ez-toc-wrap-right counter-hierarchy ez-toc-counter ez-toc-transparent ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #565656;color:#565656\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #565656;color:#565656\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/www.hostarmada.com\/blog\/show-databases-guide\/#Why_You_Might_Need_to_List_Databases\" >Why You Might Need to List Databases<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/www.hostarmada.com\/blog\/show-databases-guide\/#Show_Databases_with_Command_Line_A_Step-by-Step_Guide\" >Show Databases with Command Line: A Step-by-Step Guide<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/www.hostarmada.com\/blog\/show-databases-guide\/#Using_cPanel_to_Show_Databases\" >Using cPanel to Show Databases<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/www.hostarmada.com\/blog\/show-databases-guide\/#What_Permission-Based_Limitations_You_Can_Encounter\" >What Permission-Based Limitations You Can Encounter<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/www.hostarmada.com\/blog\/show-databases-guide\/#SHOW_DATABASES_Not_Working_Heres_Whats_Going_On\" >SHOW DATABASES Not Working? Here&#8217;s What&#8217;s Going On<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/www.hostarmada.com\/blog\/show-databases-guide\/#Want_to_Learn_More_Start_with_the_Right_Foundation\" >Want to Learn More? Start with the Right Foundation<\/a><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\" id=\"h-why-you-might-need-to-list-databases\"><span class=\"ez-toc-section\" id=\"Why_You_Might_Need_to_List_Databases\"><\/span><span style=\"font-weight: 400\">Why You Might Need to List Databases<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p><span style=\"font-weight: 400\">You may think that using the show databases command is strictly reserved for dev teams or at least system administrators. However, that&#8217;s something every website owner must know, and there are at least four good reasons for that.<\/span><\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-1-to-confirm-database-names\"><span style=\"font-weight: 400\">1. To Confirm Database Names<\/span><\/h3>\n\n\n\n<p><span style=\"font-weight: 400\">If you&#8217;re installing software like WordPress or Magento, you&#8217;re often asked to provide the exact name of the database. A single typo can cause the installation to fail. Listing your databases helps you avoid that frustration by giving you the exact name you need. There&#8217;s no guessing.<\/span><\/p>\n\n\n\n<p><span style=\"font-weight: 400\">Of course, if you&#8217;re using a hosting provider with a one-click WordPress installation, you won&#8217;t get this problem. But say you want to <\/span><a href=\"https:\/\/www.hostarmada.com\/blog\/install-wordpress-on-localhost\/\"><span style=\"font-weight: 400\">set up WordPress on localhost<\/span><\/a><span style=\"font-weight: 400\">, the database name accuracy will be integral.<\/span><\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-2-troubleshooting-errors\"><span style=\"font-weight: 400\">2. Troubleshooting Errors<\/span><\/h3>\n\n\n\n<p><span style=\"font-weight: 400\">Ever seen the dreaded &#8220;Error establishing a database connection&#8221; message? It&#8217;s one of the most common issues in web hosting. One of the first steps in troubleshooting is to ensure the database actually exists and is named correctly.<\/span><\/p>\n\n\n\n<p><span style=\"font-weight: 400\">Now, you can always call on your hosting provider&#8217;s support to check it out. However, if they don&#8217;t offer <\/span><a href=\"https:\/\/hostarmada.com\/technical-support\/\"><span style=\"font-weight: 400\">24\/7\/365 support<\/span><\/a><span style=\"font-weight: 400\">, like the best hosting providers on the market, and if they respond within 24 hours instead of within an hour, it&#8217;s better to be able to troubleshoot this problem yourself. At least then, when you finally contact the support team, you can already tell them where the problem is or if they can skip this first step.<\/span><\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-3-to-clean-up-unused-databases\"><span style=\"font-weight: 400\">3. To Clean Up Unused Databases<\/span><\/h3>\n\n\n\n<p><span style=\"font-weight: 400\">Over time, your server can collect test databases, duplicate installations, or abandoned projects. If you don&#8217;t regularly check what&#8217;s there, these can eat up space and clutter your environment. Listing all databases makes it easy to identify and delete what you no longer need.<\/span><\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-4-to-audit-security-or-user-permissions\"><span style=\"font-weight: 400\">4. To Audit Security or User Permissions<\/span><\/h3>\n\n\n\n<p><span style=\"font-weight: 400\">If multiple people have access to your hosting account or you&#8217;ve worked with freelancers in the past, listing your databases gives you visibility into everything that&#8217;s been created. You can then review which databases are still in use and which may pose a security risk.<\/span><\/p>\n\n\n\n<p><span style=\"font-weight: 400\">In our experience, website owners with basic MySQL knowledge are far less prone to internal breaches and attacks. Setting permissions is like giving keys to your building. You don&#8217;t want people who don&#8217;t work with money to have access to your financial documents, now do you? The same principle applies to database permissions. You don&#8217;t want freelancers to have access to your customer-facing website when they can complete all the necessary tasks in a <a href=\"https:\/\/www.hostarmada.com\/blog\/what-is-website-staging-and-should-you-use-it-for-your-wordpress-website\/\">staging environment<\/a>.<\/span><\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-show-databases-with-command-line-a-step-by-step-guide\"><span class=\"ez-toc-section\" id=\"Show_Databases_with_Command_Line_A_Step-by-Step_Guide\"><\/span><span style=\"font-weight: 400\">Show Databases with Command Line: A Step-by-Step Guide<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p><span style=\"font-weight: 400\">The command line is, without a doubt, the fastest way to list your MySQL databases. Unfortunately, it&#8217;s not the easiest. However, if you want to take full control over your server and, of course, your information, this is knowledge you must have.<\/span><\/p>\n\n\n\n<p><span style=\"font-weight: 400\">While the cPanel is definitely easier, using the command line only looks intimidating. In fact, listing your MySQL database is quite simple once you know the proper steps.<\/span><\/p>\n\n\n\n<p><strong>Note:<\/strong> Before proceeding, keep in mind that the SHOW DATABASES command only displays databases that your MySQL user has permission to access, so sufficient MySQL privileges are required to see all available databases.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-first-access-the-mysql-shell\"><span style=\"font-weight: 400\">First: Access the MySQL Shell<\/span><\/h3>\n\n\n\n<p><span style=\"font-weight: 400\">Open your terminal and connect to your MySQL server. The basic command is:<\/span><\/p>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:.875rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;line-height:1.25rem;--cbp-tab-width:2\"><span style=\"padding:16px 0 0 16px;margin-bottom:-1px;width:100%;text-align:left;background-color:#2e3440ff\"><\/span><span role=\"button\" style=\"color:#d8dee9ff\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><textarea class=\"code-block-pro-copy-button-textarea\" aria-hidden=\"true\" readonly>MySQL -u your_username -p<\/textarea><\/span><pre class=\"shiki nord\" style=\"background-color: #2e3440ff\"><code><span class=\"line\"><span style=\"color: #D8DEE9\">MySQL<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">-<\/span><span style=\"color: #D8DEE9\">u<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #D8DEE9\">your_username<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">-<\/span><span style=\"color: #D8DEE9\">p<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<p><span style=\"font-weight: 400\">Replace your username with your actual MySQL username. After pressing Enter, you&#8217;ll be prompted to enter your MySQL password. If the credentials are correct, you&#8217;ll enter the MySQL shell, indicated by a prompt like:<\/span><\/p>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:.875rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;line-height:1.25rem;--cbp-tab-width:2\"><span style=\"padding:16px 0 0 16px;margin-bottom:-1px;width:100%;text-align:left;background-color:#2e3440ff\"><\/span><span role=\"button\" style=\"color:#d8dee9ff\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><textarea class=\"code-block-pro-copy-button-textarea\" aria-hidden=\"true\" readonly>mysql&gt;<\/textarea><\/span><pre class=\"shiki nord\" style=\"background-color: #2e3440ff\"><code><span class=\"line\"><span style=\"color: #D8DEE9\">mysql<\/span><span style=\"color: #81A1C1\">&gt;<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-second-use-the-show-databases-command\"><span style=\"font-weight: 400\">Second: Use the Show Databases Command<\/span><\/h3>\n\n\n\n<p><span style=\"font-weight: 400\">Once you&#8217;re inside, run:<\/span><\/p>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:.875rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;line-height:1.25rem;--cbp-tab-width:2\"><span style=\"padding:16px 0 0 16px;margin-bottom:-1px;width:100%;text-align:left;background-color:#2e3440ff\"><\/span><span role=\"button\" style=\"color:#d8dee9ff\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><textarea class=\"code-block-pro-copy-button-textarea\" aria-hidden=\"true\" readonly>SHOW DATABASES;<\/textarea><\/span><pre class=\"shiki nord\" style=\"background-color: #2e3440ff\"><code><span class=\"line\"><span style=\"color: #D8DEE9\">SHOW<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #D8DEE9\">DATABASES<\/span><span style=\"color: #81A1C1\">;<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<p><span style=\"font-weight: 400\">This simple yet powerful command displays all databases your MySQL user account has permission to see.<\/span><\/p>\n\n\n\n<p><span style=\"font-weight: 400\">You&#8217;ll get an output like:<\/span><\/p>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:.875rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;line-height:1.25rem;--cbp-tab-width:2\"><span style=\"padding:16px 0 0 16px;margin-bottom:-1px;width:100%;text-align:left;background-color:#2e3440ff\"><\/span><span role=\"button\" style=\"color:#d8dee9ff\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><textarea class=\"code-block-pro-copy-button-textarea\" aria-hidden=\"true\" readonly>+&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8211;+\n| Database           |\n+&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8211;+\n| information_schema |\n| my_database        |\n| test_db            |\n+&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8211;+\n<\/textarea><\/span><pre class=\"shiki nord\" style=\"background-color: #2e3440ff\"><code><span class=\"line\"><span style=\"color: #81A1C1\">+--------------------+<\/span><\/span>\n<span class=\"line\"><span style=\"color: #81A1C1\">|<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #D8DEE9\">Database<\/span><span style=\"color: #D8DEE9FF\">           <\/span><span style=\"color: #81A1C1\">|<\/span><\/span>\n<span class=\"line\"><span style=\"color: #81A1C1\">+--------------------+<\/span><\/span>\n<span class=\"line\"><span style=\"color: #81A1C1\">|<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #D8DEE9\">information_schema<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">|<\/span><\/span>\n<span class=\"line\"><span style=\"color: #81A1C1\">|<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #D8DEE9\">my_database<\/span><span style=\"color: #D8DEE9FF\">        <\/span><span style=\"color: #81A1C1\">|<\/span><\/span>\n<span class=\"line\"><span style=\"color: #81A1C1\">|<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #D8DEE9\">test_db<\/span><span style=\"color: #D8DEE9FF\">            <\/span><span style=\"color: #81A1C1\">|<\/span><\/span>\n<span class=\"line\"><span style=\"color: #81A1C1\">+--------------------+<\/span><\/span>\n<span class=\"line\"><\/span><\/code><\/pre><\/div>\n\n\n\n<p><span style=\"font-weight: 400\">That&#8217;s it. You now have a complete list of available databases.<\/span><\/p>\n\n\n\n<p><span style=\"font-weight: 400\">However, if your list is too long or includes unfamiliar names, you can check database creation dates and sizes using additional queries or external tools. But for most beginners, the SHOW DATABASES; command is more than enough.<\/span><\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-using-cpanel-to-show-databases\"><span class=\"ez-toc-section\" id=\"Using_cPanel_to_Show_Databases\"><\/span><span style=\"font-weight: 400\">Using cPanel to Show Databases<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p><span style=\"font-weight: 400\">Thankfully, the command line way is not the only one. There is a far easier option, especially if you&#8217;re a <\/span><a href=\"https:\/\/hostarmada.com\/\"><span style=\"font-weight: 400\">HostArmada<\/span><\/a><span style=\"font-weight: 400\"> user. With our cPanel, you can get to your database list through a visual, beginner-friendly interface. IT let&#8217;s you view and manage your MySQL databases without touching a single line of code.<\/span><\/p>\n\n\n\n<p><span style=\"font-weight: 400\">So, here&#8217;s how to do it:<\/span><\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-step-1-logging-into-cpanel\"><span style=\"font-weight: 400\">Step 1: Logging into cPanel<\/span><\/h3>\n\n\n\n<p><span style=\"font-weight: 400\">The easiest way to get there is through your Client Area. Once you&#8217;re in the dashboard, go to the &#8220;My Services&#8221; section. Under it, you will see all the web hosting services you have. Click on the &#8220;cP&#8221; icon.<\/span><\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1110\" height=\"577\" src=\"https:\/\/www.hostarmada.com\/blog\/wp-content\/uploads\/2025\/06\/client-area-my-services-1110x577.png\" alt=\"Entering cPanel dashboard\" class=\"wp-image-5411\" srcset=\"https:\/\/www.hostarmada.com\/blog\/wp-content\/uploads\/2025\/06\/client-area-my-services-1110x577.png 1110w, https:\/\/www.hostarmada.com\/blog\/wp-content\/uploads\/2025\/06\/client-area-my-services-300x156.png 300w, https:\/\/www.hostarmada.com\/blog\/wp-content\/uploads\/2025\/06\/client-area-my-services-768x399.png 768w, https:\/\/www.hostarmada.com\/blog\/wp-content\/uploads\/2025\/06\/client-area-my-services-1536x798.png 1536w, https:\/\/www.hostarmada.com\/blog\/wp-content\/uploads\/2025\/06\/client-area-my-services-2048x1065.png 2048w, https:\/\/www.hostarmada.com\/blog\/wp-content\/uploads\/2025\/06\/client-area-my-services-24x12.png 24w, https:\/\/www.hostarmada.com\/blog\/wp-content\/uploads\/2025\/06\/client-area-my-services-36x19.png 36w, https:\/\/www.hostarmada.com\/blog\/wp-content\/uploads\/2025\/06\/client-area-my-services-48x25.png 48w\" sizes=\"(max-width: 1110px) 100vw, 1110px\" \/><\/figure>\n\n\n\n<p><span style=\"font-weight: 400\">If you need a more detailed instruction on how to get to the cPanel, check out our dedicated guide on <\/span><a href=\"https:\/\/hostarmada.com\/tutorials\/getting-started\/cpanel\/how-to-access-the-cpanel-service\/#:~:text=Accessing%20cPanel%20on%20HostArmada%20Shared%20Hosting%20Plans\"><span style=\"font-weight: 400\">Accessing cPanel<\/span><\/a><\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-step-2-find-the-databases-section\"><span style=\"font-weight: 400\">Step 2: Find the Databases Section<\/span><\/h3>\n\n\n\n<p><span style=\"font-weight: 400\">Once you&#8217;re inside, scroll down to the Databases section and click on MySQL Databases. This is where you can create, manage, and view all MySQL-related settings.<\/span><\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1110\" height=\"329\" src=\"https:\/\/www.hostarmada.com\/blog\/wp-content\/uploads\/2025\/06\/manage-my-databases-1110x329.png\" alt=\"manage my databases option\" class=\"wp-image-5413\" srcset=\"https:\/\/www.hostarmada.com\/blog\/wp-content\/uploads\/2025\/06\/manage-my-databases-1110x329.png 1110w, https:\/\/www.hostarmada.com\/blog\/wp-content\/uploads\/2025\/06\/manage-my-databases-300x89.png 300w, https:\/\/www.hostarmada.com\/blog\/wp-content\/uploads\/2025\/06\/manage-my-databases-768x228.png 768w, https:\/\/www.hostarmada.com\/blog\/wp-content\/uploads\/2025\/06\/manage-my-databases-1536x456.png 1536w, https:\/\/www.hostarmada.com\/blog\/wp-content\/uploads\/2025\/06\/manage-my-databases-2048x607.png 2048w, https:\/\/www.hostarmada.com\/blog\/wp-content\/uploads\/2025\/06\/manage-my-databases-24x7.png 24w, https:\/\/www.hostarmada.com\/blog\/wp-content\/uploads\/2025\/06\/manage-my-databases-36x11.png 36w, https:\/\/www.hostarmada.com\/blog\/wp-content\/uploads\/2025\/06\/manage-my-databases-48x14.png 48w\" sizes=\"(max-width: 1110px) 100vw, 1110px\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-final-step-scroll-to-current-databases\"><span style=\"font-weight: 400\">Final step: Scroll to &#8220;Current Databases&#8221;<\/span><\/h3>\n\n\n\n<p><span style=\"font-weight: 400\">On the MySQL Databases page, scroll down until you see a section labeled <\/span><b>Current Databases<\/b><span style=\"font-weight: 400\">. This is where you can find a complete list of all MySQL databases created under your hosting account.<\/span><\/p>\n\n\n\n<p><span style=\"font-weight: 400\">You&#8217;ll also see extra details like which database user is assigned to each one, what privileges they have, and quick options to rename or delete them.<\/span><\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1110\" height=\"198\" src=\"https:\/\/www.hostarmada.com\/blog\/wp-content\/uploads\/2025\/06\/current-databases-1110x198.png\" alt=\"current databases list in cPanel\" class=\"wp-image-5412\" srcset=\"https:\/\/www.hostarmada.com\/blog\/wp-content\/uploads\/2025\/06\/current-databases-1110x198.png 1110w, https:\/\/www.hostarmada.com\/blog\/wp-content\/uploads\/2025\/06\/current-databases-300x53.png 300w, https:\/\/www.hostarmada.com\/blog\/wp-content\/uploads\/2025\/06\/current-databases-768x137.png 768w, https:\/\/www.hostarmada.com\/blog\/wp-content\/uploads\/2025\/06\/current-databases-1536x274.png 1536w, https:\/\/www.hostarmada.com\/blog\/wp-content\/uploads\/2025\/06\/current-databases-2048x365.png 2048w, https:\/\/www.hostarmada.com\/blog\/wp-content\/uploads\/2025\/06\/current-databases-24x4.png 24w, https:\/\/www.hostarmada.com\/blog\/wp-content\/uploads\/2025\/06\/current-databases-36x6.png 36w, https:\/\/www.hostarmada.com\/blog\/wp-content\/uploads\/2025\/06\/current-databases-48x9.png 48w\" sizes=\"(max-width: 1110px) 100vw, 1110px\" \/><\/figure>\n\n\n\n<p><span style=\"font-weight: 400\">For a full walkthrough of what else you can do in this section, check out our guide on <\/span><a href=\"https:\/\/hostarmada.com\/tutorials\/getting-started\/cpanel\/#MySQL-Databases\"><span style=\"font-weight: 400\">getting started with MySQL<\/span><\/a><span style=\"font-weight: 400\">.<\/span><\/p>\n\n\n\n<p><span style=\"font-weight: 400\">If you&#8217;re more comfortable with a graphical interface, phpMyAdmin is another great option. From cPanel, click phpMyAdmin, and you&#8217;ll instantly see all your databases listed in the left sidebar.<\/span><\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-what-permission-based-limitations-you-can-encounter\"><span class=\"ez-toc-section\" id=\"What_Permission-Based_Limitations_You_Can_Encounter\"><\/span><span style=\"font-weight: 400\">What Permission-Based Limitations You Can Encounter<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p><span style=\"font-weight: 400\">Just typing the SHOW DATABASE command doesn&#8217;t always mean you&#8217;ll see every database. My SQL permissions control what each user is allowed to access. So, if your account doesn&#8217;t have the proper privileges, you won&#8217;t get to see the database list.<\/span><\/p>\n\n\n\n<p><span style=\"font-weight: 400\">Here are a few limitations you may encounter when dealing with MySQL databases.<\/span><\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-limited-visibility-by-default\"><span style=\"font-weight: 400\">Limited Visibility by Default<\/span><\/h3>\n\n\n\n<p><span style=\"font-weight: 400\">If you log in with a standard MySQL user account, you&#8217;ll only see databases that the account has access to. For example, if your website runs on a single database, and your user is assigned only to that one, running SHOW DATABASES; will return just that entry.<\/span><\/p>\n\n\n\n<p><span style=\"font-weight: 400\">And while we often hear, &#8220;Please fix that bug,&#8221; we can assure you this is normal. Moreover, it&#8217;s not a bug; it&#8217;s a security feature.<\/span><\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-the-information-schema-outcome\"><span style=\"font-weight: 400\">The Information_schema Outcome<\/span><\/h3>\n\n\n\n<p><span style=\"font-weight: 400\">Some users are surprised to see only one or two databases listed. Others, however, will only see:<\/span><\/p>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:.875rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;line-height:1.25rem;--cbp-tab-width:2\"><span style=\"padding:16px 0 0 16px;margin-bottom:-1px;width:100%;text-align:left;background-color:#2e3440ff\"><\/span><span role=\"button\" style=\"color:#d8dee9ff\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><textarea class=\"code-block-pro-copy-button-textarea\" aria-hidden=\"true\" readonly>information_schema<\/textarea><\/span><pre class=\"shiki nord\" style=\"background-color: #2e3440ff\"><code><span class=\"line\"><span style=\"color: #D8DEE9\">information_schema<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<p><span style=\"font-weight: 400\">That usually means your user doesn&#8217;t have access to any actual application databases. In that case, you&#8217;ll need to use a higher-privilege MySQL account or contact your hosting provider to check access levels.<\/span><\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-how-to-avoid-access-issues\"><span style=\"font-weight: 400\">How to Avoid Access Issues<\/span><\/h3>\n\n\n\n<p><span style=\"font-weight: 400\">If you&#8217;re unsure which MySQL user has permission to access which databases, check your user assignments in cPanel&#8217;s <\/span><b>MySQL Databases<\/b><span style=\"font-weight: 400\"> section. There, you can add users to databases and assign privileges like SELECT, INSERT, or ALL PRIVILEGES.<\/span><\/p>\n\n\n\n<p><span style=\"font-weight: 400\">While it may be tempting to assign all accounts with all privileges, that&#8217;s hardly a secure way to handle your databases.<\/span><\/p>\n\n\n\n<p><span style=\"font-weight: 400\">Also, note that on shared hosting accounts, you may not be able to access global or system databases even if you&#8217;re the primary user. This is because the hosting provider must protect other server users from accidentally deleting their databases. So, if you&#8217;re using shared hosting and you have an issue with your database, your best bet is to simply ask the hosting provider to assign you the right permissions.<\/span><\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-show-databases-not-working-here-s-what-s-going-on\"><span class=\"ez-toc-section\" id=\"SHOW_DATABASES_Not_Working_Heres_Whats_Going_On\"><\/span><span style=\"font-weight: 400\">SHOW DATABASES Not Working? Here&#8217;s What&#8217;s Going On<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p><span style=\"font-weight: 400\">You typed everything right, hit Enter\u2026 and nothing useful shows up. It&#8217;s frustrating, but it happens. So, don&#8217;t rage call your hosting provider&#8217;s support. First, check if you have accidentally stumbled on one of the most common Show Databases errors.<\/span><\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-1-error-1045-access-denied\"><span style=\"font-weight: 400\">1. Error:1045 &#8211; Access Denied<\/span><\/h3>\n\n\n\n<p><span style=\"font-weight: 400\">This usually happens when your login credentials are incorrect. Either the username doesn&#8217;t exist, or the password was mistyped.<\/span><\/p>\n\n\n\n<p><b>Fix:<\/b><\/p>\n\n\n\n<p><span style=\"font-weight: 400\">Double-check your command:<\/span><\/p>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:.875rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;line-height:1.25rem;--cbp-tab-width:2\"><span style=\"padding:16px 0 0 16px;margin-bottom:-1px;width:100%;text-align:left;background-color:#2e3440ff\"><\/span><span role=\"button\" style=\"color:#d8dee9ff\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><textarea class=\"code-block-pro-copy-button-textarea\" aria-hidden=\"true\" readonly>mysql -u your_username -p<\/textarea><\/span><pre class=\"shiki nord\" style=\"background-color: #2e3440ff\"><code><span class=\"line\"><span style=\"color: #D8DEE9\">mysql<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">-<\/span><span style=\"color: #D8DEE9\">u<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #D8DEE9\">your_username<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #81A1C1\">-<\/span><span style=\"color: #D8DEE9\">p<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<p><span style=\"font-weight: 400\">Make sure the user exists in MySQL and that you&#8217;re typing the correct password when prompted.<\/span><\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-2-no-database-or-error-message-showing\"><span style=\"font-weight: 400\">2. No Database or Error Message Showing<\/span><\/h3>\n\n\n\n<p><span style=\"font-weight: 400\">If SHOW DATABASES; runs without any errors but only shows information_schema, that means your MySQL user doesn&#8217;t have permission to view other databases.<\/span><\/p>\n\n\n\n<p><b>Fix:<\/b><\/p>\n\n\n\n<p><span style=\"font-weight: 400\">Log in with a user that has the correct privileges or check user assignments inside cPanel. You can also reassign permissions in the <\/span><b>MySQL Databases<\/b><span style=\"font-weight: 400\"> section.<\/span><\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-3-command-not-found\"><span style=\"font-weight: 400\">3. Command Not Found<\/span><\/h3>\n\n\n\n<p><span style=\"font-weight: 400\">This appears when MySQL isn&#8217;t installed or your server doesn&#8217;t recognize mysql as a command.<\/span><\/p>\n\n\n\n<p><b>Fix:<\/b><\/p>\n\n\n\n<p><span style=\"font-weight: 400\">Make sure MySQL is installed and added to your system&#8217;s PATH variable. On shared hosting, ensure your host supports SSH and CLI access.<\/span><\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-4-syntax-errors\"><span style=\"font-weight: 400\">4. Syntax Errors<\/span><\/h3>\n\n\n\n<p><span style=\"font-weight: 400\">Even a missing semicolon can break the command:<\/span><\/p>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:.875rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;line-height:1.25rem;--cbp-tab-width:2\"><span style=\"padding:16px 0 0 16px;margin-bottom:-1px;width:100%;text-align:left;background-color:#2e3440ff\"><\/span><span role=\"button\" style=\"color:#d8dee9ff\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><textarea class=\"code-block-pro-copy-button-textarea\" aria-hidden=\"true\" readonly>SHOW DATABASES<\/textarea><\/span><pre class=\"shiki nord\" style=\"background-color: #2e3440ff\"><code><span class=\"line\"><span style=\"color: #D8DEE9\">SHOW<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #D8DEE9\">DATABASES<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<p><span style=\"font-weight: 400\">is wrong<\/span><\/p>\n\n\n\n<p><span style=\"font-weight: 400\">This is how your command should look like:<\/span><\/p>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:.875rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;line-height:1.25rem;--cbp-tab-width:2\"><span style=\"padding:16px 0 0 16px;margin-bottom:-1px;width:100%;text-align:left;background-color:#2e3440ff\"><\/span><span role=\"button\" style=\"color:#d8dee9ff\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><textarea class=\"code-block-pro-copy-button-textarea\" aria-hidden=\"true\" readonly>SHOW DATABASES;<\/textarea><\/span><pre class=\"shiki nord\" style=\"background-color: #2e3440ff\"><code><span class=\"line\"><span style=\"color: #D8DEE9\">SHOW<\/span><span style=\"color: #D8DEE9FF\"> <\/span><span style=\"color: #D8DEE9\">DATABASES<\/span><span style=\"color: #81A1C1\">;<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-5-wrong-host-or-port-for-remote-connections\"><span style=\"font-weight: 400\">5. Wrong Host or Port (for Remote Connections)<\/span><\/h3>\n\n\n\n<p><span style=\"font-weight: 400\">Trying to connect remotely? You might get timeout errors if your host, port, or firewall settings are misconfigured.<\/span><\/p>\n\n\n\n<p><b>Fix:<\/b><\/p>\n\n\n\n<p><span style=\"font-weight: 400\">Make sure you&#8217;re connecting to the right IP, using the correct port (default is 3306), and that remote access is enabled.<\/span><\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-want-to-learn-more-start-with-the-right-foundation\"><span class=\"ez-toc-section\" id=\"Want_to_Learn_More_Start_with_the_Right_Foundation\"><\/span><span style=\"font-weight: 400\">Want to Learn More? Start with the Right Foundation<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p><span style=\"font-weight: 400\">Listing your databases might seem like a small task, but it plays a big role in how you manage and secure your website. Whether you&#8217;re installing new software, cleaning up your server, or just trying to troubleshoot an error, knowing how to run the SHOW DATABASES command or where to find the info in cPanel puts you behind the wheel.<\/span><\/p>\n\n\n\n<p><span style=\"font-weight: 400\">However, there&#8217;s much more to learn, especially if you&#8217;re just starting. Check out our full <\/span><a href=\"https:\/\/www.hostarmada.com\/blog\/mysql-database-tutorial\/\"><span style=\"font-weight: 400\">MySQL database tutorial<\/span><\/a><span style=\"font-weight: 400\"> to explore everything from creating databases to performance tips and advanced management tools.<\/span><\/p>\n\n\n\n<p><span style=\"font-weight: 400\">At <\/span><a href=\"https:\/\/hostarmada.com\/\"><span style=\"font-weight: 400\">HostArmada<\/span><\/a><span style=\"font-weight: 400\">, we believe web hosting shouldn&#8217;t be confusing. That&#8217;s why, along with our lightning-fast <\/span><a href=\"https:\/\/hostarmada.com\/website-loading-speed\/\"><span style=\"font-weight: 400\">website loading speed<\/span><\/a><span style=\"font-weight: 400\">, top-of-the-line <\/span><a href=\"https:\/\/hostarmada.com\/website-security\/\"><span style=\"font-weight: 400\">security<\/span><\/a><span style=\"font-weight: 400\">, and 99.9% uptime guarantee, we build our hosting environment beginner-friendly and fully optimized for MySQL-powered websites.<\/span><\/p>\n\n\n\n<p><span style=\"font-weight: 400\">So, don&#8217;t hesitate to check out our <\/span><a href=\"https:\/\/hostarmada.com\/pricing\/\"><span style=\"font-weight: 400\">hosting plans<\/span><\/a><span style=\"font-weight: 400\">. This is the first step in taking control of your website. For the rest, you can always follow our <\/span><a href=\"https:\/\/www.hostarmada.com\/blog\/\"><span style=\"font-weight: 400\">blog<\/span><\/a><span style=\"font-weight: 400\"> and learn everything there is to know for running a successful website.\u00a0<\/span><\/p>\n\n\n\n<p>&nbsp;<\/p>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Listing databases from the command line allows you to quickly verify available MySQL databases and confirm access permissions. For many beginners, MySQL can become intimidating. You didn&#8217;t sign up to be a database admin. You just want to run your website, manage your content, or launch your online store. However, without knowing how to list [&hellip;]<\/p>\n","protected":false},"author":5,"featured_media":5424,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[102,32],"tags":[220,214,224,222,230,221],"class_list":["post-5410","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-databases","category-tips","tag-backend-tutorials","tag-database-management","tag-mysql","tag-mysql-command-line","tag-server-access","tag-sql-administration"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.4 (Yoast SEO v27.4) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>How To Show MySQL Databases Using Command Line and cPanel<\/title>\n<meta name=\"description\" content=\"Learn how to list MySQL databases using command-line tools, understand permission issues, and avoid common mistakes.\" \/>\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.hostarmada.com\/blog\/show-databases-guide\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How To Show MySQL Databases Using Command Line and cPanel\" \/>\n<meta property=\"og:description\" content=\"Learn how to list MySQL databases using command-line tools, understand permission issues, and avoid common mistakes.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.hostarmada.com\/blog\/show-databases-guide\/\" \/>\n<meta property=\"og:site_name\" content=\"HostArmada Blog\" \/>\n<meta property=\"article:published_time\" content=\"2025-06-13T14:27:54+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-01-16T22:56:42+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.hostarmada.com\/blog\/wp-content\/uploads\/2025\/06\/show-databases-a-step-by-step-guide-for-command-line-and-cpanel-scaled.png\" \/>\n\t<meta property=\"og:image:width\" content=\"2560\" \/>\n\t<meta property=\"og:image:height\" content=\"1280\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Martin Atanasov\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Martin Atanasov\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"9 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.hostarmada.com\\\/blog\\\/show-databases-guide\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.hostarmada.com\\\/blog\\\/show-databases-guide\\\/\"},\"author\":{\"name\":\"Martin Atanasov\",\"@id\":\"https:\\\/\\\/www.hostarmada.com\\\/blog\\\/#\\\/schema\\\/person\\\/bbee34d0c0ea3ce71be141120a57ce77\"},\"headline\":\"How To Show MySQL Databases Using Command Line and cPanel\",\"datePublished\":\"2025-06-13T14:27:54+00:00\",\"dateModified\":\"2026-01-16T22:56:42+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.hostarmada.com\\\/blog\\\/show-databases-guide\\\/\"},\"wordCount\":1859,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/www.hostarmada.com\\\/blog\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.hostarmada.com\\\/blog\\\/show-databases-guide\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.hostarmada.com\\\/blog\\\/wp-content\\\/uploads\\\/2025\\\/06\\\/show-databases-a-step-by-step-guide-for-command-line-and-cpanel-scaled.png\",\"keywords\":[\"backend tutorials\",\"database management\",\"MySQL\",\"MySQL command line\",\"server access\",\"SQL administration\"],\"articleSection\":[\"Databases\",\"Tips\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.hostarmada.com\\\/blog\\\/show-databases-guide\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.hostarmada.com\\\/blog\\\/show-databases-guide\\\/\",\"url\":\"https:\\\/\\\/www.hostarmada.com\\\/blog\\\/show-databases-guide\\\/\",\"name\":\"How To Show MySQL Databases Using Command Line and cPanel\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.hostarmada.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.hostarmada.com\\\/blog\\\/show-databases-guide\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.hostarmada.com\\\/blog\\\/show-databases-guide\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.hostarmada.com\\\/blog\\\/wp-content\\\/uploads\\\/2025\\\/06\\\/show-databases-a-step-by-step-guide-for-command-line-and-cpanel-scaled.png\",\"datePublished\":\"2025-06-13T14:27:54+00:00\",\"dateModified\":\"2026-01-16T22:56:42+00:00\",\"description\":\"Learn how to list MySQL databases using command-line tools, understand permission issues, and avoid common mistakes.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.hostarmada.com\\\/blog\\\/show-databases-guide\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.hostarmada.com\\\/blog\\\/show-databases-guide\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.hostarmada.com\\\/blog\\\/show-databases-guide\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.hostarmada.com\\\/blog\\\/wp-content\\\/uploads\\\/2025\\\/06\\\/show-databases-a-step-by-step-guide-for-command-line-and-cpanel-scaled.png\",\"contentUrl\":\"https:\\\/\\\/www.hostarmada.com\\\/blog\\\/wp-content\\\/uploads\\\/2025\\\/06\\\/show-databases-a-step-by-step-guide-for-command-line-and-cpanel-scaled.png\",\"width\":2560,\"height\":1280,\"caption\":\"Show Databases: A Step-by-Step Guide for Command Line and cPanel\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.hostarmada.com\\\/blog\\\/show-databases-guide\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"HostArmada Blog\",\"item\":\"https:\\\/\\\/www.hostarmada.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How To Show MySQL Databases Using Command Line and cPanel\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.hostarmada.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.hostarmada.com\\\/blog\\\/\",\"name\":\"HostArmada Blog\",\"description\":\"HostArmada official blog. Useful web hosting related articles.\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.hostarmada.com\\\/blog\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.hostarmada.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.hostarmada.com\\\/blog\\\/#organization\",\"name\":\"HostArmada Blog\",\"url\":\"https:\\\/\\\/www.hostarmada.com\\\/blog\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.hostarmada.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.hostarmada.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/06\\\/logo-png-300x43-1.png\",\"contentUrl\":\"https:\\\/\\\/www.hostarmada.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/06\\\/logo-png-300x43-1.png\",\"width\":300,\"height\":44,\"caption\":\"HostArmada Blog\"},\"image\":{\"@id\":\"https:\\\/\\\/www.hostarmada.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.hostarmada.com\\\/blog\\\/#\\\/schema\\\/person\\\/bbee34d0c0ea3ce71be141120a57ce77\",\"name\":\"Martin Atanasov\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/f05b145ab7d0cedd034f0325cb9f16f3bb0f1da31e03e0f042f5e79a1cb0496b?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/f05b145ab7d0cedd034f0325cb9f16f3bb0f1da31e03e0f042f5e79a1cb0496b?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/f05b145ab7d0cedd034f0325cb9f16f3bb0f1da31e03e0f042f5e79a1cb0496b?s=96&d=mm&r=g\",\"caption\":\"Martin Atanasov\"},\"description\":\"Martin is a content writer, copywriter, and blogger with vast experience in journalism and digital marketing. He has hundreds of articles on topics ranging from SEO, digital marketing, web content, and brand marketing. With his unique ability to convey complex issues and technical topics in a relatable and understandable language, Martin is determined to give our readers an inside look, professional tips, and useful advice on all aspects of the Web Hosting Service.\",\"sameAs\":[\"https:\\\/\\\/hostarmada.com\"],\"url\":\"https:\\\/\\\/www.hostarmada.com\\\/blog\\\/author\\\/martinatanasov737\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"How To Show MySQL Databases Using Command Line and cPanel","description":"Learn how to list MySQL databases using command-line tools, understand permission issues, and avoid common mistakes.","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.hostarmada.com\/blog\/show-databases-guide\/","og_locale":"en_US","og_type":"article","og_title":"How To Show MySQL Databases Using Command Line and cPanel","og_description":"Learn how to list MySQL databases using command-line tools, understand permission issues, and avoid common mistakes.","og_url":"https:\/\/www.hostarmada.com\/blog\/show-databases-guide\/","og_site_name":"HostArmada Blog","article_published_time":"2025-06-13T14:27:54+00:00","article_modified_time":"2026-01-16T22:56:42+00:00","og_image":[{"width":2560,"height":1280,"url":"https:\/\/www.hostarmada.com\/blog\/wp-content\/uploads\/2025\/06\/show-databases-a-step-by-step-guide-for-command-line-and-cpanel-scaled.png","type":"image\/png"}],"author":"Martin Atanasov","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Martin Atanasov","Est. reading time":"9 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.hostarmada.com\/blog\/show-databases-guide\/#article","isPartOf":{"@id":"https:\/\/www.hostarmada.com\/blog\/show-databases-guide\/"},"author":{"name":"Martin Atanasov","@id":"https:\/\/www.hostarmada.com\/blog\/#\/schema\/person\/bbee34d0c0ea3ce71be141120a57ce77"},"headline":"How To Show MySQL Databases Using Command Line and cPanel","datePublished":"2025-06-13T14:27:54+00:00","dateModified":"2026-01-16T22:56:42+00:00","mainEntityOfPage":{"@id":"https:\/\/www.hostarmada.com\/blog\/show-databases-guide\/"},"wordCount":1859,"commentCount":0,"publisher":{"@id":"https:\/\/www.hostarmada.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.hostarmada.com\/blog\/show-databases-guide\/#primaryimage"},"thumbnailUrl":"https:\/\/www.hostarmada.com\/blog\/wp-content\/uploads\/2025\/06\/show-databases-a-step-by-step-guide-for-command-line-and-cpanel-scaled.png","keywords":["backend tutorials","database management","MySQL","MySQL command line","server access","SQL administration"],"articleSection":["Databases","Tips"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.hostarmada.com\/blog\/show-databases-guide\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.hostarmada.com\/blog\/show-databases-guide\/","url":"https:\/\/www.hostarmada.com\/blog\/show-databases-guide\/","name":"How To Show MySQL Databases Using Command Line and cPanel","isPartOf":{"@id":"https:\/\/www.hostarmada.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.hostarmada.com\/blog\/show-databases-guide\/#primaryimage"},"image":{"@id":"https:\/\/www.hostarmada.com\/blog\/show-databases-guide\/#primaryimage"},"thumbnailUrl":"https:\/\/www.hostarmada.com\/blog\/wp-content\/uploads\/2025\/06\/show-databases-a-step-by-step-guide-for-command-line-and-cpanel-scaled.png","datePublished":"2025-06-13T14:27:54+00:00","dateModified":"2026-01-16T22:56:42+00:00","description":"Learn how to list MySQL databases using command-line tools, understand permission issues, and avoid common mistakes.","breadcrumb":{"@id":"https:\/\/www.hostarmada.com\/blog\/show-databases-guide\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.hostarmada.com\/blog\/show-databases-guide\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.hostarmada.com\/blog\/show-databases-guide\/#primaryimage","url":"https:\/\/www.hostarmada.com\/blog\/wp-content\/uploads\/2025\/06\/show-databases-a-step-by-step-guide-for-command-line-and-cpanel-scaled.png","contentUrl":"https:\/\/www.hostarmada.com\/blog\/wp-content\/uploads\/2025\/06\/show-databases-a-step-by-step-guide-for-command-line-and-cpanel-scaled.png","width":2560,"height":1280,"caption":"Show Databases: A Step-by-Step Guide for Command Line and cPanel"},{"@type":"BreadcrumbList","@id":"https:\/\/www.hostarmada.com\/blog\/show-databases-guide\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"HostArmada Blog","item":"https:\/\/www.hostarmada.com\/blog\/"},{"@type":"ListItem","position":2,"name":"How To Show MySQL Databases Using Command Line and cPanel"}]},{"@type":"WebSite","@id":"https:\/\/www.hostarmada.com\/blog\/#website","url":"https:\/\/www.hostarmada.com\/blog\/","name":"HostArmada Blog","description":"HostArmada official blog. Useful web hosting related articles.","publisher":{"@id":"https:\/\/www.hostarmada.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.hostarmada.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.hostarmada.com\/blog\/#organization","name":"HostArmada Blog","url":"https:\/\/www.hostarmada.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.hostarmada.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.hostarmada.com\/blog\/wp-content\/uploads\/2022\/06\/logo-png-300x43-1.png","contentUrl":"https:\/\/www.hostarmada.com\/blog\/wp-content\/uploads\/2022\/06\/logo-png-300x43-1.png","width":300,"height":44,"caption":"HostArmada Blog"},"image":{"@id":"https:\/\/www.hostarmada.com\/blog\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/www.hostarmada.com\/blog\/#\/schema\/person\/bbee34d0c0ea3ce71be141120a57ce77","name":"Martin Atanasov","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/f05b145ab7d0cedd034f0325cb9f16f3bb0f1da31e03e0f042f5e79a1cb0496b?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/f05b145ab7d0cedd034f0325cb9f16f3bb0f1da31e03e0f042f5e79a1cb0496b?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/f05b145ab7d0cedd034f0325cb9f16f3bb0f1da31e03e0f042f5e79a1cb0496b?s=96&d=mm&r=g","caption":"Martin Atanasov"},"description":"Martin is a content writer, copywriter, and blogger with vast experience in journalism and digital marketing. He has hundreds of articles on topics ranging from SEO, digital marketing, web content, and brand marketing. With his unique ability to convey complex issues and technical topics in a relatable and understandable language, Martin is determined to give our readers an inside look, professional tips, and useful advice on all aspects of the Web Hosting Service.","sameAs":["https:\/\/hostarmada.com"],"url":"https:\/\/www.hostarmada.com\/blog\/author\/martinatanasov737\/"}]}},"_links":{"self":[{"href":"https:\/\/www.hostarmada.com\/blog\/wp-json\/wp\/v2\/posts\/5410","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.hostarmada.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.hostarmada.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.hostarmada.com\/blog\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/www.hostarmada.com\/blog\/wp-json\/wp\/v2\/comments?post=5410"}],"version-history":[{"count":8,"href":"https:\/\/www.hostarmada.com\/blog\/wp-json\/wp\/v2\/posts\/5410\/revisions"}],"predecessor-version":[{"id":6088,"href":"https:\/\/www.hostarmada.com\/blog\/wp-json\/wp\/v2\/posts\/5410\/revisions\/6088"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.hostarmada.com\/blog\/wp-json\/wp\/v2\/media\/5424"}],"wp:attachment":[{"href":"https:\/\/www.hostarmada.com\/blog\/wp-json\/wp\/v2\/media?parent=5410"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.hostarmada.com\/blog\/wp-json\/wp\/v2\/categories?post=5410"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.hostarmada.com\/blog\/wp-json\/wp\/v2\/tags?post=5410"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}