=== Dumping and Importing database ===
Best practice states that the /home/user/.my.cnf or /root/.my.cnf file should be created (depending on what user you are taking the dump with) with the appropriate credentials before taking a mysql dump. This is not mandatory but certainly makes life easier when working with mysql
\\
Creating the file is as easy as:
<sxh bash>
vim /root/.my.cnf
</sxh>
<sxh bash>
[client]
user: root
password: mypassword
</sxh>
=== Viewing databases outside of mysql ===
You can view your mysql databases without logging into mysql with the following command:

<sxh bash>mysql -e "show databases"</sxh>
or
<sxh bash>mysqlshow </sxh>