PHP PDO Connection very slow when connecting to Mysql remotely
Local Computer running apache, PHP 7.1. Connecting using PDO
Remote computer running MySQL 5.7
Connecting to MySQL server remotely using PHP PDO connection returns data very slowly. I have tried adding skip_name_resolve in the MySQL my.ini file but does not make a significant difference. The remote computer is connected via OpenVPN but I have also tried on the same network and I get the same speed results.
How can I resolve this issue?