hi guys. pls I just developed a java GUI software
and I need to access a remote database. but as
we know by default databases won't allow that
except you tell it to grant access. but that's
where I'm stuck. pls has any one developed a
software that accesses a remote db? pls signify.
really appreciate

U need to add/grant the permission of the host connecting on mysql, also on machine level, u need to allow the ip and port 3306 rules on iptables

javadoctor:
U need to add/grant the permission of the host connecting on mysql, also on machine level, u need to allow the ip and port 3306 rules on iptables

thank God you r a java doctor cos I sure do need some medication in java. how exactly do I grant the permission? can I do it from panel? also is there a syntax to do it on the mysql console? pls help. thanks bro

also pls note that the GUI would be used on any system world wide so I need it go allow all ips coming.

GRANT ALL PRIVILEGES ON *.* TO 'user'@'ipadress'

You only need to allow one machine, which is the server side to connect to remote mysql, and manage your threads on server side.

javadoctor:
GRANT ALL PRIVILEGES ON *.* TO 'user'@'ipadress'

wow. thanks so much. so the 'IPaddress' is my server address right? where the database resides?

nnamdiosu:


wow. thanks so much. so the 'IPaddress' is my server address right? where the database resides?

Your public address or intranet address in the same subnet where request are coming frm