Connecting to mysql server remotely

hi, I m using an applet as a client to interact to a database which is present on a faraway machine(remote access) and i want to establish a connection via internet to the server(where MySQL is running).Now since i m using J/coonector for MySQL 4.1 database so can any one tell me that wheather J/connector files will be needed on the client side(i.e on the web directory) and if yes what will be the url,.getconnection() parameters for accessing the database.

i will be glad if someone can illustrate with an example.

Cheers

[544 byte] By [puneetbaturaa] at [2007-10-2 8:28:37]
# 1

You may check this tip:

How to connect MySql Server using JDBC

http://www.java-tips.org/content/view/808/29/

The problem is that, you can not connect to a remote server from an applet. The server should be on the same sevrer or you may need to play/search with java-security to allow your applet connect to remote server or as discussed in the following thread you can use a servlet (placed to the same web server the applet exist):

http://forum.java.sun.com/thread.jspa?threadID=262637&messageID=990629

Good luck.

casperla at 2007-7-16 22:29:14 > top of Java-index,Database Connectivity,Java Database Connectivity (JDBC)...
# 2
Thanks!
puneetbaturaa at 2007-7-16 22:29:14 > top of Java-index,Database Connectivity,Java Database Connectivity (JDBC)...