Re: null, message from server: "Host '192.168.1.114' is not allowed to connect to this MySQL server"

[David Ashman]

Root may not have permission to be logged in from a machine other than localhost. You can see where root can be logged in from with the query:

SELECT `host` FROM mysql.user WHERE `user`='root'

% means anywhere, and that would be bad for a root account. Hopefully it says localhost.


You want to add a user for the app (you should never log in as root from an app!)

CREATE USER javaapp IDENTIFIED BY 'somepasswordhere';
GRANT SELECT,INSERT,UPDATE,DELETE ON ZoneVAXIN.* TO javaapp;

(or something like that)