change mysql local to amazon RDS

[alfredogama]

Hello friends,

I'm trying to config my magento database to AWS (RDS), i changed the host and the new credentials but magento is not possible connect. is it possible use another Mysql than the localhost?

My local.xml config is:

<connection>
<host><![CDATA[rds.cbqapfzhe2c2.us-west-2.rds.amazonaws.com:3306]]></host>
<username><![CDATA[someuser]]></username>
<password><![CDATA[somepassword]]></password>
<dbname><![CDATA[database]]></dbname>
<initStatements><![CDATA[SET NAMES utf8]]></initStatements>
<model><![CDATA[mysql4]]></model>
<type><![CDATA[pdo_mysql]]></type>
<pdoType><![CDATA[]]></pdoType>
<active>1</active>
</connection>

Alfredo

[JLHC]

Do you have any firewall which is blocking port 3306 from connecting to the database server? 

[Stuart M]

Try connecting from your SSH command line using the following command and confirm that works first:

mysql -h rds.cbqapfzhe2c2.us-west-2.rds.amazonaws.com -u someuser -ppassword somedatabase