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.I have two machines on a local network.
Production Box - Ubuntu, Apache, Mono, Asp.net, C# (ALL up to date).
Development Box - Windows XP with XamarinMy 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).My connection string most certainly adheres to: server=$servername$;port=3306;database=$databasename$;uid=$username$;password=$password$;I have used all four server value combinations ([SERVERNAME],localhost, 127.0.0.1, actual network IP for remote dev env test).I have bind-address: 127.0.0.1 in my cnf.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).netstat says I am listening on port 3306.I tried removing port 3306 from the connection string.I tried using different combinations of PASSWORD/PWD USER ID/UID/USER.ALL FAILURE. Please help!
Production Box - Ubuntu, Apache, Mono, Asp.net, C# (ALL up to date).
Development Box - Windows XP with XamarinMy 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).My connection string most certainly adheres to: server=$servername$;port=3306;database=$databasename$;uid=$username$;password=$password$;I have used all four server value combinations ([SERVERNAME],localhost, 127.0.0.1, actual network IP for remote dev env test).I have bind-address: 127.0.0.1 in my cnf.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).netstat says I am listening on port 3306.I tried removing port 3306 from the connection string.I tried using different combinations of PASSWORD/PWD USER ID/UID/USER.ALL FAILURE. Please help!