Will It work Properly?

[intruderX]

To access data in a MySql server, with a Swing Application
(Which has been installed on a client machine,)
we need to install MYSQL server in client machines also, don't we?
If some one can confirm this, I'm so much obliged. Because I'm
familiar with web based applications, but not with JFC and other
stand alone applications. If it is, tel me how to do client
installation and how to connect it with server database, and
how to access Data with a Swing application.
My Swing application runs well accesses data, connecting to the MySQL database
when I run it on my local machine(with a server installation of MySQL database).
[when both database and the Application exist on the same machine]
I'm worried whether it will not work properly when I deployed the application
in client machines,having deployed the database on a specific server machine.
Application is just provided,
1- host (IP Address)
2- Database name.
3- Username (root)
4- password.

as : jdbc:mysql://localhost:3306/users_db?user=root&password=intruder";
or with local IP address,
as : jdbc:mysql://192.120.100.85:3306/users_db?user=root&password=intruder";

But not any port when creating JDBC-MySQL connection.(??? Somewhat peculiar to me).

1- should I install MySQL on alll the client machienes also?
2- if it is, what I must do more to link them with the database in the server machine?

Please help me to clarify this matter.

Thanks In Advance!

[r035198x]

You don't need to install MySQL on all the client machines. You'd have to do some replication if you go that route.

Read about how to use Java Web Start to deploy Swing applications.

[intruderX]

Hey Thanks! This an amazing answer! I was not knowing about Java web start and the extension *.jnlp. But You made me learning about that. I think I would be able to use my application on client machines, without installing MySQL on each and every client. Thanks a lot!