Once the MySQL or MariaDB shell is installed on your computer, the user can access and explore all databases via the terminal. Do do so, we start by login into the databases with the following commands assuming that the user has the login credentials.


It is not necessary to install the MySQL shell on your computer if you want to interact with the database using only Python. Installing the PyMySQL library will suffice. However, it can be very useful for those who want to access the database directly using Bash and a plotting tool like gnuplot.

Login to the database via the terminal

mysql --host=xxx.xxx.x.x --password --port 3306

To show all databases available


Selecting a database (example 3MdBs)

USE 3MdBs;

Showing tables in a database


View table fields/columns (example shock_params)

DESCRIBE shock_params;