tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Christian Mack <cm...@spcie.de>
Subject RE: SQL Exception (same error) (fwd)
Date Tue, 08 Aug 2000 13:41:00 GMT
Hi Anand

It is not necessary to flush after an GRANT.

But perhaps MySQL is started with -skip-networking as an option.
This will prevent an TCP/IP connection to it.
The mysql client will work, because it uses named pipes when used on
localhost.

Tschau
Christian

> -----Original Message-----
> From: Brian Richards [mailto:ncmusic@pobox.com]
> Sent: Tuesday, August 08, 2000 3:34 PM
> To: tomcat-user@jakarta.apache.org
> Subject: Re: SQL Exception (same error) (fwd)
> 
> 
> Did you flush the permissions?  "mysqladmin reload"
> 
> -Brian
> ----- Original Message -----
> From: <araman@india-today.com>
> To: "Tomcat" <tomcat-user@jakarta.apache.org>
> Sent: Tuesday, August 08, 2000 6:53 AM
> Subject: SQL Exception (same error) (fwd)
> 
> 
> > Hi again
> > After reading all ur mails i tried to the following
> >
> > 1. create a fresh user in the mysql database
> >
> > GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP ON subscriptions.* to
> subs@localhost identified by 'some_pass';
> >
> > 2. create a sample application and test connectivity to the database
> >
> > import java.sql.*;
> >
> > public class trial {
> > Connection conn;
> > Statement stmt;
> >
> > public static void main(String args[]) {
> > trial tr = new trial();
> > String DBURL="jdbc:mysql:localhost///subscriptions";
> > try{
> > Class.forName("org.gjt.mm.mysql.Driver");
> > tr.conn=DriverManager.getConnection(DBURL,"subs","some_pass");
> > tr.stmt=tr.conn.createStatement();
> > System.out.println("In connect");
> > System.out.println(tr.stmt);
> > } catch(Exception ex){
> > System.out.println(ex.toString());
> > }
> > }
> > }
> >
> > 3. On compiling and excuting I still manage to get the 
> following error
> >
> > java.sql.SQLException: Server configuration denies access 
> to data source
> >
> > Why is this coming.. I have gone over the privileges table 
> many times and
> everything seems to be fine..  I am also able to connect to 
> the database
> using the mysql client and the same login and passwd..
> >
> > This thing is totally driving me up the wall if ay one of u 
> could tell me
> why it is happening so..
> >
> > Thanx for ur time
> > Anand Raman
> >
> >
> >
> >
> >
> >
> 

Mime
View raw message