Connecting to mySQL 4.1.1

[txbakers]

I'm having a problem connecting to the 4.1.1. mySQL with my existing connection string:

var conn ="Driver={MySQL ODBC 3.51 Driver};server=localhost;database=charmspiano;Option=1;UID=Teddy; PWD=Bear; Port=3306; Socket=; Stmt=;";

This was working fine with 4.0 and 3.23

Has anything changed in the 4.1.1 regarding connection strings? I couldn't find anything on the mySQL website.

The string will work if I use UID = root without a password

"Teddy" is a valid user and has privileges on the database charmspiano

And, the string will let me connect without the semi-colon between the UID and PWD:

var conn ="Driver={MySQL ODBC 3.51 Driver};server=localhost;database=charmspiano;Option=1;UID=Teddy PWD=Bear; Port=3306; Socket=; Stmt=;";

which is very disturbing!

Without that semi-colon I can even misspell the UID and it still connects.

Any ideas?

[Xoc]

*bump*

[coopster]

There is a bug in the 4.1.1a alpha release in regards to the password hashing algorithm. See my post in this thread for more information:

Mysql - 3.23 or 4.1
[webmasterworld.com...]

[txbakers]

Thanks coop, that's exactly what I've been looking for.

I don't have many actual mysql users as authentication is kept in a table, but the web apps need to connect and I've been using a user/pw for that.

I'll try the workaround.

I like the new commands in 4.1.1 for date and time manipulation.