title: Remote Connection to MySQL database to bypass through Squid proxy server
body: <p>I am using Squid as a proxy server for web cache in my local network. I have developed a utility in VB.NET that requires a remote connection to a MySQL database on a remote server over internet. I am able to connect to remote server if I disable the proxy server but can not if the proxy is enabled.</p>
  
  <p>I don't know if I can use MySql Proxy in this scenario on my local proxy server and what configurations will I have to make.</p>
  
  <p>Below is my squid configuration;</p>
  
  <blockquote>
    <p>ACL to define ports allowed to passthrough Squid<br /> acl SSL_ports
    port 443<br /> acl Safe_ports port 80      # http<br /> acl Safe_ports
    port 21      # ftp<br /> acl Safe_ports port 1025-65535  #
    unregistered ports<br /> acl Safe_ports port 3306    # mysql remote
    connection<br /> acl CONNECT method CONNECT<br /> <br /> http_access
    deny !Safe_ports<br /> http_access allow Safe_ports<br /> http_access
    allow CONNECT !SSL_ports<br /></p>
  </blockquote>
  
  <p>What alternative I can have to achieve a similar setup that is web cache + remote connection to mysql database.</p>