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.
mysql --host=xxx.xxx.x.x --password --port 3306