Comments by JayFab - CodeProject

JayFab 19-Nov-12 15:11pm View

I'm using WAMPP web server locally (LAN). Apache is using ports 80 (HTTP) and 443 (SSL). MySQL is using port 3306. I have explicitly configured my firewall to allow this behavior. To be sure, I uninstalled the firewall and restarted. After rebooting, the error was still invoked.

Additionally, I have reverted my connector version, which did not help. I still receive the same error.

JayFab 18-Nov-12 23:31pm View

Sorry, I've already tried this. No matter how elegantly I write the code, the exception is thrown.

JayFab 18-Nov-12 22:59pm View

Yep. This same connection string works on many other applications that I develop in the WAMP environment. Here is my MySQL user table (for the account i'm attempting to use)

[USER] root
[HOST] localhost
[PASSWORD] No
[GLOBAL PRIVILEGES] ALL PRIVILEGES
[GRANT] Yes

There you have it, the most secure account in MySQL's history. I'm fairly certain this has something to do with the implementation of the connector's DLL. It's not on my end either, I don't think. I'm looking for an older version of the connector now.

Found older versions (will post back with results): http://dev.mysql.com/downloads/connector/net/6.5.html#downloads

Comments by JayFab (Top 3 by date)