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

🍱 Features & apps bruteforcesettings
1

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?