Access Denied to Amazon RDS MySQL

One Star

Access Denied to Amazon RDS MySQL

Hello,
I'm trying to extract from my company's Salesforce database, and copy the data into an AWS MySQL database.
I am able to connect and pull the schema from the Talend application, and I set a job up with the Account object in my Salesforce Org. From what I can tell, all of the credentials are input correctly.
My AWS security group has an allowed policy for my IP address, but i still get the following errors on the job :
****************
connecting to socket on port 3700
connected
Exception in component tMysqlOutput_1
java.sql.SQLException: Access denied for user '(Username)'@'c-(IPAddress).hsd1.pa.comcast.net' (using password: YES)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1075)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3566)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3498)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:919)
at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:4004)
at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1284)
at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2312)
at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2122)
at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:774)
at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:49)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
disconnected
at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:409)
at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:375)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:289)
at java.sql.DriverManager.getConnection(DriverManager.java:582)
at java.sql.DriverManager.getConnection(DriverManager.java:185)
at sqmigration.sfdcmigration_0_1.SFDCMigration.tSalesforceInput_1Process(SFDCMigration.java:2391)
at sqmigration.sfdcmigration_0_1.SFDCMigration.runJobInTOS(SFDCMigration.java:4799)
at sqmigration.sfdcmigration_0_1.SFDCMigration.main(SFDCMigration.java:4667)
Job SFDCMigration ended at 16:17 16/09/2012.
************

Any idea of what this could mean? Is there something else in Talend I might need to configure to copy the data into the database tables?
Any help is appreciated. If you need more details, I'm happy to provide, I'm just not sure what could help.
Thanks,
C
One Star kcd
One Star

Re: Access Denied to Amazon RDS MySQL

This is a mysql user credential problem, the AWS security group must be correct as you are connecting through to mysql. Also check if the user is restricted to a host
mysql -uroot -p
SELECT user,host FROM mysql.user;
SHOW GRANTS FOR '(Username)'@'%'
SHOW GRANTS FOR '(Username)'
One Star

Re: Access Denied to Amazon RDS MySQL

Hi, Did you get a solution for this because i'm having the same problem and would like to know how you resolved it.
thanks