Difference between revisions of "Clear bad logins"
Jump to navigation
Jump to search
(Created page with "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 h...") |
|||
| Line 17: | Line 17: | ||
<br /> | <br /> | ||
Switch to the database used for the Drupal installation, in my case, I named it drupal: | Switch to the database used for the Drupal installation, in my case, I named it drupal: | ||
| − | <pre style="color:blue> | + | <pre style="color:blue"> |
MariaDB [(none)]> use drupal; | MariaDB [(none)]> use drupal; | ||
Database changed | Database changed | ||
| + | MariaDB [drupal]> | ||
| + | </pre> | ||
| + | <br /><br /> | ||
| + | |||
| + | Do the actual command which clears out the data stored that has locked out accounts after 5 failed attempts: | ||
| + | <pre style"color:blue"> | ||
| + | MariaDB [drupal]> delete from flood; | ||
| + | Query OK, 0 rows affected (0.00 sec) | ||
| + | |||
MariaDB [drupal]> | MariaDB [drupal]> | ||
</pre> | </pre> | ||
<br /><br /> | <br /><br /> | ||
Revision as of 22:09, 12 April 2015
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]>