How to create MySQL ODBC Connection to Amazon RDS Database

January 16, 2015 | By | Reply More

I am currently learning and testing some Amazon Web Service (AWS) for my company needs. So in the next post, I will write more how to’s for Amazon Web Service. Here I want to show you how to create MySQL ODBC Connection to Amazon RDS. I am not going to show you how to create new instance for Amazon RDS (will do it later), so this tutorial only applicable if you have already running a MySQL database on Amazon RDS.

Steps to create MySQL ODBC Connection on Windows 7

First we need to install MySQL ODBC Connector. You can download this connector from this link. Once installed, we can start to create new ODBC connection.

mysql odbc connection for amazon rds

Go to Control Panel and double click Administrative Tools. Next Double click Data Sources (ODBC). On the following window, click Add to add to create new Data Source.

mysql odbc connection for amazon rds 2

Now select the MySQL ODBC Driver from the list

mysql odbc connection for amazon rds 3

Press Finish and you will need to enter the MYSQL server credential.

mysql odbc configuration

On the TCP/IP server, you can find this details on the Amazon RDS DB Instance. It something similar to this:

mysql odbc endpoint

The endpoint details above is the TCP/IP address we need. Copy that to the ODBC Data Source configuration window. Make sure you already authorized the connection for selected users (its not covered on this tutorial). Press OK and now you should see your new Data Source listed.

amazonrds odbc connection

Tags: , , , , , ,

Category: Amazon AWS, Windows

Leave a Reply