Host 'xxx.x.x.xxx is not allowed to connect to this MySQL server

Top  Previous  Next

If "Host 'xxx.x.x.xxx is not allowed to connect to this MySQL server" is logged in

/usr/ngasi/logs/catalina.out,

it suggests the Host (Node ) System in which NGASI AppServer Manager is installed

does not have access to the Plesk Database installed in a VPS.

 

Grant access is done in the following way:

GRANT DELETE,INSERT,UPDATE, SELECT,INDEX,REFERENCES,

LOCK TABLES, CREATE TEMPORARY TABLES ON psa.* TO admin@"%" IDENTIFIED BY 'passwd';

 

Replace "passwd" with the same password found in /etc/psa/.psa.shadow.

 

Make sure NGASI AppServer Manager is restarted.