Access Denied to Amazon RDS MySQL

Anonymous — Sat, 16 Nov 2024 12:11:35 GMT

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

Re: Access Denied to Amazon RDS MySQL

Anonymous — Wed, 03 Oct 2012 02:07:59 GMT

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)'

Re: Access Denied to Amazon RDS MySQL

_AnonymousUser — Fri, 18 Jan 2013 01:06:30 GMT

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

topic Re: Access Denied to Amazon RDS MySQL in Talend Studio

Access Denied to Amazon RDS MySQL

Re: Access Denied to Amazon RDS MySQL

Re: Access Denied to Amazon RDS MySQL