$ cd /path/to/moodle
$ grep CFG-\>db config.php
$CFG->dbtype = 'mysqli';
$CFG->dblibrary = 'native';
$CFG->dbhost = 'localhost';
$CFG->dbname = 'dbname';
$CFG->dbuser = 'dbuser';
$CFG->dbpass = 'dbpass';
$CFG->dboptions = array (
$ mysql -udbuser -pdbpass dbname
Welcome to the MySQL monitor. ...
Here is a sample "screen shot":