How to connect MySQL database remotely

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.

Facebook
WhatsApp
Twitter
LinkedIn
Pinterest
en_USEnglish