Brute Force Whitelisting does not work, can't clear the Brute Force Table

Nextcloud version: 20.0.6
Operating system and version: Unraid 6.8.3

The issue you are facing:

I had problems logging into an account on a phone, which triggered my IP Address being added to my own server’s brute force table, which means every single time I login from my IP, it’s always throttled by 30 seconds.

Whitelisting in the Brute Force Settings does not work. The only time it does work is if I put a 0 after the slash notation for my WAN IP, which is effectively the same as disabling Brute Force security altogether.

I am running my Nextcloud Server on Unraid using MariaDB. I found an old thread about this exact problem, and tried the solution, writing:

MariaDB [mydatabase]> DELETE FROM oc_bruteforce_attempts WHERE ip = 'my.wan.ip.address';

But got:
Query OK, 0 rows affected (0.001 sec)

Which means it obviously did not work.

Seeing as the Brute Force Settings are not working, how do I clear my Brute Force table in my database?

Is this the first time you’ve seen this error? (Y/N): Yes

Steps to replicate it:

  1. Have Brute Force settings turned on.
  2. Keep entering the incorrect password several times until the IP gets marked and throttled.
  3. You are now unable to log in on this IP without waiting 30 seconds.

Closing in favor of Brute Force Whitelisting does not work, don't know how to clear the Brute Force Table