Hi. I have a 6.0.1 server with MySQL and OpenVPN installed. On my WinXP workstation, I have installed MySQL ODBC 3.51.12 as a system DSN and using this I can connect to the MySQL server using either the sme external IP or the OpenVPN server ip (192.168.100.1). I can see and manipulate the MySQL tables. Great! but...
On the ODBC connection dialog, there is a Test button. When I address the server with its external ip, the confirmation OK response comes up immediately, but when I use the OpenVPN ip, the response takes 10 seconds.
This difference in performance is similar connecting using SQLyog, but after connection, there seems to be no performance difference between public and VPN connections.
In the MySQL server, the permission is set as:-
Grant all on db.* to user@% identified by password;
Any thoughts or suggestions?[/code]
0 Replies
1249 Views