mysql 4.x , 5.0, or 5.1? - GoFuckYourself.com

fris · 08-17-2006, 09:01 PM

what do you run?

fuzebox · 08-17-2006, 09:24 PM

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.

BigBen · 08-17-2006, 10:25 PM

Quote:

Originally Posted by fuzebox

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.

A-Bomb · 08-17-2006, 10:44 PM

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.

fris · 08-19-2006, 01:17 PM

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

A-Bomb · 08-19-2006, 01:29 PM

Quote:

Originally Posted by Fris

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

Code:

SET PASSWORD FOR 'dude'@'domain' = OLD_PASSWORD('thepass');

I just do this once on a per script basis.

HorseShit · 08-19-2006, 02:24 PM

five point zero point eighteen

griffin · 08-19-2006, 02:29 PM

mysql-server-5.0.24

fris · 08-19-2006, 09:20 PM

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

everyone · 08-19-2006, 09:26 PM

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

Damian_Maxcash · 08-19-2006, 09:29 PM

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....

fris · 08-19-2006, 09:31 PM

Quote:

Originally Posted by damian2001

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.

mrkris · 08-19-2006, 09:32 PM

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

08-17-2006, 09:01 PM	#1
fris Too lazy to set a custom title Industry Role: Join Date: Aug 2002 Posts: 55,382	mysql 4.x , 5.0, or 5.1? what do you run? __________________ Since 1999: 69 Adult Industry awards for Best Hosting Company and professional excellence. WP Stuff

08-19-2006, 01:17 PM	#5
fris Too lazy to set a custom title Industry Role: Join Date: Aug 2002 Posts: 55,382	ya 5.0 uses a different password structure too, so you would either have to convert or use --old-passwords on startup __________________ Since 1999: 69 Adult Industry awards for Best Hosting Company and professional excellence. WP Stuff

08-19-2006, 02:29 PM	#8
griffin Registered User Join Date: May 2003 Posts: 87	mysql-server-5.0.24 __________________ The PornDojo

08-19-2006, 09:20 PM	#9
fris Too lazy to set a custom title Industry Role: Join Date: Aug 2002 Posts: 55,382	mysql Ver 14.12 Distrib 5.0.24, for portbld-freebsd5.5 __________________ Since 1999: 69 Adult Industry awards for Best Hosting Company and professional excellence. WP Stuff

08-19-2006, 09:26 PM	#10
everyone Registered User Join Date: Jul 2006 Posts: 92	4.x. 5.x has a lot of random bugs which are irritating. __________________ webNetwork - Powerful Social Network Software

08-17-2006, 09:24 PM	#2
fuzebox making it rain Industry Role: Join Date: Oct 2003 Location: seattle Posts: 22,170	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.

08-17-2006, 10:44 PM	#4
A-Bomb Confirmed User Industry Role: Join Date: Dec 2004 Location: 1 of 3 holes Posts: 680	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.

08-19-2006, 02:24 PM	#7
HorseShit Too lazy to set a custom title Join Date: Dec 2004 Posts: 17,513	five point zero point eighteen

08-19-2006, 09:29 PM	#11
Damian_Maxcash So Fucking Banned Join Date: Oct 2002 Location: MaxCash.com Posts: 12,745	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....

08-19-2006, 09:32 PM	#13
mrkris Confirmed User Join Date: May 2005 Posts: 2,737	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 __________________ PHP-MySQL-Rails \| ICQ: 342500546