- i created two EC2 instances at once, and rename one as MYSQL-ERVER AND THE OTHER AS SQL-CLIENT.

- firstly I did sudo apt update
- secondly sudo apt upgrade to upgrade ubuntu
- then i used sudo apt install mysql-client to install the client
- sudo apt install mysql-server to install the server
- edited inbound rule in the security group using MYSQL/Aurora on port 3306 and connect from anywhere Ipv4 , then save.
- then on terminal of the server sudo mysql then on mysql interface,
- since I cannot have root access from a remote IP i created a user using CREATE USER 'banjo'@'%' IDENTIFIED BY 'password';
- I also modified my configuration file on the server using sudo vi /etc/mysql/mysql.conf.d/mysqld.cnf
- went to my SQL-CLIENT ECS and typed ** mysql -u banjo -h -p
- I entered password and ... yipeeeee.......Successful!


####You can make it