1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
mysql> select user,host from mysql.user;
+------------------+------------------------+
| user             | host                   |
+------------------+------------------------+
| foo_user         | %                      |
| root             | 127.0.0.1              |
| foo_user         | 71.91.217.116          |
| foo_user2        | 71.91.217.116          |
| root             | ::1                    |
|                  | domU-12-31-38-04-B2-89 |
| root             | domU-12-31-38-04-B2-89 |
|                  | localhost              |
| debian-sys-maint | localhost              |
| phpmyadmin       | localhost              |
| root             | localhost              |
+------------------+------------------------+


mysql> SHOW GRANTS FOR 'root'@'localhost';
+----------------------------------------------------------------------------------------------------------------------------------------+
| Grants for root@localhost                                                                                                              |
+----------------------------------------------------------------------------------------------------------------------------------------+
| GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY PASSWORD '*4F4504C8CA8D22648E58B5092F653457698A9EBE' WITH GRANT OPTION |
| GRANT PROXY ON ''@'' TO 'root'@'localhost' WITH GRANT OPTION                                                                           |
+----------------------------------------------------------------------------------------------------------------------------------------+


look at login attempts

http://www.mysqlperformanceblog.com/2012/12/28/auditing-login-attempts-in-mysql/