![]() ![]() ![]() The Public DNS can just be copied and pasted from the specific AWS instance you want to connect. IP Addresses) set up so that a database connection (for MySQL usually through port 3306) can be made from wherever you are located.Īll that is needed is the Public DNS that is available once you start your Amazon instance and the key pair file (.pem) used for the Amazon instance (the one Amazon tells you not to lose). Make sure you have all the security groups (i.e. If you’re reading this article then I’ll assume that you already know about Amazon EC2 and are familiar with the basics. It’s not terribly difficult to connect to EC2 but it is also not as simple as typing localhost as it requires a few additional steps. I generally use MySQL Workbench when I’m sitting on a Linux-based operating system and TOAD when I’m on Windows. I tend to use either TOAD for MySQL or MySQL Workbench to run and test queries against a MySQL database. In this tutorial I’ll share how to connect to a MySQL database so that one can retrieve the data and do the analysis. I often use Amazon EC2 to store and retrieve data when I need either additional storage or higher computing capacity. ![]()
0 Comments
Leave a Reply. |