Documentation Home
MySQL 9.3 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 40.8Mb
PDF (A4) - 40.9Mb
Man Pages (TGZ) - 261.1Kb
Man Pages (Zip) - 368.3Kb
Info (Gzip) - 4.1Mb
Info (Zip) - 4.1Mb


MySQL 9.3 Reference Manual  /  ...  /  The connection_control_failed_login_attempts Table

29.12.22.2 The connection_control_failed_login_attempts Table

This table provides information about the current number of consecutive failed connection attempts per account.

The connection_control_failed_login_attempts table has the these columns:

  • USERHOST

    A MySQL user account name in user@host format.

  • FAILED_ATTEMPTS

    The number of failed connection attempts by this user.

This table is created and updated by the Connection Control component, introduced in MySQL 9.2.0. It replaces the Information Schema CONNECTION_CONTROL_FAILED_LOGIN_ATTEMPTS table, which—like the Connection Control plugins—is now deprecated, and subject to removal in a future version of MySQL. For more information, see Section 8.4.2, “The Connection Control Component”.