Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-20997

max_password_errors not working

    XMLWordPrintable

    Details

      Description

      We have a requirement to block a user after maximum permitted number of failed connection.

      We use max_password_errors Variable but it doesn't seem to take affect. The version of Mariadb we have is Server version: 10.4.6-MariaDB MariaDB Server.

      We set this variable in /etc/my.cnf.d/server.cnf file under mariadb section.

      1. This group is only read by MariaDB servers, not by MySQL.
      2. If you use the same .cnf file for MySQL and MariaDB,
      3. you can put MariaDB-only options here
        [mariadb]
        max_password_errors=2

      Packages we installed are as below:

      rpm -qa|grep -i maria
      MariaDB-compat-10.4.6-1.el7.centos.x86_64
      MariaDB-cracklib-password-check-10.4.6-1.el7.centos.x86_64
      MariaDB-devel-10.4.6-1.el7.centos.x86_64
      MariaDB-client-10.4.6-1.el7.centos.x86_64
      MariaDB-cracklib-password-check-debuginfo-10.4.6-1.el7.centos.x86_64
      MariaDB-common-10.4.6-1.el7.centos.x86_64
      MariaDB-server-10.4.6-1.el7.centos.x86_64
      galera-4-26.4.2-1.rhel7.el7.centos.x86_64

        Attachments

          Activity

            People

            Assignee:
            Unassigned
            Reporter:
            Ayshkanta Ayshkanta
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: