commons-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Larner, Ross S" <Ross_S_Lar...@homedepot.com>
Subject RE: [DBCP] mysql authentication
Date Mon, 13 Jun 2005 16:15:43 GMT
Tom,
If I remember correctly, the -p switch is used to supply the password.

Ross 

-----Original Message-----
From: Tom Mathews [mailto:tom-mathews@supanet.com] 
Sent: Monday, June 13, 2005 4:05 AM
To: jakarta commons
Subject: [DBCP] mysql authentication

I'm trying to set up a connection pool to a mysql 5 db using JSP on
Tomcat 5, versions as follows:

mysql-connector-java-3.1.8
jakarta-tomcat-5.0.28
Mysql-devel-5.0.3
Mandrake 10.1 on AMD64



I've a resource set up which includes username and password elements#
...
   <!-- MySQL dB username and password for dB connections  -->
    <parameter>
     <name>username</name>
     <value>myUser</value>
    </parameter>
    <parameter>
     <name>password</name>
     <value>myPassword</value>
    </parameter>
...
but whenever I try and run the pages that use this, I get an error back
saying 'Cannot create PoolableConnectionFactory (Access denied for user
'myUser'@'me.mydomain.com' (using password: NO) '

If I create a new database user with no password, then I can connect
fine, but this is obviously not something that I want to do!

Does anyone know how to make tomcat / mysql/J use a password (JSP rather
than a stand alone java class, which is working absolutely fine).

Thanks
Tom



---------------------------------------------------------------------
To unsubscribe, e-mail: commons-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: commons-user-help@jakarta.apache.org




---------------------------------------------------------------------
To unsubscribe, e-mail: commons-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: commons-user-help@jakarta.apache.org


Mime
View raw message