MySQL: Log only drop/create commands

just to inform the curious one: dig in your error log and presto!

(1). edit my.cnf (Settings documentation found here)

[mysqld]

:#Enter a name for the error log file. Otherwise a default name will be used.

log_error = /var/log/mysql/error

:#defaults to 1. If the value is > 1, aborted connections and access-denied errors for new connection attempts are written to the error log

log_warnings = 2

...

(2). at command run

$ sudo cat /var/log/mysql/error.err | egrep '[aA]ccess denied'

(3). and you have it!

(4). if you need to restrict the user (dos attack or mysql user password recovering attempt in a multi user database), then (http://dev.mysql.com/doc/refman/5.5/en/user-resources.html)

mysql> GRANT USAGE ON * . * TO 'attacker'@'localhost' WITH MAX_CONNECTIONS_PER_HOUR 100;

to restrict to only 100 password recovering attempts per hour.

InnoDB is insanely picky about it's config; if something's not right, it'll just give up and go home. To make a change to the log file size without data loss:

1. Revert any config changes you've made to the log file size and start MySQL again.
2. In your running MySQL: SET GLOBAL innodb_fast_shutdown=0;
3. Stop MySQL
4. Make the configuration change to the log file size.
5. Delete both log files.
6. Start MySQL. It will complain about the lack of log files, but it'll create them and all will be well.