mySQL over the LAN

Hello everyone,
I am new to mySQL so was wondering whether anyone could
give me some suggestion of how to connect to mySQL server running in
fedora core 4 over the LAN preferably in java please.


Thanking you all in advance,
Mithil

Mithil wrote:

> Hello everyone,
> I am new to mySQL so was wondering whether anyone could
> give me some suggestion of how to connect to mySQL server running in
> fedora core 4 over the LAN preferably in java please.

If you don't know how to do anything with java and mysql on the same box,
http://www.developer.com/java/data/article.php/3417381
This might help.

On the otherhand, if you are wondering how to make things work when the java
application and the mySQL server are on different machines, look for your
connection string in your java code. It'll look similar to the following...
jdbc:mysql://localhost:3306/your_database
you'll want to change it to something like this
jdbc:mysql://replace_with_name_of_mySQL_server:3306/your_database

Make sure the port (3306) is open in the mySQL server's firewall and not blocked
your java machine as well.

FedoreCore 4 is EOL'ed, you might consider upgrading to something with all the
security updates.

--
Walter