{"id":7420,"date":"2020-04-16T12:52:55","date_gmt":"2020-04-16T12:52:55","guid":{"rendered":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/?p=7420"},"modified":"2020-04-16T12:52:55","modified_gmt":"2020-04-16T12:52:55","slug":"view-mariadb-databases-in-ssh","status":"publish","type":"post","link":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/view-mariadb-databases-in-ssh\/","title":{"rendered":"Steps to View MariaDB databases in SSH"},"content":{"rendered":"<p>While working with MariaDB to manage databases in cPanel, the interfaces will be similar to that with MySQL. MariaDB is just made as a drop-in replacement for MySQL. In this tutorial we will see some commands using SSH for accessing the database and viewing it.<\/p>\n<h3>Steps to View MariaDB databases in SSH<\/h3>\n<p>1. Login to SSH.<\/p>\n<p>2. Using the database user assigned to the database you want to view, login to MySQL (MariaDB). When the below command is executed, you will need to enter the MySQL user\u2019s password.<\/p>\n<pre class=\"lang:default decode:true \">MariaDB [(none)]&gt; mysql -u username -p<\/pre>\n<p>If you are able to login successfully, you will see the below screen. Note that you see that you\u2019re using MariaDB at this point.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-9358\" src=\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2020\/04\/mariadb-view_login-to-mysql-min.png\" alt=\"\" width=\"688\" height=\"211\" \/><\/p>\n<p>3. You may find more than one database assigned to the user that you used to login to the mysql command line. So, select the database that will be used.<\/p>\n<pre class=\"lang:default decode:true \">MariaDB [(none)]&gt; show databases;<\/pre>\n<p>A list of databases that are assigned to the user name that you are using will get displayed.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-9359\" src=\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2020\/04\/mariadb-view_show-databases-min.png\" alt=\"\" width=\"676\" height=\"326\" \/><\/p>\n<p>4. Here you need to select your database. After selecting the database, your prompt will change to choose the database you have selected.<\/p>\n<pre class=\"lang:default decode:true \">MariaDB [(none)]&gt; use databasename;<\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-9360\" src=\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2020\/04\/mariadb-view_select-db-min.png\" alt=\"\" width=\"723\" height=\"403\" \/><\/p>\n<p>5. Many commands are used in displaying the contents of a database. But here we will see just a few of them:<br \/>\nWith the below command, a list of the tables from the database will get displayed.<\/p>\n<pre class=\"lang:default decode:true \">MariaDB [arnel_test1]&gt; show tables;<\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-9361\" src=\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2020\/04\/mariadb-view_show-tables-min.png\" alt=\"\" width=\"580\" height=\"294\" \/><\/p>\n<p>For seeing all the records in a specific table, use the below command:<\/p>\n<pre class=\"lang:default decode:true \">MariaDB [arnel_test1]&gt; select * from databasetablename;<\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-9362\" src=\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2020\/04\/mariadb-view_show-records-min-1024x90.png\" alt=\"\" width=\"1024\" height=\"90\" \/><\/p>\n<p>For seeing all the database table field names, configuration and type of a certain table, use the below command:<\/p>\n<pre class=\"lang:default decode:true \">MariaDB [arnel_test1]&gt; describe databasetablename;<\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-9363\" src=\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2020\/04\/mariadb-view_describe-table-min.png\" alt=\"\" width=\"655\" height=\"196\" \/><\/p>\n<p><strong>Note:<\/strong> For checking database specifics, it is needed to have a selected database with the USE command.<\/p>\n<p>Congratulations you have learned to view a database using the command line in MariaDB.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>While working with MariaDB to manage databases in cPanel, the interfaces will be similar to that with MySQL. MariaDB is just made as a drop-in replacement for MySQL. In this tutorial we will see some commands using SSH for accessing the database and viewing it. Steps to View MariaDB databases in SSH 1. Login to [&hellip;]<\/p>\n","protected":false},"author":16,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[230],"tags":[1152,1398,1399,121],"class_list":["post-7420","post","type-post","status-publish","format-standard","placeholder-for-hentry","category-database","tag-database","tag-mariabd","tag-mariadb-database","tag-ssh"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.2 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Steps to View MariaDB databases in SSH<\/title>\n<meta name=\"description\" content=\"The article reveals steps to view the MariaDB database in SSH.\" \/>\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\/view-mariadb-databases-in-ssh\/\" \/>\n<meta property=\"og:locale\" content=\"en_GB\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Steps to View MariaDB databases in SSH\" \/>\n<meta property=\"og:description\" content=\"The article reveals steps to view the MariaDB database in SSH.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/view-mariadb-databases-in-ssh\/\" \/>\n<meta property=\"og:site_name\" content=\"Web Hosting FAQs by MilesWeb\" \/>\n<meta property=\"article:published_time\" content=\"2020-04-16T12:52:55+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2020\/04\/mariadb-view_login-to-mysql-min.png\" \/>\n<meta name=\"author\" content=\"Pallavi Godse\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Pallavi Godse\" \/>\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\/view-mariadb-databases-in-ssh\/\",\"url\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/view-mariadb-databases-in-ssh\/\",\"name\":\"Steps to View MariaDB databases in SSH\",\"isPartOf\":{\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/view-mariadb-databases-in-ssh\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/view-mariadb-databases-in-ssh\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2020\/04\/mariadb-view_login-to-mysql-min.png\",\"datePublished\":\"2020-04-16T12:52:55+00:00\",\"author\":{\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#\/schema\/person\/7e3952607fa9eb4e82fea9f7cad9c945\"},\"description\":\"The article reveals steps to view the MariaDB database in SSH.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/view-mariadb-databases-in-ssh\/#breadcrumb\"},\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/view-mariadb-databases-in-ssh\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/view-mariadb-databases-in-ssh\/#primaryimage\",\"url\":\"\",\"contentUrl\":\"\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/view-mariadb-databases-in-ssh\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Steps to View MariaDB databases in SSH\"}]},{\"@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\/7e3952607fa9eb4e82fea9f7cad9c945\",\"name\":\"Pallavi Godse\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/eefc9695ea2b2c6e143c9c9919701aaa?s=96&d=blank&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/eefc9695ea2b2c6e143c9c9919701aaa?s=96&d=blank&r=g\",\"caption\":\"Pallavi Godse\"},\"description\":\"Pallavi is a Digital Marketing Executive at MilesWeb and has an experience of over 4 years in content development. She is interested in writing engaging content on business, technology, web hosting and other topics related to information technology.\",\"url\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/author\/pallavi\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Steps to View MariaDB databases in SSH","description":"The article reveals steps to view the MariaDB database in SSH.","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\/view-mariadb-databases-in-ssh\/","og_locale":"en_GB","og_type":"article","og_title":"Steps to View MariaDB databases in SSH","og_description":"The article reveals steps to view the MariaDB database in SSH.","og_url":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/view-mariadb-databases-in-ssh\/","og_site_name":"Web Hosting FAQs by MilesWeb","article_published_time":"2020-04-16T12:52:55+00:00","og_image":[{"url":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2020\/04\/mariadb-view_login-to-mysql-min.png","type":"","width":"","height":""}],"author":"Pallavi Godse","twitter_misc":{"Written by":"Pallavi Godse","Estimated reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/view-mariadb-databases-in-ssh\/","url":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/view-mariadb-databases-in-ssh\/","name":"Steps to View MariaDB databases in SSH","isPartOf":{"@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/view-mariadb-databases-in-ssh\/#primaryimage"},"image":{"@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/view-mariadb-databases-in-ssh\/#primaryimage"},"thumbnailUrl":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2020\/04\/mariadb-view_login-to-mysql-min.png","datePublished":"2020-04-16T12:52:55+00:00","author":{"@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#\/schema\/person\/7e3952607fa9eb4e82fea9f7cad9c945"},"description":"The article reveals steps to view the MariaDB database in SSH.","breadcrumb":{"@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/view-mariadb-databases-in-ssh\/#breadcrumb"},"inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.milesweb.co.uk\/hosting-faqs\/view-mariadb-databases-in-ssh\/"]}]},{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/view-mariadb-databases-in-ssh\/#primaryimage","url":"","contentUrl":""},{"@type":"BreadcrumbList","@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/view-mariadb-databases-in-ssh\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/"},{"@type":"ListItem","position":2,"name":"Steps to View MariaDB databases in SSH"}]},{"@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\/7e3952607fa9eb4e82fea9f7cad9c945","name":"Pallavi Godse","image":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/eefc9695ea2b2c6e143c9c9919701aaa?s=96&d=blank&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/eefc9695ea2b2c6e143c9c9919701aaa?s=96&d=blank&r=g","caption":"Pallavi Godse"},"description":"Pallavi is a Digital Marketing Executive at MilesWeb and has an experience of over 4 years in content development. She is interested in writing engaging content on business, technology, web hosting and other topics related to information technology.","url":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/author\/pallavi\/"}]}},"views":627,"_links":{"self":[{"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/posts\/7420","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\/16"}],"replies":[{"embeddable":true,"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/comments?post=7420"}],"version-history":[{"count":2,"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/posts\/7420\/revisions"}],"predecessor-version":[{"id":7428,"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/posts\/7420\/revisions\/7428"}],"wp:attachment":[{"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/media?parent=7420"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/categories?post=7420"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/tags?post=7420"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}