SHORT: I want to access my RDS MySQL from my EC2 instance. The EC2 has an associated Elastic IP address. I associated an Elastic IP address so the EC2 has a static IP. I can create a MYSQL user my_user@orig_EC2_IP and access the RDS. However, I cannot connect when I create a user with the […]
- Tags add Security inbound rule, adding MySQL/Aurora access to EC2 IP Address. Create a MySQL user: grant usage on *.* to myuser@'' identified by 'password'; grant, but this will stop working if the instance is restarted and changes IP address. LONGER: The following works: Do NOT associate Elastic IP w, creating a MySQL user @"elastic IP", I cannot connect when I create a user with the elastic IP: my_user@ELASTIC_IP. The instance seems to send along the original IP, I want to associate an Elastic IP to the EC2 so it has a static IP address. Associate an Elastic IP address to the EC2. Drop the myuser@'EC, not the elastic one., not the elastic one. I'd just use the my_user@orig_EC2_IP user, opening a port to the Elastic IP, SHORT: I want to access my RDS MySQL from my EC2 instance. The EC2 has an associated Elastic IP address. I associated an Elastic IP address, SSH to EC2 using the elastic IP. I can still connect from the EC2 with the MySQL admin user. I get an error when I try to connect to the RDS