MySQL JDBC error ("Using Password: NO")

[Former Member]

I am running MII 12.0 and trying to set up a JDBC connection in MII to a MySQL database.  I use the right URL, put in a user and a password, but when I enable the connection the error I get back is that access is denied "using password:  NO".  I've retyped the password to make sure I had put it in there but the error persists, how do I get it to use the password?

(The same driver and connection parameters works as a connection pool in NW.)

[jcgood25]

If you already have a connection established in NW, then instead of an IDBC connection, you can configure a Datasource data server in MII to share this connection.

Out of curiosity, if you configure the user name to be foo@goo.com does it echo a similar error message to the admin user?  Is the problem with the construct of the user name and not the password?  Assuming your pwd is not actually 'NO', does putting in a completely bogus password make any difference in the error message?

[Former Member]

I've done that and it gives the same error with the other usernames and regardless of the password it always gives the same error.

[jcgood25]

Sorry - I didn't realize you were on 12.0, and using a Datasource connection in MII was not introduced until MII version 12.1.

[Former Member]

To give the exact error:

java.sql.SQLException: Access denied for user 'admin'@XXX.com' (using password: NO)