MySQL 4.1?

[ping182nz]

Hi,

I am in the process of setting up my testing server,

Is it worth using MySQL 4.1 when there is the hassel with authentication? or is just as easy to stick with 4.0?

If i upgrade, is it simple to get MySQL 4.1 to authenticate through php5?

Thanks...

[Tangerine Dream]

Is it worth using MySQL 4.1 when there is the hassel with authentication? or is just as easy to stick with 4.0?
Hi, whether to upgrade or not depends on several things like:

What is the current version of your production MySQL server.
If you/your stakeholder plans to use MySQL 4.0 in the nearest future, it's not necessary
to upgrade.
How well do you know MySQL server and whether you have additional time to solve
possible problems with MySQL server/database upgrade.
If you can do your database development efficiently with same quality, it's not necessary
to upgrade. The required time for upgrade also depends on your DB size and whether you have
columns with charsets/collations to be upgraded to MySQL 4.1.


Check 2.10.2. Upgrading from Version 4.0 to 4.1 (http://dev.mysql.com/doc/mysql/en/upgrading-from-4-0.html) and 10.10. Upgrading Character Sets from MySQL 4.0 (http://dev.mysql.com/doc/mysql/en/charset-upgrading.html):
Server Changes:
The most notable change is that character set support has been improved. The server supports multiple character sets, and all tables and string columns have a character set. See Chapter 10, Character Set Support. However, this change results in the potential for table damage if you do not upgrade properly, so consider carefully the incompatibilities noted here.

Incompatible change: There are conditions under which you should rebuild tables. In general, to rebuild a table, dump it with mysqldump and reload the dump file. Some items in the following list indicate alternatives means for rebuilding.
.....
If you have table columns that store character data represented in a character set that the 4.1 server supports directly, you can convert the columns to the proper character set using the instructions in Section 10.10.2, “Converting 4.0 Character Columns to 4.1 Format”.
....etc...

If i upgrade, is it simple to get MySQL 4.1 to authenticate through php5?
The auth problems might be not with PHP 5 (it works with both MySQL 4.0 and 4.1), but with MySQL server itself if you don't upgrade MySQL user names properly