Business Analyst, MTN Uganda

Anthony Matovu

<div>
Thank you so far,<br><br>but in my string, I am not typing in 41.210.145.254<br>where does it come from<br><br>The passwords are not valid, though I will do my best to align with security issues <br><br>
</div>


<div>
while girioins provided an excample, I would not grant ALL to an external login as the example depicts.<br />
<br />
always limit to the required the user@host<br />
<br />
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.
</div>


<div>
<div class="content wysiwyg-content">
Help : <br />
<br />
I am failing to connect to a remote mysql server with an error message, <br />
<br />
message from server: &quot;Host 'h11fe.n1.ips.mtn.co.ug' is not allowed to connect to this MySQL server&quot;<br />
<br />
below is my connection string<br />
<br />
String url = &quot;jdbc:mysql://162.214.91.1<wbr />70/datranc<wbr />o_datrandb<wbr />&quot;;<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;// &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;String username = &quot;datranco_main&quot;;<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;// &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;String password = &quot;%987&quot;;
</div>
</div>


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.170/datranco_datrandb";
		//	 String username = "datranco_main";
		//	 String password = "%987";

failing to connect to mysql server

Java is a platform-independent, object-oriented programming language and run-time environment, designed to have as few implementation dependencies as possible such that developers can write one set of code across all platforms using libraries. Most devices will not run Java natively, and require a run-time component to be installed in order to execute a Java program.

Java

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.