How to connect CDBConnection with AWS RDS Auth Token

Yii 1.1 Installation and Setup
1

Hi,

My server is in AWS EC2, connected to RDS using Auth Token instead of a password string.

How do I connect CDBConnection to RDS using Auth Token?

2

Can you explain what RDS is and may be further details for us who haven’t used it.
And then may be one can provide a pointer or some details

3

RDS is the SQL database in Amazon AWS

1 Like
4

so anyone?

5

Just dig a little bit dig, it seems RDS is actually mysql or mysql-like. So you connect just like any MYSQL server. See the link below for more details

so something like

$serverName = "aws-test-db.hizibizi.us-west-2.rds.amazonaws.com";  //Your instance here
$username = "<USERNAME>";  
$password = "<PASSWORD>"; 
$dbName='<DATABASE>'; 
$dsn = "mysql:host={$serverName};port:3306;dbname={$dbName}";
$connection = new CDbConnection($dsn, $username, $password);
//... do some other stuffs

You can add in the config once everything works to use the db component
Let me know if that works