Connect DB instance

Connect DB instance

1. Use MobaXterm to connect SSH to the instance via port 22.

• Select Session

2. In the Session settings section,

• Remote host, enter Public IPv4 address of the instance
• Specify username, enter ec2-user
• Check port 22
• Select Advanced SSH settings
• Select Use private key and select keypair of the instance.
• Select OK

3. EC2 instance connection is successful.

4. Use root

sudo su

5. Install mariadb (mysql)

yum install mariadb

6. Check MYSQL installed by

mysql --version

• Connect DB instance

mysql -h mysql–instance1.123456789012.us-east-1.rds.amazonaws.com -P 3306 -u mymasteruser -p

7. Execute command to add data to DB instance

USE usermgt;
CREATE TABLE `usermgt`.`user`
  (
     `id`         INT NOT NULL auto_increment,
     `first_name` VARCHAR(45) NOT NULL,
     `last_name`  VARCHAR(45) NOT NULL,
     `email`      VARCHAR(45) NOT NULL,
     `phone`      VARCHAR(45) NOT NULL,
     `comments`   TEXT NOT NULL,
     `status`     VARCHAR(10) NOT NULL DEFAULT 'active',
     PRIMARY KEY (`id`)
  )
engine = innodb;
INSERT INTO `user`
            (`id`,
             `first_name`,
             `last_name`,
             `email`,
             `phone`,
             `comments`,
             `status`)
VALUES      (NULL,
             'Amanda',
             'Nunes',
             'anunes@ufc.com',
             '012345 678910',
             'I love AWS FCJ',
             'active'),
            (NULL,
             'Alexander',
             'Volkanovski',
             'avolkanovski@ufc.com',
             '012345 678910',
             'I love AWS FCJ',
             'active'),
            (NULL,
             'Khabib',
             'Nurmagomedov',
             'knurmagomedov@ufc.com',
             '012345 678910',
             'I love AWS FCJ',
             'active'),
            (NULL,
             'Kamaru',
             'Usman',
             'kusman@ufc.com',
             '012345 678910',
             'I love AWS FCJ',
             'active'),
            (NULL,
             'Israel',
             'Adesanya',
             'iadesanya@ufc.com',
             '012345 678910',
             'I love AWS FCJ',
             'active'),
            (NULL,
             'Henry',
             'Cejudo',
             'hcejudo@ufc.com',
             '012345 678910',
             'I love AWS FCJ',
             'active'),
            (NULL,
             'Valentina',
             'Shevchenko',
             'vshevchenko@ufc.com',
             '012345 678910',
             'I love AWS FCJ',
             'active'),
            (NULL,
             'Tyron',
             'Woodley',
             'twoodley@ufc.com',
             '012345 678910',
             'I love AWS FCJ',
             'active'),
            (NULL,
             'Rose',
             'Namajunas ',
             'rnamajunas@ufc.com',
             '012345 678910',
             'I love AWS FCJ',
             'active'),
            (NULL,
             'Tony',
             'Ferguson ',
             'tferguson@ufc.com',
             '012345 678910',
             'I love AWS FCJ',
             'active'),
            (NULL,
             'Jorge',
             'Masvidal ',
             'jmasvidal@ufc.com',
             '012345 678910',
             'I love AWS FCJ',
             'active'),
            (NULL,
             'Nate',
             'Diaz ',
             'ndiaz@ufc.com',
             '012345 678910',
             'I love AWS FCJ',
             'active'),
            (NULL,
             'Conor',
             'McGregor ',
             'cmcGregor@ufc.com',
             '012345 678910',
             'I love AWS FCJ',
             'active'),
            (NULL,
             'Cris',
             'Cyborg ',
             'ccyborg@ufc.com',
             '012345 678910',
             'I love AWS FCJ',
             'active'),
            (NULL,
             'Tecia',
             'Torres ',
             'ttorres@ufc.com',
             '012345 678910',
             'I love AWS FCJ',
             'active'),
            (NULL,
             'Ronda',
             'Rousey ',
             'rrousey@ufc.com',
             '012345 678910',
             'I love AWS FCJ',
             'active'),
            (NULL,
             'Holly',
             'Holm ',
             'hholm@ufc.com',
             '012345 678910',
             'I love AWS FCJ',
             'active'),
            (NULL,
             'Joanna',
             'Jedrzejczyk ',
             'jjedrzejczyk@ufc.com',
             '012345 678910',
             'I love AWS FCJ',
             'active');

8. Finish adding data to the DB instance.