cancel
Showing results for 
Search instead for 
Did you mean: 

change mysql local to amazon RDS

change mysql local to amazon RDS

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

2 REPLIES

Re: change mysql local to amazon RDS

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

James Lee | Moderator • Magento Master
See My Recommended Magento Hosting & Security Tips

Re: change mysql local to amazon RDS

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