MySQL5.5 status Aborted_connects 实验

实验目的：Aborted_connects影响值的因素

 

session_1:

root@localhost : (none) 10:56:12> grant all privileges on *.* to 'renwen'@'192.168.0.100' identified by 'renwen';
Query OK, 0 rows affected (0.01 sec)

root@localhost : (none) 10:57:44> show global status like 'Aborted_connects';
+------------------+-------+
| Variable_name | Value |
+------------------+-------+
| Aborted_connects | 2 |
+------------------+-------+
1 row in set (0.00 sec)

session_2:

 

IP：192.168.0.101

[root@data /root]# mysql -h192.168.0.130 -P3306 -urenwen -prenwen
ERROR 1045 (28000): Access denied for user 'renwen'@'192.168.0.130' (using password: YES)

session_1:

root@localhost : (none) 11:02:46> show global status like 'Aborted_connects';
+------------------+-------+
| Variable_name | Value |
+------------------+-------+
| Aborted_connects | 3 |
+------------------+-------+
1 row in set (0.00 sec)

结论：当访问权限不够时的连接，会引起参数Aborted_connects值的变化。