mysql on Ec1.txt

Commands used to host MySql Server on AWS EC2 Instance
Step 1: Update the system
sudo apt update

Step 2: Install MySql
sudo apt install mysql-server

Step 3: Check the Status of MySql (Active or Inactive)
sudo systemctl status mysql

Step 4: Login to MySql as a root
sudo mysql

Step 5: Update the password for the MySql Server
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'place-your-password-here';

FLUSH PRIVILEGES;

Step 6: Test the MySql server if it is working by running sample sql queries
CREATE DATABASE mysql_test;

USE mysql_test;

CREATE TABLE table1 (id INT, name VARCHAR(45));

INSERT INTO table1 VALUES(1, 'Virat'), (2, 'Sachin'), (3, 'Dhoni'), (4, 'ABD'), (5,'Ajay');

SELECT * FROM table1;