Searching the Database Logs for Access Denied

,

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

 

Skills

Posted on

August 20, 2015

Submit a Comment

Your email address will not be published.