My Oracle Support Banner

Lock User Account upon Login Failures with PAM Authentication Plugin (Doc ID 2254651.1)

Last updated on MARCH 05, 2020

Applies to:

MySQL Server - Version 5.5 and later
Information in this document applies to any platform.


As of MySQL 5.5, MySQL Enterprise Edition includes PAM authentication plugin, which outsource authentication to PAM libraries which is installed on the host. PAM has an ability to block further logins when certain times of login attempt fails. Combining this capability and PAM authentication plugin allows to MySQL Server to block login attempts for user account which failed certain times. Failed logins may be a symptom of unauthorized access from attackers. So, locking account will make your MySQL Server more secure. But be careful that it will block login attempts from your applications, too, once the user account is locked due to login failures.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.