Skip to content

Latest commit

 

History

History
95 lines (76 loc) · 4.55 KB

README.md

File metadata and controls

95 lines (76 loc) · 4.55 KB
Raw

Getting started with Cloud9 on Amazon Web Services (AWS)

  • Sign up here
  • Select Personal for account type
  • AWS requires a valid phone number for verification
  • Your credit/debit card will also be charged $1 for verification purposes, the amount will be refunded after being processed
    • See here for more information about the charge
  • Select the Free Basic Plan
    • This plan is free for 12 months with certain usage restrictions, set a date in your calender to cancel your plan if you don't want to be charged after one year
    • See more details about the free plan here
  • Sign in to the AWS console with your new account
    • It can take up to 24 hours for your account to be verified, check your email for notification
  • Once logged in you'll be in the AWS dashboard
  • Click the Cloud9 link, otherwise type cloud9 into the AWS services search bar and select Cloud9 A Cloud IDE for Writing, Running, and Debugging Code
  • If your account has been verified then you will be able to select Create environment
  • Name it wdb and click Next step
  • Leave default settings and click Next step again
  • Scroll down and click Create environment

Check node and npm

  • Once inside your c9 environment (previously called a workspace) type node -v into the terminal, you should see v6.11.4 or greater (current version being used at the time of the making of this tutorial)
  • Now type npm -v, you should see 3.10.10 (or higher)

MongoDB Instructions

(skip this section and see below for MySQL Instructions if coming from MySQL course)

  • Enter touch mongodb-org-3.6.repo into the terminal
  • Now open the mongodb-org-3.6.repo file in your code editor (select it from the left-hand file menu) and paste the following into it then save the file:
[mongodb-org-3.6]
name=MongoDB Repository
baseurl=https://repo.mongodb.org/yum/amazon/2013.03/mongodb-org/3.6/x86_64/
gpgcheck=1
enabled=1
gpgkey=https://www.mongodb.org/static/pgp/server-3.6.asc
  • Now run the following in your terminal:
sudo mv mongodb-org-3.6.repo /etc/yum.repos.d
sudo yum install -y mongodb-org
  • Close the mongodb-org-3.6.repo file and press Close tab when prompted
  • Change directories back into root ~ by entering cd into the terminal then enter the following commands:
mkdir data
echo 'mongod --dbpath=data --nojournal' > mongod
chmod a+x mongod
  • Now test mongod with ./mongod
  • Remember, you must first enter cd to change directories into root ~ before running ./mongod
  • Don't forget to shut down ./mongod with ctrl + c each time you're done working

That's it! You're all set :)

MySQL Instructions

  • Enter sudo service mysqld start into the terminal

  • Enter /usr/libexec/mysql55/mysql_secure_installation and follow the steps for setting up your root account and password.

    • When prompted for the initial password press enter
      • If this step fails then enter /usr/libexec/mysql55/mysqladmin -u root password 'new-password'
        • Be sure to replace 'new-password' with your password
      • Now start the secure installation over again with /usr/libexec/mysql55/mysql_secure_installation and enter the password you just created
    • Disable remote root access and remove test database and anonymous user during the secure installation steps

  • Start the mysql shell with root user access by entering: mysql -uroot -p and typing in your root password when prompted

    • Password will be hidden while typing it in, press enter when done typing and the shell will start if the password is correct

  • Once inside of the shell test it out with the following commands:

CREATE database test;
USE test;
CREATE TABLE pet (name VARCHAR(20), owner VARCHAR(20), species VARCHAR(20));
INSERT INTO pet (name, owner, species) VALUES('Loki', 'Ian', 'Dog');                                                                                                                                                    
SELECT * FROM pet;

Result:

+------+-------+---------+
| name | owner | species |
+------+-------+---------+
| Loki | Ian   | Dog     |
+------+-------+---------+
  • When you're done working you can exit the shell by typing exit or pressing ctrl + c
  • Stop the mysql daemon with sudo service mysqld stop