How to remove the IP address from cPHulk bruteforce attack via cPanel database?
This account is currently locked out because a brute force attempt was detected. Please wait 10 minutes and try again. Attempting to login again will only increase this delay. If you frequently experience this problem, we recommend having your username changed to something less generic.
You cannot login to the account – Brute Fore protection
Normal method we can just whitelist the IP address from the cPHulk option available in the WHM. But still the IP address is available in the database.
How can we remove the IP address from the database?
First find your IP address of your local machine.
if you can ssh to the server login as root and execute the following in the server.
prompt should change to mysql
mysql> use cphulkd;
you will see…database changed
mysql>BACKUP TABLE `brutes` TO ‘/path/to/backup/directory’;
mysql> SELECT * FROM `brutes` WHERE `IP`=’xxx.xxx.xxx.xxx’;
insert your IP instead xxx.xxx.xxx.xxx. Is your IP there? If so,
mysql> DELETE FROM `brutes` WHERE `IP`=’xxx.xxx.xxx.xxx’;
that should remove your IP from the table and you will see that in mysql reply. Finally
should return you to your usual prompt.
Now you can proceed logging into the cPanel without any issue.
This below command will flush full database. i.e all the blocked IP will be flushed.
mysql> delete from brutes;
Query OK, 0 rows affected (0.00 sec)
mysql> delete from logins;
Query OK, 32 rows affected (0.00 sec)