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
Do you have any firewall which is blocking port 3306 from connecting to the database server?
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