To verify that the data was inserted into the table, you can install MySQL on the Amazon EC2 instance, connect to the DB instance, and query the table. To make sure that your DB instance is as secure as possible, verify that sources outside of the VPC can't connect to your DB instance. If you have an EC2 instance running and you have root access to this EC2 instance, then you can install MongoDB with authentication on EC2 AMI Linux in eight easy steps.
This is an guide on how to set up a AWS EC2 free tier with GUI. The EC2 instance will be able to connect via Remote Desktop Protocol (RDP) or SSH.
You need to create a AWS account: https://portal.aws.amazon.com/billing/signup. You may need to provide your credit card information during the signup process.
Sign in to your AWS Account and go to the AWS EC2 Console: https://aws.amazon.com/console/
xrdp is an open-source Remote Desktop Protocol server: http://xrdp.org
xrdp provides a graphical login to remote machines using RDP (Microsoft Remote Desktop Protocol)
Install the packages:
Set a password for your accout
You need to also set up a password for the ubuntu. This is for your later use in RDP as RDP only allows you to login an password-protected account.
Connect to EC2 via remote desktop
For mac user, you need to download the Microsoft Remote Desktop. If you are using Windows, you should already have the Remote Desktop application preinstalled.
Launch the app and click Add PC:
Set the PC name (i.e. the DNS name of your machine):
Login with user
ubuntu and the password you set in the previous step.
1. Install additional IBus input method
If you want to type Japanese, Chinese, etc. you may need to install an input method. For cangjie, you can install Cangjians via the terminal:
2. Install Midori browser from
Midori Browser is a browser web light, fast, secure, free software & open source
Download .deb file: https://astian.org/en/midori-browser/download/ or using
After that, install the
deb package using
You may see the
dependency problems like the following:
In this case, update the packages and reinstall midori:
3. Set up a
swapfile for better performance
After that, reboot the machine.
4. Use EC2 as a VPN server
Create a new security group allows all TCP and UDP inbound connections and add this security group to the EC2 instance:
Install openvpn scripts
This repo contains scripts for VPN server set up and profile management. Install it into your EC2:
Download the script:
Aws Ec2 Ubuntu Username
openvpn-install.sh exectable in your EC2:
Add a new profile by running
Use another Terminal to download the
.ovpn file. Assuming that the machine name is
ec2-0-1-2-3.ap-northeast-1.compute.amazonaws.com and the generated
.ovpn file is place under
Connect to the VPN
Pritunl Client is a easy-to-use OpenVPN client. Downlaod and install it.
Launch the client and click Import Profile:
After that, click the burger menu of the profile and Connect.
Mongodb On Aws
As Ubuntu cloud images are uploaded and registered on the Amazon EC2 cloud, they are referred to as AMI (Amazon Machine Images). Each AMI is a machine template from which you can instantiate new servers. Each AMI has its own unique ID. In order to launch an instance on the EC2 cloud, you first need to locate its ID. This page helps you quickly locate an AMI ID. Here’s how to use it
Aws Ec2 Ubuntu
Type a few characters in the search box signifying what you’re searching for. For example if you would like to find out the AMI-ID for the latest release of “Precise” Pangolin to run on a “64″ bit “ebs” instance in the “us-east” region, you would search for “pre 64 us-east ebs” or a subset thereof. As soon as you start typing into the search box, the list zooms-in on the entries that match your criteria.
You may search based on any of the column headers belowHere’s how to start an instance using the AMI ID you just found
1- Locate the AMI-ID by searching the table belowNote:
2- Assuming your ec2 environment is setup, run an instance by “ec2-run-instances ami-xxxxx -O AWS_ACCESS_KEY -W AWS_SECRET_KEY”
OR click the ami ID, which will direct you to the AWS console
Aws Ec2 Ubuntu Default Password
Versions ending in EOL are end-of-life and are provided for reference only