Problem explanation: Not able to connect to RDS-MYSQL instance from another EC2 instance. The other instance is an Amazon-Unix.
listed below are the things tried.
- Checked the security group [allowed all].
- Was trying to install MYSQL monitor.It wasn't successful.
- Installed PHP, httpd successfully.
- Updated my connect.php with the username password, dbname and with the endpoint details already.
- Error message "mysql_native_passwordConnection closed by foreign host".