Access to mysql database in server

[dushantha Rathnayake]

Hi,

I have tow applications.they are server side and client side. in server side i have mysql data base.now the problem is, I want to access into that database using client program.but I don't know how to do it. I tried with following connection statement.

 Connection con=DriverManager.getConnection("jdbc:mysql://localhost/network_admin","root",""); 

Using this code application can't find the data base. so how can I do this? please help me.

Thank you.

[Stephan Mueller]

("jdbc:mysql://localhost/network_admin","root","")

If you are saying that your DBMS resides on a remote server, while you are executing the JDBC code on another client,
then you should understand that

localhost

is the URL for this specific local client the code runs on.
You have to replace localhost with the host adress of the server.

If you are saying somethin else, I suggest that you rephrase your question, try to give more details like
an exact error message.

[dushantha Rathnayake]

Hi,

Actually this is my first remote product. I think you are correct. can you give me an example for this replacement? actually the exception is "Can not find the network_admin database" .

Thank you.

[Paul Sturrock]

So this sounds like you may have a MySQL database running locally without the named database.

You need to replace localhost with the host name or IP address of the remote machine. What that is only you can tell us. You should maybe ask whoever set it up for you?

[dushantha Rathnayake]

Hi,

try{
	Connection con=null;
	PreparedStatement pr;
	ResultSet rs=null;
							
	Class.forName("com.mysql.jdbc.Driver");
	con=DriverManager.getConnection("jdbc:mysql://localhost/network_admin","root","");
	pr=con.prepareStatement("select * from user");
	rs=pr.executeQuery();
							
	while(rs.next()){
		System.out.println(rs.getString("User_Name"));
	}
	con.close();
}
catch(Exception conEX){
	System.out.println(conEX);
}

Actually my friend this is the only way that I know to connect the mysql database into java application. But I don't know this method is possible to remote applications. Think this, I have a mysql database.I can install it into server machine. and then I want to access into that particular database using client machine. So how can I do this? Please help me.

Thank you!

[Stephan Mueller]

con=DriverManager.getConnection("jdbc:mysql://-THE_URL_(IP)_OF_THE_REMOTE_HOST_GOES_HERE_AND_MAY_BE_PREPENDED_WITH_THE_PORT_NUMBER-/network_admin","root","");

and try to avoid using root with no password as the database user.

[dushantha Rathnayake]

Hi,

Thank you. Because now my product is work properly. In this case I got some problems then I disabled the windows firewall and then its properly work. Thank you very very much.