Hello,
I would like to log aborted connections in my MySQL 5.1 Server. According to related doc (MySQL :: MySQL 5.1 Reference Manual :: 5.1.2 Server Command Options) I modified log-warnings variable to 2.
mysql> show variables like ‘log_warnings’;
±--------------±------+
| Variable_name | Value |
±--------------±------+
| log_warnings | 2 |
±--------------±------+
1 row in set (0.01 sec)
Then I tested this function with the following command (it tried to connect to database with wrong password):
for (( i = 0; i <= 50; i++ )); do mysql -h localhost -u testuser -p1123; done
ERROR 1045 (28000): Access denied for user ‘testuser’@‘localhost’ (using password: YES)
…
I executed this command several times but unfortunately, there is no warning message in error log.
Could you help anyone?
Thanks in advance!