> -----Original Message-----
> From: kieran buckley [mailto:[EMAIL PROTECTED]]
> Sent: Friday, August 03, 2001 10:29 AM
> To: [EMAIL PROTECTED]
> Subject: RE: jdbc - tcp/unixsockets
>
>
> Venu...lifesaver!!
> thanks very much,
> kieran
You, welcome..!!!!
venu
>
> >>>>>>>>>>>>>>>>>> Original Message <<<<<<<<<<<<<<<<<<
>
> On 8/3/01, 4:39:49 PM, Venu <[EMAIL PROTECTED]> wrote regarding RE: jdbc -
> tcp/unixsockets:
>
>
> > Hi !
> > > -----Original Message-----
> > > From: kieran buckley [mailto:[EMAIL PROTECTED]]
> > > Sent: Friday, August 03, 2001 5:17 AM
> > > To: [EMAIL PROTECTED]
> > > Subject: jdbc - tcp/unixsockets
> > >
> > >
> > > hi ,
> > > i'm writing a simple java program that i want to access mysql with.
> > > the error i'm getting is :
> > >
> > > "Server configuration denies access to data source"
> > > the code is :
> > > String url = "jdbc:mysql://localhost:3306/mysql";
> > > Connection con;
> > > String query = "SELECT Teacher FROM TimeTable";
> > > Statement stmt;
> > >
> > > try{
> > > Class.forName(
> > > "org.gjt.mm.mysql.Driver").newInstance();
> > > // Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
> > >
> > > }catch(ClassNotFoundException e){
> > > System.err.print("ClassNotFoundException: ");
> > > System.err.println(e.getMessage());
> > > }
> > > catch (Exception E) {
> > > System.err.println("Unable to load driver.");
> > > E.printStackTrace();
> > > }
> > >
> > > try{
> > >
> > > System.out.println("about to ..");
> > > con = DriverManager.getConnection(url,"root",
> > > "");
> > > System.out.println("ok");
> > > stmt = con.createStatement();
> > >
> > >
> > > i can connect via command line no problem to mysql. i downloaded the
> > > mysqlgui form mysql.com and by it will only connect using the
> UNIX socket
> > > ie.not the port number alone (3306).
> > > mysqladmin -version says the connection type is UNIX socket, is a tcp
> > > connection taken for granted or should it say so?
> > > do i have to change some connection parameters to allow connection
> > > through tcp ports - any suggestions very welcome.
> > > thanks in advance,
> > > kieran
> > > mysql version 10.8 Distrib 3.23.22-beta
> > > mm.mysql.jdbc-1.2c
> > > java1.3
> > > linux 7.0
>
>
> > Please check the following link for work around solution, and
> let us know
> > whether it helps you or not.
> >
> http://lists.mysql.com/cgi-ez/ezmlm-cgi?9:mss:11144:200108:enhjbegmebmblme
> ae
> > jok
>
> > Thank you
> > venu
>
> > --
> > For technical support contracts, go to https://order.mysql.com/
> > __ ___ ___ ____ __
> > / |/ /_ __/ __/ __ \/ / Mr. Venu <[EMAIL PROTECTED]>
> > / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer
> > /_/ /_/\_, /___/\___\_\___/ Redwood city, California USA
> > <___/ www.mysql.com
>
---------------------------------------------------------------------
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