How to connect MySQL database remotely
- Open MySQL port 3306 or whitelist your IP in the firewall
- Create remote MySQL user from MySQL manager in CWP
* We recommend whitelisting IP in the firewall as it is a much safer option.
Example of whitelisting IP from the command line
csf -a 10.10.23.124 "mysql remote connection"
Temp allow IP for 24h
csf -ta 86400 10.10.23.124 "mysql remote connection"
Remote MySQL user in CWP is under Host.
You can choose from % Any or Specify Remote IP.