Step 1

Login to AWS using your developer account at the following link:
https://898363003987.signin.aws.amazon.com/console

Step 2

In the top right corner, make sure your region is set to US East (N. Virgina) us-east-1.

Step 3

Go to the EC2 service management console. The easiest way to get there is to type EC2 into the search box that is in the center of the dashboard.

Step 4

Go to the Security Group settings. There is a link directly in the EC2 dashboard and also in the navigation on the left-hand side under the category NETWORK & SECURITY.

Step 5

Click on the security group with a Group Name of launch-wizard-1.

Step 6

In the window that appears in the bottom half of the dashboard, click on the Inbound tab.

Step 7

In the Inbound tab, click Edit.

Step 8

In the popup, near the bottom left, click Add Rule.

Step 9

In the first dropdown on the left (Type), select MYSQL/Aurora.

Step 10

In the Source dropdown, select My IP.

Step 11

In the description box, please describe what device you are currently adding (i.e. mysql for david desktop).

Step 12

In the bottom right corner, select Save.

That's it! If you start xampp and go to localhost/phpmyadmin, you should now be able to connect to the production/staging database server by changing the server you are connected to in a dropdown located in the top left corner.