wood burning stoves 2.0*
The moose likes JDBC and the fly likes How would I connect mysql database in lan using jdbc? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "How would I connect mysql database in lan using jdbc?" Watch "How would I connect mysql database in lan using jdbc?" New topic
Author

How would I connect mysql database in lan using jdbc?

arun singhal
Ranch Hand

Joined: Oct 25, 2009
Posts: 41
I know that how to connect mysql database in my computer..
But I want to access data from different computer in lan...
What are requirement for this???
Please give me solution for this..
Sebastian Janisch
Ranch Hand

Joined: Feb 23, 2009
Posts: 1183
Instead of connecting to localhost and the corresponding port connect to the network IP of the sql server and the corresponding port.


JDBCSupport - An easy to use, light-weight JDBC framework -
Peter Johnson
author
Bartender

Joined: May 14, 2008
Posts: 5812
    
    7

And you also have to grant your MySQL user accounts the rights to log into the database from remote systems.


JBoss In Action
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: How would I connect mysql database in lan using jdbc?
 
Similar Threads
JDBC and MySQL
JTable question
Login on lan Network?
move tables from one computer to another?
JDBC