View source for viewing drupal logs from CLI

==problem== viewing drupal logs without using the web interface or drush

drupal logs are kept in the backend database,so we can pull them from there.

==solution==

(optional) create a database user just for viewing 

example from mysql shell 

 mysql> GRANT SELECT ON 'my_database_name'.* TO 'my_username'@'localhost' IDENTIFIED BY 'mypassword';

view watchlog logs
 mysql -h localhost -u my_username my_database_name -e "select hostname from watchdog " --password=my_password