Input the database name, username, and password. The port should be the same as listed on AWS (it should be the default port, 3306). In the Hostname line, copy and paste your database endpoint from your RDS instance. Do so, and then enter your database information. Once it is installed, the welcome page will prompt you to create a new connection. It is a great tool that allows you to directly interact with your database via SQL query or GUI. Install MySQL Workbench, which you can find here. Make sure that it is listed as publicly accessible (located under Security > Public accesibility, and your database is set up and ready to go.Ĭonnecting MySQL Workbench to your RDS instanceįeel free to use another MySQL connection tool if you have one you're comfortable with, but we will be using MySQL workbench. Make a note of this endpoint, we will reference it later. You will find the endpoint that AWS has created for you under Endpoint & port > Endpoint. Select the instance from the RDS dashboard and the page should look like this: Leave all other settings as their default. This will be used to connect to your database and potentially when issuing queries. Under Database options, specify a Database name. Under Network & Security, ensure Public accessibility is Yes The instance identified will be used only in AWS, and is separate from the name of your database.Īfter setting up the basic database info, you want to ensure the database is publicly accessible, which means that you can access it from anywhere with the correct endpoint, username, and password. Please write down your username and password. Under settings, specify an instance identifier, master username, and master password. In Instance specifications, leave all options alone. There is a plethora of settings involved in configuring a database- when in doubt, leave it alone.įirst, go to the bottom of the page and check the Only enable options eligible for RDS Free Usage Tier- this will ensure that you don't select a database which will consume hundreds of dollars over the course of the semester.įor Engine options, select MySQL and click Next. Next, create a database under Resources > DB Instances > Create database
Log in to your AWS account and then navigate to Services > RDS This is a how-to that goes through the process of setting up a MySQL database through Amazon Web Services (AWS). 3.2 Connecting MySQL Workbench to your RDS instance.
0 kommentar(er)
