Mysql logs only for one database

Question

Hot to configure mysql to log information, only for specific database or table?

For example i need to log authentification requests from Postfix to mysql.

Thanks ;)

Answer 1

You can use the MySQL query log for this. It can only be activated for the whole MySQL server and not only a specific table or database but you can use the standard UNIX command line tools like grep to get the specific information you want out of the log file.