Upgraded to MySQL 4.1 now can't open connection

[theScien]

Hi,
I upgraded to 4.1 and now can't connect to the server with my usual connection string.

I'm using MySQL on Windows Server 2003 STD, and usual use ASP and ASP.NET scripting with it.

Also upgraded to connector to the latest version, can connect but nothing else works, what's going on?

I had to go back to 4.0.?? and to my old connector (luckily still had it) to get MySQL back on.

Is this fixed in 5.0?

 

[TonyGroves]

The 4.1 server upgrade should be transparent to your clients. However, if the system privilege tables were reset during the upgrade, that would cause problems.

 

[theScien]

Right, here's what I've done, I have zipped all user databases from mysql\data, then uninstalled mysql server, rebooted the server, installed new mysql 4.1, set it up, unzipped back the user databases and put them back in data dir, created and set new user accounts to operate their respective databases, then all web applications couldn't connect.

Also uninstalled old connector and installed new one, the connetion was now possible, but applications would still don't work.

So what are my options?
Pointers please.

 

[guelphdad]

The problem is likely that you need to use OLD PASSWORDS. In version 4.1 there is new password hashing used. There is an incompatibility with PHP using mysql instead of mysqli.

Check the MySQL manual on OLD PASSWORD hashing and you should be good to go.

 

[theScien]

Yes, I remember reading about it, and I played with it at the time, enabling and disabling it in MySQL, no avail, anyway, I'm willing to recreate all passwords in the new version, if it lets me too.

I will only bring the server down and mess with it again when I'm absolutly sure of what it is, last time it was a big problem as sites went down for a few hours.

I have also installed v4.1 on my development notebook which was running the same version of MySQL and connector as in the server, and no problem what so ever.