The example of the JDBC realm for MySQL that comes with Tomcat is incorrect. The
correct method is below.
<Realm
className="org.apache.catalina.realm.JDBCRealm"
debug="99"
driverName="org.gjt.mm.mysql.Driver"
connectionURL="jdbc:mysql://host/db"
connectionName="username" connectionPassword="password"
userTable="userTable"
userNameCol="userNameCol"
userCredCol="userCredCol"
userRoleTable="userRoleTable"
roleNameCol="roleNameCol" />
Note that login name and password are separate parameters and are not included in the
connectionURL.
----- Original Message -----
From: "amol" <[EMAIL PROTECTED]>
To: "Tomcat Users List" <[EMAIL PROTECTED]>
Sent: Tuesday, January 15, 2002 9:05 AM
Subject: Re: can't access to MySQLfrom java on Linux RedHat 7
> try the string without password it may work
>
> ----- Original Message -----
> From: "Sajida Kalsoom" <[EMAIL PROTECTED]>
> To: "Tomcat Users List" <[EMAIL PROTECTED]>
> Sent: Tuesday, January 15, 2002 3:00 PM
> Subject: Re: can't access to MySQLfrom java on Linux RedHat 7
>
>
> > have you tried using IPAddress instead of localhost in connection string
> ??
> > and remember to add this IPAddress of your linux box in mysql privileges
> > table .
> > ----- Original Message -----
> > From: "Galbayar" <[EMAIL PROTECTED]>
> > To: "Tomcat Users List" <[EMAIL PROTECTED]>
> > Sent: Tuesday, January 15, 2002 2:22 PM
> > Subject: Re: can't access to MySQLfrom java on Linux RedHat 7
> >
> >
> > > My Connection is
> > >
> >
> mysql=DriverManager.getConnection("jdbc:mysql://localhost:3306/mysql?user=ro
> > > ot&password=password");
> > > and correctly running on Win2000 but can't working on Linux
> > >
> > > ----- Original Message -----
> > > From: "Sajida Kalsoom" <[EMAIL PROTECTED]>
> > > To: "Tomcat Users List" <[EMAIL PROTECTED]>
> > > Sent: Tuesday, January 15, 2002 17:17
> > > Subject: Re: can't access to MySQLfrom java on Linux RedHat 7
> > >
> > >
> > > > add the host name/ipaddress in mysql database named as mysql .
> > > > ----- Original Message -----
> > > > From: "Galbayar" <[EMAIL PROTECTED]>
> > > > To: "Tomcat Users List" <[EMAIL PROTECTED]>
> > > > Sent: Tuesday, January 15, 2002 2:12 PM
> > > > Subject: can't access to MySQLfrom java on Linux RedHat 7
> > > >
> > > >
> > > > Hello all?
> > > > I'm installed JDK,MySQL,Tomcat on Linux RedHat 7 and all services
> > running
> > > > ok. If i connect to the MySQL from java(use MySQL MM driver) have
> Server
> > > > configuration denied access error.
> > > > How to solve this problem?
> > > >
> > > >
> > > >
> > > > --
> > > > To unsubscribe: <mailto:[EMAIL PROTECTED]>
> > > > For additional commands: <mailto:[EMAIL PROTECTED]>
> > > > Troubles with the list: <mailto:[EMAIL PROTECTED]>
> > > >
> > > >
> > >
> > >
> > > --
> > > To unsubscribe: <mailto:[EMAIL PROTECTED]>
> > > For additional commands: <mailto:[EMAIL PROTECTED]>
> > > Troubles with the list: <mailto:[EMAIL PROTECTED]>
> > >
> >
> >
> > --
> > To unsubscribe: <mailto:[EMAIL PROTECTED]>
> > For additional commands: <mailto:[EMAIL PROTECTED]>
> > Troubles with the list: <mailto:[EMAIL PROTECTED]>
> >
> >
>
> --
> To unsubscribe: <mailto:[EMAIL PROTECTED]>
> For additional commands: <mailto:[EMAIL PROTECTED]>
> Troubles with the list: <mailto:[EMAIL PROTECTED]>
>
>
--
To unsubscribe: <mailto:[EMAIL PROTECTED]>
For additional commands: <mailto:[EMAIL PROTECTED]>
Troubles with the list: <mailto:[EMAIL PROTECTED]>
