Re: MySqlException: Unable to connect to any of the specified MySQL hosts

[John-Casey O'Donnell]

I had the same problem, which was related to my connection string. The following caused the connection to fail:

- Parameters delimited by commas
- Port specified as part of "server" parameter (instead of as its own "port" parameter)

The following parameters I found to be interchangeable (i.e. both work):

- "User ID" or "uid"
- "password" or "pwd"

My actual connection string looks like this:

String ^ strConn = "uid=db_user;server=localhost;port=3307;pwd=cygnusx1";



Edited 1 time(s). Last edit at 11/07/2007 09:41PM by John-Casey O'Donnell.