MySQL Forums
Forum List  »  MySQL Administrator

remotely connect to database
Posted by: pep pep
Date: February 17, 2010 12:40AM

hi,
i have designed a frame using java , frame access the mysql database on my machine(192.168.1.100).but when i run this code on remote machine(a machine on my LAN(192.168.1.5)) i got error:
java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
i have set "GRANT ALL ON student.* to 'root'@'192.168.1.100' IDENTIFIED BY 'pep';"
at 192.168.1.100---i have installed connector\j
piece of code
==========================================================
Class.forName("com.mysql.jdbc.Driver").newInstance();
con = DriverManager.getConnection("jdbc:mysql://192.168.1.100:3306/student", "root", "pep");
st = con.createStatement();
===========================================================
is this necessary to install connector on every client machine to access mysql datbase remotely?
if yes.then what is the way to access mysql database remotely(or on web) without making any configuration?
thanks in advance :)

Options: ReplyQuote


Subject
Written By
Posted
remotely connect to database
February 17, 2010 12:40AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.