|
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.
|