How do I setup mysql workbench connection from laptop to bitnami AWS wordpress mysql DB on port 3306

dwapps 2021-01-01 21:28:33 UTC #1

Keywords: WordPress Multisite - AWS - How to - Other
Description:
I have set AWS security rule to be wide open on port 3306 but I am still getting the following error when trying to connect from workbench on my laptop

Error 2003 - Cant connect to MySQL server on IP (10061 "Unknown error")

I am able to login to DB via command line on the server without issue.

$ nc -vz 3306
nc: connect to port 3306 (tcp) failed: Connection refused

michiel 2021-01-04 07:55:11 UTC #2

Hi @dwapps,

The following guide explains how to connect to MySQL remotely. Could you check if it works for you?

https://docs.bitnami.com/aws/infrastructure/mysql/administration/connect-remotely/

Regards,
Michiel

dwapps 2021-01-05 17:48:49 UTC #3

I have the following AWS security rules set but it is still not allowing me to connect from external workbench on my laptop

michiel 2021-01-07 09:00:31 UTC #4

Hi @dwapps,

Did you open an SSH tunnel as described here?

https://docs.bitnami.com/aws/faq/get-started/access-ssh-tunnel/

Regards,
Michiel

Bitnami provides free all-in-one installers, virtual machines and cloud images for popular open source applications. Get them now!