mysql 4.x , 5.0, or 5.1?

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • fris
    I have to go potty
    • Aug 2002
    • 55719
    #1

    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.

    My Latest Theme
    Tags: None
    • fuzebox
      making it rain
      • Oct 2003
      • 22353
      #2
      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.

        Comment

        • BigBen
          Confirmed User
          • Nov 2004
          • 2299
          #3
          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.

            Comment

            • A-Bomb
              Confirmed User
              • Dec 2004
              • 680
              #4
              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.

                Comment

                • fris
                  I have to go potty
                  • Aug 2002
                  • 55719
                  #5
                  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.

                  My Latest Theme

                    Comment

                    • A-Bomb
                      Confirmed User
                      • Dec 2004
                      • 680
                      #6
                      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.

                        Comment

                        • HorseShit
                          Too lazy to set a custom title
                          • Dec 2004
                          • 17513
                          #7
                          five point zero point eighteen

                            Comment

                            • griffin
                              Confirmed User
                              • May 2003
                              • 87
                              #8
                              mysql-server-5.0.24
                              The PornDojo

                                Comment

                                • fris
                                  I have to go potty
                                  • Aug 2002
                                  • 55719
                                  #9
                                  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.

                                  My Latest Theme

                                    Comment

                                    • everyone
                                      Registered User
                                      • Jul 2006
                                      • 92
                                      #10
                                      4.x. 5.x has a lot of random bugs which are irritating.
                                      webNetwork - Powerful Social Network Software

                                        Comment

                                        • Damian_Maxcash
                                          So Fucking Banned
                                          • Oct 2002
                                          • 12745
                                          #11
                                          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....

                                            Comment

                                            • fris
                                              I have to go potty
                                              • Aug 2002
                                              • 55719
                                              #12
                                              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.
                                              Since 1999: 69 Adult Industry awards for Best Hosting Company and professional excellence.

                                              My Latest Theme

                                                Comment

                                                • mrkris
                                                  Confirmed User
                                                  • May 2005
                                                  • 2737
                                                  #13
                                                  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

                                                    Comment

                                                    Previous template Next
                                                    Working...