MySQL open LAN and WAN ports

Download and install MySQL first ...

Once configured, the default is to connect only from localhost. If you need a local area network connection (based on a LAN segment of 192.168 or 10.10 or 172.16), you need to do the following:

First, login to the MySQL host command line and enter the following command:

1, use MySQL;

2.update user set host = ‘%‘ where user = ‘root‘;

3,flush privileges;

This will open the LAN connection.

Similar on the WAN, adding configuration ports and firewalls.

MySQL open LAN and WAN ports