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

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.

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.

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

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.

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

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.

Yes! thank you After I use that --old-passwords option, I can access mysql 4.1.0-alpha from remote pc, now.

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

oh! Thank you! This is a good information for me! Thank you very much!