Clear bad logins
Jump to navigation
Jump to search
As the root super user, login to the server using ssh and then login to the MySQL server as the root user: (In my case using a newer Linux distribution such as Fedora 21, MySQL has been replaced by the MariaDB MySQL FREE clone!)
~# mysql -p Enter password: Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 935 Server version: 5.5.40-MariaDB MariaDB Server Copyright (c) 2000, 2014, Oracle, Monty Program Ab and others. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. MariaDB [(none)]>
Switch to the database used for the Drupal installation, in my case, I named it drupal:
MariaDB [(none)]> use drupal; Database changed MariaDB [drupal]>
Do the actual command which clears out the data stored that has locked out accounts after 5 failed attempts:
MariaDB [drupal]> delete from flood; Query OK, 0 rows affected (0.00 sec) MariaDB [drupal]>
Log out of the database server:
MariaDB [drupal]> quit Bye [root@erma ~]#