cancel
Showing results for 
Search instead for 
Did you mean: 

change mysql local to amazon RDS

   Did you know you can see the translated content as per your choice?

Translation is in progress. Please check again after few minutes.

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 2

Re: change mysql local to amazon RDS

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

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
--
Problem solved? Click Accept as Solution!