MYSQL Open Port 3306

Magento 2 Server Configuration
1

Hi All

I’ve installed Magento 2.3 following Craig guild ( [How to install Magento 2.3 and build a web server]

i’m looking for some some help in white listing my ip address so i can connect from my desktop to MYSQL on port 3306. At the moment it would appear i’m being blocked by the server.

I’m using store manager for Magento to do this (https://www.mag-manager.com/)

Any help would be great

2

To create a firewall exception for 3306 on Ubuntu OS:

sudo ufw allow from 123.123.123.123/24 to any port 3306

Replace 123.123.123.123 with your home IP. Note that your mysql user account must also allow remote access to login.