- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Re: change mysql local to amazon RDS
Do you have any firewall which is blocking port 3306 from connecting to the database server?
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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!