How do I remove ALL remote database access hosts?

[devonhosting]

Ho do I Remove ALL Remote Database Access Hosts from within WHM or with SSH as I do not want to go through 200 accounts and delete them one by one? Clients have been lazy and left old IP addresses in the individual cPanel account.

Thanks in advance

 

[caisc]

I am facing the same problem, as devonhosting mentioned.


I searched this forum for a solution to this issue and also tried with Google but was not able to find a solution, finally decided to bump this thread.

If any cpanel staff can guide me, I will be grateful.

Thanks

 

[cPanelMichael]

Hello

You could develop a script that utilizes this UAPI function:

UAPI Functions - Mysql::delete_host - Software Development Kit - cPanel Documentation

Thank you.