Difference between revisions of "Clear bad logins"
Jump to navigation
Jump to search
| (One intermediate revision by the same user not shown) | |||
| Line 23: | Line 23: | ||
</pre> | </pre> | ||
<br /><br /> | <br /><br /> | ||
| − | |||
Do the actual command which clears out the data stored that has locked out accounts after 5 failed attempts: | Do the actual command which clears out the data stored that has locked out accounts after 5 failed attempts: | ||
| − | <pre style"color:blue"> | + | <pre style="color:blue"> |
MariaDB [drupal]> delete from flood; | MariaDB [drupal]> delete from flood; | ||
Query OK, 0 rows affected (0.00 sec) | Query OK, 0 rows affected (0.00 sec) | ||
| − | |||
MariaDB [drupal]> | MariaDB [drupal]> | ||
</pre> | </pre> | ||
<br /><br /> | <br /><br /> | ||
| + | Log out of the database server: | ||
| + | <pre style="color:blue"> | ||
| + | MariaDB [drupal]> quit | ||
| + | Bye | ||
| + | [root@erma ~]# | ||
| + | </pre> | ||
| + | <br /> | ||
Latest revision as of 22:26, 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]>
Log out of the database server:
MariaDB [drupal]> quit Bye [root@erma ~]#