Wordpress (hacking) Login attempts
This time I will present the number of login attempts per username for my WordPress site www.highiso.net (no longer live).
As I am using a WordPress plugin, I had to get the data from the MySQL database as follows:
mysql> select log_username, count(log_username) from wp_itsec_log where log_function="Invalid Login Attempt" group by log_username;
+--------------+---------------------+
| log_username | count(log_username) |
+--------------+---------------------+
| admin | 656 |
| JohnThomas | 1 |
| mtsou | 2 |
| tsoukalos | 386 |
+--------------+---------------------+
4 rows in set (0.00 sec)
You can see two visualizations of the data that were created using R.

