1
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.
1I have done my best to format your question and clean things up a bit. Please edit the question to more clearly state the problem (don't just give a screenshot), and what you've tried to resolve it. – Tim – 2019-09-08T22:53:02.247