MySQL Power BI Online Gateway error cannot connect to mashup data source

I created dataset and report in power bi desktop using mysql database but report is not refreshing online via gateway, resulting in below error: MySQL: Host '##.##.##.##' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts' Tried flushing hosts numerious time. Tried using multiple gateways, personnal and enterprise both. Verified that latest Power BI, Gateway and MySQL connector is installed. Appreciate your help on the issue.