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.
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.
Now select the MySQL ODBC Driver from the list
Press Finish and you will need to enter the MYSQL server credential.
On the TCP/IP server, you can find this details on the Amazon RDS DB Instance. It something similar to this:
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.