PDA

View Full Version : Mysql



SeLLeRoNe
01-03-2005, 09:37 PM
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
01-04-2005, 06:44 AM
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
01-04-2005, 07:10 AM
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
01-04-2005, 07:37 AM
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
01-04-2005, 07:40 AM
http://www.directadmin.com/forum/showthread.php?s=&threadid=5569

check my post 6th one down.

janybravo
01-07-2005, 03:00 AM
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!