mysql 4.x , 5.0, or 5.1?
 

what do you run?

I'm still running 4.x :) And Apache 1.3.x and PHP 4.x... Latest security releases of course but I'm too lazy to learn the new shit.

Same here. Probably going to upgrade to mysql 5 and php 5 soon though. Haven't had a chance to checkout apache 2 yet.

I run 4.x because I have a few scripts that are a little "loose" on how they handle NULL value inserts. 5.x has a strict mode by default that doesn?t allow NULL inserts. I think there's a my.ini flag to make 5.x backwards compatible and has a negligible performance impact.... I guess I'm just lazy to do an upgrade in place. My new projects where I am writing the code from ground up will use 5.x since it now handles stored procedures, views, and triggers.

ya 5.0 uses a different password structure too, so you would either have to convert or use --old-passwords on startup

Yeah I forgot that is a bitch when using the DB with older scripts. You will bang your head 500 times trying to figure out why your password in the connection parameter isn't working eventhough it is spelled right. BTW the conversion string that you use in the MySQL console is

I just do this once on a per script basis.

five point zero point eighteen

mysql-server-5.0.24

mysql Ver 14.12 Distrib 5.0.24, for portbld-freebsd5.5

4.x. 5.x has a lot of random bugs which are irritating.

Damn - 4.0.27 - I realy should upgrade...

The problem is I have a few friends sites hosted and if I start messing around I always end up fucking with their stuff.

BTW if you have access to WHM you can set new MySQL versions to use old style passwords by default - there is a check box somewhere....

no idea. i dont use a panel. everything i do is by console.

mysql Ver 14.12 Distrib 5.0.22, for pc-linux-gnu (i486) using readline 5.1

I try to write my code as portable as possible, which includes SQL queries. You never know when you're going to need to migrate to oracle or pgsql, etc. Would hate to code your app using mysql specific features to find out you have to recode it all during migration :)