Results 1 to 11 of 11
  1. #1
    Join Date
    Nov 2003
    Posts
    6

    Unanswered: MySQL 4.0 or 4.1

    hi,

    I'm installing a fresh copy of mysql on my machine.
    I'm not sure whether to go with the 4.0 production release or the 4.1 alpha.
    I really need the new features in 4.1 such as subqueries. Can anyone suggest why I should not use 4.1? Is it stable? What are some of the differences between the two versions?

    Thanks

  2. #2
    Join Date
    Nov 2003
    Posts
    91
    Version 4.1.1 is being birthed right now. I expect it out
    in a couple of weeks. If you can wait 2 weeks, I would
    use 4.1.1.
    I would stay away from 4.1.0 -- this was released about
    8 months ago and it has some problems, which is not surprising
    for an alpha release. Tons of things have been
    fixed in the 4.1.1 release.
    I use 4.0.16 since I need something rock solid. The only
    thing I miss are subselects. But if 4.1.1 were released
    today I would upgrade.

  3. #3
    Join Date
    Sep 2003
    Location
    London
    Posts
    56
    I agree with the answer you were given at devshed. If it's a production database then use the production version. If you're testing, use whatever you like.

  4. #4
    Join Date
    Nov 2003
    Posts
    6
    hi,

    thanks for the infos..
    I guess if its only 2 weeks, I can wait.
    I would probably start developing with the alpha release and change it to 4.1.1 for production mode once it comes out.

    Thanks

  5. #5
    Join Date
    Nov 2003
    Posts
    91
    Two weeks is just a semi-wild-ass guess (SWAG) on my part, but it's
    based on one of the MySQL developers who
    posted about 6 weeks ago that they are trying to push 4.1.1 out
    the door now, and all that remains is making sure it
    tests the same on all platforms supported.

    To reiterate good advice above, don't use an Alpha build if
    this is a mission-critical system. There WILL be bugs in the
    alpha build, just not likely anything major.

  6. #6
    Join Date
    Jul 2003
    Posts
    35
    Hi,

    We had some pretty nasty problems with 4.1.0 using subselects and unions (which I believe have been rectified in 4.1.1). So decided to stick with 4.0+ and temp tables for the meantime.

    Definitely, ain't worth upgrading yet... but cool for mucking around with nonetheless.

    Chrs,
    Ash

  7. #7
    Join Date
    Oct 2003
    Location
    Taiwan
    Posts
    16
    Hi, everybody.
    I just use MySQL 4.1.0-alpha last Friday. At the beginning, I install it on a windows 2000 server, but I use phpMyAdmin to control it from a linux server. Before I change the empty password of the root, the mysql server can access from the remote. After I chage the root's password, it become access denied. the following is the error message:

    #1249 - Client does not support authentication protocol requested by
    server. Consider upgrading MySQL client

    In fact, it also happen on my client pc which is running a delphi program with ODBC access.

    The message tell me that I should upgrate my MySQL client. But... what is the MySQL client? The version of my ODBC driver is 3.51. I don't find any other version besides 2.5.0 on http://www.mysql.com.
    What is the authentication protocol ?
    What happen to me?? :s Somebody help me...
    My English is poor, so... please forgive me if I make mistakes.

  8. #8
    Join Date
    Sep 2003
    Location
    London
    Posts
    56
    Originally posted by AkiraJ
    Hi, everybody.
    I just use MySQL 4.1.0-alpha last Friday. At the beginning, I install it on a windows 2000 server, but I use phpMyAdmin to control it from a linux server. Before I change the empty password of the root, the mysql server can access from the remote. After I chage the root's password, it become access denied. the following is the error message:

    #1249 - Client does not support authentication protocol requested by
    server. Consider upgrading MySQL client

    In fact, it also happen on my client pc which is running a delphi program with ODBC access.

    The message tell me that I should upgrate my MySQL client. But... what is the MySQL client? The version of my ODBC driver is 3.51. I don't find any other version besides 2.5.0 on http://www.mysql.com.
    What is the authentication protocol ?
    What happen to me?? :s Somebody help me...
    The default access verification and password hashing methods in 4.1 have changed. If you want legacy apps to work, you have to install mysql with the --old-passwords option.

    http://www.mysql.com/doc/en/Password_hashing.html

    Matt.

  9. #9
    Join Date
    Oct 2003
    Location
    Taiwan
    Posts
    16
    Originally posted by Mincer
    The default access verification and password hashing methods in 4.1 have changed. If you want legacy apps to work, you have to install mysql with the --old-passwords option.

    http://www.mysql.com/doc/en/Password_hashing.html

    Matt.
    Yes! thank you After I use that --old-passwords option, I can access mysql 4.1.0-alpha from remote pc, now.
    My English is poor, so... please forgive me if I make mistakes.

  10. #10
    Join Date
    Apr 2004
    Posts
    1
    para asignar usuarios debes ejecutar
    el codigo mas o menos como esto :


    INSERT INTO mysql.user(Host,User,Password)
    VALUES('localhost','felipe',PASSWORD('hola'));

    GRANT ALL ON *.* to "felipe"@"localhost";

    UPDATE mysql.user
    SET password=OLD_PASSWORD('toysdeko')
    WHERE user='felipe'
    AND host='localhost';

    FLUSH PRIVILEGES ;

    y listo , probado en la version Mysql 5.0 alpha

  11. #11
    Join Date
    Oct 2003
    Location
    Taiwan
    Posts
    16

    Talking

    Originally posted by JAGS90
    UPDATE mysql.user
    SET password=OLD_PASSWORD('toysdeko')
    WHERE user='felipe'
    AND host='localhost';

    FLUSH PRIVILEGES ;

    oh! Thank you! This is a good information for me! Thank you very much!
    My English is poor, so... please forgive me if I make mistakes.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •