Usage Instructions:

Connect to SSH

Login using 'ubuntu' user and ssh public key authentication

Usage Instructions: To connect to your instance, you will need to use SSH over port 22. You can use the standard AWS method of connecting to an instance as described here: https://docs.thinkwithwp.com/AWSEC2/latest/UserGuide/AccessingInstances.html 

start MySQL Service: sudo systemctl start mysql

stop MySQL Service:sudo systemctl stop mysql

restart MySQL Service: sudo systemctl restart mysql

To get status of MySQL Service: sudo systemctl status mysql

Default ports: MySQL Port : 3306 this is by default not allowed on cloud firewall for security. Please allow SSH port 22 and MySQL port 3306 to limited IPs for access.

MySQL default temporary password and first login password:

Step 1: Enter the command mysql -u root -p;

Step 2: Enter the password (the default password is your ec2 instance_id,For example if Instance ID is 'i-0636e885e3e7117ba', then MySQL Root password will be 'i-0636e885e3e7117ba')

Step 3: alter user 'root'@'%' identified by 'your new password'; Refer document - https://dev.mysql.com/doc/refman/5.7/en/alter-user.html 

Step 4: FLUSH PRIVILEGES;

Mysql default configuration file path :/etc/mysql/mysql.conf.d/mysqld.cnf

Mysql default datadir path:/var/lib/mysql

Mysql default log file:/var/log/mysql/error.log

Using AWS CLI:aws --help https://docs.thinkwithwp.com/cli/latest/userguide/cli-chap-welcome.html