\nRDS Dashboard\n<\/p>\n
\nIf necessary select your region\n<\/p>\n
\nInstances > Launch DB Instance\n<\/p>\n
\nGo through and select your desired set up.\n<\/p>\n
\nDatabase Options > Database name: Give the name for your database (if you don't you'll need to add a database later to your instance using a MySQL tool of some sort\n<\/p>\n
\nRDS Dashboard > Instances . Use the arrow to open up your instance info once its running\n<\/p>\n
\nConnecting to your Aurora database\n<\/p>\n
\nIf you set your RDS as publicly accessible then you should be able to use these to connect using a standard MySQL tool.\n<\/p>\n
\nHostName\/Ip Address: The 'Cluster Endpoint' with the ":3306" port number removed from the end\n<\/p>\n
\nPort: The port number that was on the end of the 'Cluster Endpoint'\n<\/p>\n
\nUsername and password: as you set when creating the master user.\n<\/p>\n
\nIf you didn't specify a database name when setting the RDS up you'll need to add your database before then adding your own tables etc to it. By default the Aurora RDS will have a database called "mysql" in it with various tables it uses.\n<\/p>\n
\nRDS Dashboard > Instances . Use the arrow to open up your instance info once its running > Details tab on left > Security Groups: You will have the one created or selected when setting up the RDS. Click on it to go edit it etc.\n<\/p>\n
\nIn our test the default security group had already got a default inbound rule for our PC that was setting up the RDS to be allowed to connect (our desktop MySQL editor tool was able to no problem), but would not allow any other outside IP addresses to connect (when our web server tried it got a connection timeout). To do this all that's needed is to add a new inbound rule for the new IP address. If you get problems you are able to add an inbound rule that allows a connection from anywhere (any port and IP address) which can allow you to prove a connection can be made before then locking it down to a single port and IP address (in our case we discovered our web server was connecting from a different IP (address to the one we'd assumed, somethign we had to work out externally as RDS doesn't appear to log incoming connection IP's).)\n<\/p>\n
\n \n<\/p>\n
\n <\/p>\n","protected":false},"excerpt":{"rendered":"
Create the new Aurora RDS Instance RDS Dashboard If necessary select your region Instances > Launch DB Instance Go through and select your desired set up. Database Options > Database name: Give the name for your database (if you don't you'll need to add a database later to your instance using a MySQL tool of […]<\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[142],"tags":[],"class_list":["post-1672","post","type-post","status-publish","format-standard","hentry","category-aurora"],"_links":{"self":[{"href":"https:\/\/ibex.tech\/cloud\/wp-json\/wp\/v2\/posts\/1672","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ibex.tech\/cloud\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ibex.tech\/cloud\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ibex.tech\/cloud\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/ibex.tech\/cloud\/wp-json\/wp\/v2\/comments?post=1672"}],"version-history":[{"count":10,"href":"https:\/\/ibex.tech\/cloud\/wp-json\/wp\/v2\/posts\/1672\/revisions"}],"predecessor-version":[{"id":1700,"href":"https:\/\/ibex.tech\/cloud\/wp-json\/wp\/v2\/posts\/1672\/revisions\/1700"}],"wp:attachment":[{"href":"https:\/\/ibex.tech\/cloud\/wp-json\/wp\/v2\/media?parent=1672"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ibex.tech\/cloud\/wp-json\/wp\/v2\/categories?post=1672"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ibex.tech\/cloud\/wp-json\/wp\/v2\/tags?post=1672"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}