I am new to database administration and making an attempt to hook up with an AWS RDS MariaDB 10.3.20 occasion from my Macbook (10.14.6) on a house community — having no luck. My understanding per different questions and documentation is that I have to make the RDS occasion publicly accessible, however I feel I’ve accomplished that already.
Steps I’ve taken are:
- Created an AWS RDS MariaDB occasion. It’s in a VPC.
- Set it to Publicly Accessible -> Sure.
- Added a brand new Inbound rule within the default safety group to just accept connections on port 3306 from my laptop computer’s IP handle. I feel with step #2 that is pointless (since it’s accepting all ports, all site visitors), however I’ve accomplished it anyhow.
- Seems like all Three subnets on the VPC are linked to an Web Gateway and ought to be accessible from the Web, since they’ve a
0.0.0.0/0route of their routing desk that connects to an
But on my laptop computer on my house community (I work at home, no company community), I can not join by way of the command line:
$ mysql -u <adminusername> -P 3306 -h <RDS endpoint> -p Enter password: ERROR 2002 (HY000): Cannot connect with MySQL server on <RDS endpoint>
After inputting my password the connection seems to trip. Error 2002 seems to be like MySQL is not working on the goal??
I really feel like I am lacking some vital step in regards to the VPCs or safety teams or routing — can anybody level to extra particular documentation or present some extra assist / element? Is it presumably one thing I’ve to do with my house router or cable modem (Comcast)? This query could be very related however seems to be like a company community configuration repair … do house routers have related restrictions built-in? I’ve a TP Hyperlink Archer A7 with vanilla settings linked to a cable modem. I’ve tried establishing a Digital Server to ahead ports to my laptop computer on port 3306, however that does not enhance something.