Thread: Mysql url pointer to server instead of localhost

I current have an app which runs on a server and connector to the database (using localhost, JDBC and Mysql driver)

I need to run a class on a separate server that will populate a table with all the file on the server
both computers are networked and iv tried the following -

//using IP address
 conn = DriverManager.getConnection(jdbc:mysql://192.1.1.1/" + database, 
user, password);
 
//using 2nd IP address (2nd network card)
 conn = DriverManager.getConnection(jdbc:mysql://10.10.10.1/" + database, 
user, password);
 
//using Host name of the server where the database lives
 conn = DriverManager.getConnection(jdbc:mysql://server/" + database, 
user, password);

Any more ideas. otherwise im going to have to ssh into each server using Jsch (ext lib)
and run a command to get all the files, store them into an array, return it, and then format it and store it to the database

Thanks for your help
kurt

Yeah iv tried that with each one. Is there no way of doing this then? Maybe a perl script to do this would be an easier way.

Thanks for your reply.
Kurt

Can the servers even talk to each other?

As in can you ping one server from the other?

Also, does the MySQL server listen on external IP's or just on 127.0.0.1?


// Json