Steps to View MariaDB databases in SSH

The interfaces for managing databases in cPanel using MariaDB will resemble those of MySQL. MariaDB is designed to be a seamless substitute for MySQL. In this lesson, we’ll learn how to examine and access databases using SSH commands.

Steps to View MariaDB databases in SSH

1. Login to SSH.

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’s password.

MariaDB [(none)]> mysql -u username -p

If you are able to login successfully, you will see the below screen. Note that you see that you’re using MariaDB at this point.

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.

MariaDB [(none)]> show databases;

A list of databases that are assigned to the user name that you are using will get displayed.

4. Here you need to select your database. After selecting the database, your prompt will change to choose the database you have selected.

MariaDB [(none)]> use databasename;

5. Many commands are used in displaying the contents of a database. But here we will see just a few of them:
With the below command, a list of the tables from the database will get displayed.

MariaDB [arnel_test1]> show tables;

For seeing all the records in a specific table, use the below command:

MariaDB [arnel_test1]> select * from databasetablename;

For seeing all the database table field names, configuration and type of a certain table, use the below command:

MariaDB [arnel_test1]> describe databasetablename;

Note: For checking database specifics, it is needed to have a selected database with the USE command.

Congratulations you have learned to view a database using the command line in MariaDB.

Learn to Turn Off PHP Error Reporting