MySQL 4.1 Yum Update - Checking Before I do it!!

[perfectpenguin]

Hi,
I have a FC2 Plesk box with ART's MySQL 4.0.24, PHP 4.3.1 and PSA 7.5.4. Yum is also installed & configured to use ART's repositories. All working fine. I'd like to ugrade MySQL to 4.1.14 but before I get cracking, I'd just like to check out that what I'm going to do is viable and whether there are any precautions I should take.

So, I plan to run 'yum update mysql mysql-server'. Is that all I should do? Do I need to install 'mysql-compa't or 'php-mysql' for that matter? Sorry if I'm sounding a bit thicko on this - normally I'd do it, blow it, try and fix it and learn as a result but as this is a heavily populated production server I'm erring on the side of caution.

Also, what's the situation with 4.1 and passwords - i've read stuff about this and I'm a bit confused as to what I should do (if anything) post-upgrade with respect to passwords.

Any help is much appreciated.

Thanks,
Simon

[scott]

yum update should do the trick, that will update everything and pick up the tertiary rpms as well.

You'll probably want to set old_passwords=1 in my.cnf as well.

[perfectpenguin]

Thanks Scott, I'll give it a whirl then.

All the best,

Simon