Issue ERROR: PleskMainDBException Host '127.0.0.1' is not allowed

[hostking]

Getttin this error after rebooting server all of a sudden. Has been working for over a year with not 1 change at all.

ERROR: PleskMainDBException Host '127.0.0.1' is not allowed

Is it a auto update of some sort that caused this.

I googled a bit and after adding the below to the plesk mysql.ini file it seems to be working again. But I highly doubt that is secure.

How to fix?

skip-grant-tables
bind-address = 127.0.0.1

 

[serverpoint]

Hi,

Seems your MySQL server is not correctly configured. You should just grant connection possibility for 127.0.0.1 in MySQL settings, which you have already done and it secure since the access is for localhost.

Thanks,