First what I have done so far
In AWS
PuTTY
I am able to connect to MySQL (5.7) using PuTTY
Created new user:
create user 'admin'@'localhost' identified by 'xxxxxxx';
Granted all the permission for DB:
grant all privileges ON db.* to 'admin'@'localhost';
I am able to login using new user admin and new pass
mysql -u admin -p
Changed
/etc/my.cnf
; addedbind-address=0.0.0.0
(tried with and without):
MySQL Workbench
Tried SSH hostname:
- a. x.x.x.x:22
- b. x.x.x.x
- c. DNS endpoint :22
- d. DNS endpoint
- Tried SSH Username:
- a. ec2-user (as suggested by AWS)
- b. ubuntu
- MySQL host name:
Please resolve the issue.