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 […]
Articles Tagged: remote MySQL
Remote MySQL with SOCAT socket
How to make a remote MySQL server with socket by using SOCAT. Remote MySQL advantages - move MySQL CPU usage from local CWP web server - move MySQL disk IO operations from disk - move MySQL disk space usage to other server - improve performances by moving MySQL to SSD multi-core powered server ... on […]