Re: remote connection with JDBC

[Mark Matthews]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Erwin Adi wrote:
I can connect to MySQL through JDBC with the following URL without any
problem:
jdbc:mysql://localhost:3306/mydatabase
However, when I simulate the above URL as though I'm calling from a remote
machine using the following URL,
jdbc:mysql://192.168.0.10:3306/mydatabase
I got the following exception (the file name is Lookup.java) :
Exception in thread "main" java.sql.SQLException: Communication link
failure: java.io.IOException
       at com.mysql.jdbc.MysqlIO.init(Unknown Source)
       at com.mysql.jdbc.Connection.connectionInit(Unknown Source)
       at com.mysql.jdbc.jdbc2.Connection.connectionInit(Unknown Source)
       at com.mysql.jdbc.Driver.connect(Unknown Source)
       at java.sql.DriverManager.getConnection(DriverManager.java:512)
       at java.sql.DriverManager.getConnection(DriverManager.java:171)
       at Lookup.main(Lookup.java:16)
I would very much appreciate if anybody could tell me how to connect the
database from a remote machine (if possible with which library to import
from). Thank you very much in advance.
What OS is running on the remote machine? It looks like it is 
RedHat-8.0. On RedHat 8.0, if you use RedHat's mysql binaries, remote 
TCP/IP connections won't work. If this is the case, please try one of 
our binaries, and also look at the directions here:

http://www.mysql.com/doc/en/Linux-x86.html

	-Mark

- -- 
MySQL 2003 Users Conference -> http://www.mysql.com/events/uc2003/

For technical support contracts, visit https://order.mysql.com/?ref=mmma

    __  ___     ___ ____  __
   /  |/  /_ __/ __/ __ \/ /  Mark Matthews <[EMAIL PROTECTED]>
  / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer - JDBC/Java
 /_/  /_/\_, /___/\___\_\___/ Flossmoor (Chicago), IL USA
        <___/ www.mysql.com
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.1.90 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
iD8DBQE+deX2tvXNTca6JD8RArUNAJ4vIuve3vU697q3GlwqQRw0/19BfwCfVt9z
OdIEp97O8cLJAEdoOtcoYeM=
=sZDH
-----END PGP SIGNATURE-----
---------------------------------------------------------------------
Before posting, please check:
  http://www.mysql.com/manual.php   (the manual)
  http://lists.mysql.com/           (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php