1개 답변
- 최신
- 최다 투표
- 가장 많은 댓글
1
What are node type are you using MySqlDataNode or SqlDataNode ? As you have enabled IAM authentication Granting the IAM role in MYSQL would be useful as IAM authentication is taking precedence over the master user and use the same IAM user for Ec2Resource.
- mysql> CREATE USER RDSConnect IDENTIFIED WITH AWSAuthenticationPlugin AS 'RDS';
- mysql> GRANT ALL ON
%
.* TO RDSConnect@%
; - mysql> select * from mysql.user where user='RDSConnect'\G
Also check GRANT has allowed connection from master user and password from any hosts like % for grant. were you able to the connect from EC2 instance using mysql client ?
some useful links:- https://kumo-knowledge-ui-iad-prod.amazon.com/view/article_12180
답변함 2년 전
관련 콘텐츠
- 질문됨 7년 전
- 질문됨 한 달 전
- 질문됨 3달 전
- AWS 공식업데이트됨 3년 전
Thanks for your comment, I can not open the below link below!