title: "Unable To Connect To Any Of The Specified MySQL Hosts"
body: <p>Thanks in advance for your patience.  As I began typing this, I noticed SO has added the feature in the subject line for browsing similar topics.  After exhausting my resources, I am going to continue this post.</p>
  
  <p>I have two machines on a local network.<br>
    Production Box - Ubuntu, Apache, Mono, Asp.net, C# (ALL up to date).<br>
    Development Box - Windows XP with Xamarin</p>
  
  <p>My Production box hosts out of port 80 on my WAN ip, so I can visit my website from my mobile device (production test) or from my development box (browser production test, or remote development env test using Xamarin).</p>
  
  <p>My connection string most certainly adheres to: 
  server=$servername$;port=3306;database=$databasename$;uid=$username$;password=$password$;</p>
  
  <p>I have used all four server value combinations ([SERVERNAME],localhost, 127.0.0.1, actual network IP for remote dev env test).</p>
  
  <p>I have bind-address: 127.0.0.1 in my cnf.</p>
  
  <p>I continue to get "Unable To Connect To Any Of The Specified MySQL Hosts" server 500 error every time I visit my site, either using a production test (visiting the site by typing in my WAN IP into a browser, Apache is on the same box as MySql) or remote connection (development client, Xamarin debugger).</p>
  
  <p>netstat  says I am listening on port 3306.</p>
  
  <p>I tried removing port 3306 from the connection string.</p>
  
  <p>I tried using different combinations of PASSWORD/PWD  USER ID/UID/USER.</p>
  
  <p>ALL FAILURE.  Please help!</p>