-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
