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?
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]
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 otpassword=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]
Re: can't access to MySQLfrom java on Linux RedHat 7
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 otpassword=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]