So I recently needed to do a search of the database log files to see if there was any hosting accounts that were no longer connecting properly to their databases. Originally I did the following search:
find /home -name "error_log" -exec grep -H "Access denied for user" {} ;
Then I was given the actual log file to search in for specific database errors instead of the entire systems error_log files for matching text.
less /var/lib/mysql/mysql-error.err | grep 'Access denied for user'| grep -v root