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]>