Mysql

[SeLLeRoNe]

I'm using freebsd 5.2.1 with mysql 4.0.17 and i would like to upgrade it to 4.0.22 or 4.1.8 but i didnt found any source on mysql website... someone can help me?

[wdv]

4.0.23a
http://dev.mysql.com/get/Downloads/MySQL-4.0/mysql-4.0.23a.tar.gz/from/pick

4.1.8a
http://dev.mysql.com/get/Downloads/MySQL-4.1/mysql-4.1.8a.tar.gz/from/pick

[SeLLeRoNe]

i've to compile those right?

can u say me what are line command i've to do? :)

thanks

and sorry for my english :P

[wdv]

I am sorry, I am not going to do your homework, this is really basic admin stuff. You can find it in the documentation on mysql.com

It'll probably something like:
./configure
make
make install

Don't expect it to run out of the box, you'll have to symlink the data dir to the DA mysql data dir.

[Chrysalis]

http://www.directadmin.com/forum/showthread.php?s=&threadid=5569

check my post 6th one down.

[janybravo]

If you get this error: Client does not support authentication protocol requested by server; consider upgrading MySQL, when working with mysql in DA.

You'll probably need to set password for da user in MySQL4.1.x because of new hashing format.

log in mysql as root and:

mysql> SET PASSWORD FOR 'da'@'some_host' = OLD_PASSWORD('newpwd');

That's what I've done on my freebsd5.3+mysql4.1 box in order to get things working :)

have phun!