Connection Problems

[John Cartner]

hi, i hope you can help us, we wrote a java applet which have to communicate with a mysql database. If the applet runs on the same computer where the mysql server is running, the programm is able to connect with the server, otherwise not. and this is not a driver problem (i even changed the driver with no effect). the diver is initated.

the code:

protected Connection getConnection ( String host, String database,String user,String pass )
throws Exception {

String url = "";
try {
url = "jdbc:mysql://" + host + "/" + database;
Connection con = DriverManager.getConnection(url,user,pass);
strstatus=strstatus.concat("Connection established (2)");
System.out.println("Connection established to " + url + "...");

return con;
} catch ( java.sql.SQLException e ) {
strstatus=strstatus.concat("Connection couldn't be established (2)");
System.out.println("Connection couldn't be established to " + url);
throw ( e );
}
}

The applet should run on this server:
Operating system Linux
Service Status Click to View
Kernel version 2.4.26-ow3
Machine Type i686
Apache version 1.3.32 (Unix)
PERL version 5.8.0
Path to PERL /usr/bin/perl
Path to sendmail /usr/sbin/sendmail
Installed Perl Modules Click to View
PHP version 4.3.9
MySQL version 4.0.20-standard
cPanel Build 9.9.8-STABLE 6

But I also wasn't able to get a connection to the database when I tried another mysql server (winXP pro). The same problem. Running the applet on the server itself I get a connection, but not from another computer.