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.
Easy configurable AMI with pre-installed MySQL and phpMyAdmin
INSTALLATION VIA AWS MARKETPLACE
Kindly click on the below link to install the server via AWS Marketplace:
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
Step 1. Connect to SSH
In a terminal window, use the ssh command to connect to the instance. You specify the user name for your instance, and the public DNS name or IPv6 address for your instance, the path and file name of the private key (.pem).
ssh ubuntu@publicIP -i [Path of key pair file]
If it shows access denied message run the following command , then run the above command again to connect via ssh.
chmod 400 [Path of key pair file]
Step 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
In EC2 console, In the navigation pane, select Instances. The Instances page opens.
Click the instance that you want the ID for. The instance details page opens and displays the ID and IP address.
Step 3. Access PhpMyAdmin
phpMyAdmin is a PHP-based application intended to handle the administration of MySQL over the Web.
To verify the installation, follow the below instructions
In the address bar of the browser, type http://<your-ip-address>/phpmyadmin
You will see the phpMyAdmin default page (see screenshot below)
Default Login ID-root and password - <AWS Instance ID>