Anthony Matovu
asked on
failing to connect to mysql server
Help :
I am failing to connect to a remote mysql server with an error message,
message from server: "Host 'h11fe.n1.ips.mtn.co.ug' is not allowed to connect to this MySQL server"
below is my connection string
String url = "jdbc:mysql://162.214.91.1 70/datranc o_datrandb ";
// String username = "datranco_main";
// String password = "%987";
I am failing to connect to a remote mysql server with an error message,
message from server: "Host 'h11fe.n1.ips.mtn.co.ug' is not allowed to connect to this MySQL server"
below is my connection string
String url = "jdbc:mysql://162.214.91.1
// String username = "datranco_main";
// String password = "%987";
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
while girioins provided an excample, I would not grant ALL to an external login as the example depicts.
always limit to the required the user@host
Having a directly accessible mysql from the internet is not advisable. use SSH tunnels, or VPN to have a more secure path to the data.
always limit to the required the user@host
Having a directly accessible mysql from the internet is not advisable. use SSH tunnels, or VPN to have a more secure path to the data.
ASKER
but in my string, I am not typing in 41.210.145.254
where does it come from
The passwords are not valid, though I will do my best to align with security issues