MySQL with PHPMYADMIN Package by IOanyT Innovations - Ubuntu20.04

OVERVIEW

MySQL is an open-source relational database management system (RDBMS). A relational database organizes data into one or more data tables in which data may be related to each other; these relations help structure the data. SQL is a language programmers use to create, modify and extract data from the relational database, as well as control user access to the database. In addition to relational databases and SQL, an RDBMS like MySQL works with an operating system to implement a relational database in a computer's storage system, manages users, allows for network access and facilitates testing database integrity and creation of backups.

GOALS

1. One-click launch

2. Easy configurable AMI with pre-installed MySQL and phpMyAdmin

INSTALLATION VIA AWS MARKETPLACE

Kindly click on the link to install the server via AWS Marketplace.

GET STARTED

MySQL has stand-alone clients that allow users to interact directly with a MySQL database using SQL, but more often, MySQL is used with other programs to implement applications that need relational database capability

Option 1. Connect Via SSH:

1. Open the Amazon EC2 console at https://console.aws.amazon.com/ec2/.

2. Choose the Region.

3. In the navigation pane, choose Instances.

4. Select the instance and choose Connect.

5. Choose SSH Client

6. Copy the SSH command and paste it into the terminal.

ssh ubuntu@EC2-publicIP -i [EC2 key pair]

If it shows an access denied message run the following command, then run the above command again to connect via ssh.

chmod 400 [EC2 key pair]

Once launched in the Amazon EC2 Service, please connect to the instance via an SSH client using the ec2-user with the key pair associated at launch. Once connected as the ec2-user user, you will be able to sudo to the root user.

Option 2. Access AWS Instance ID:

For an EC2 instance (either a standalone instance or a part of a stack), or a database instance, you can find the ID in a few steps below

1. In the EC2 console, In the navigation panel, select Instances. The Instances page opens.

2. Click to choose the instance. The instance details page opens and displays the instance ID and Public IPv4 Address.

Step 3. Access PhpMyAdmin Console:

phpMyAdmin is a PHP-based application intended to handle the administration of MySQL over the Web.

To verify the installation, follow the below instructions

1. Open browser

2. In the address bar of the browser, type http://<Public IPv4 Address>/phpmyadmin

3. You will see the phpMyAdmin default page (see screenshot below)

4. Default Login ID - root and password - <Instance ID>

Then will you see the phpMyAdmin console:

Here is how you can use MySQL with PHPMYADMIN Package by IOanyT Innovations - Ubuntu20.04 for easy and hassle-free.

To monitor and assess application functions:-

a. Navigate to your Amazon EC2 console and verify that you're in the correct region.

b. Choose Instances and select your launched instance.

c. Select the server to display your metadata page and choose the Status checks tab at the bottom of the page to review if your status checks passed or failed.

For information about how to use the application, please visit:

https://www.tutorialspoint.com/phpmyadmin/index.htm

For detailed information about managing and requesting increased service please visit: https://docs.aws.amazon.com/general/latest/gr/aws_service_limits.html