How to upgrade mysql to 4.1 not 5

[massekott]

I would like to upgrade mysql to 4.1 but not to 5. I've tried this in apt-get, but it always suggesting 5. How do you tell it which version you want?

I'm running a perfect setup Debian Sarge

Thanks.

[falko]

Do it like this:

apt-get install mysql-server-4.1 mysql-client-4.1 libmysqlclient14-dev

[massekott]

Exactly what I was looking for. Worked like a charm. Thanks Falko!

[nenad]

I would like to upgrade mysql to 4.1 but not to 5. I've tried this in apt-get, but it always suggesting 5. How do you tell it which version you want?

I'm running a perfect setup Debian Sarge

Thanks.

How do you manage that apt-get suggest mysql 5 for upgrade ?

[nenad]

If during the debian sarge install, mysql 4.1 is installed instead of 4.xx , then this happens:

server201:~# mysqladmin -h server1.example.com -u root password yourrootpassword
mysqladmin: connect to server at 'server1.example.com failed
error: 'Lost connection to MySQL server during query'

Unless /etc/mysql/my.cnf is edited and commented out
bind-address = 127.0.0.1:

and mysql is restarted
/etc/init.d/mysql restart

before mysqladmin -h server1.example.com -u root password yourrootpassword
is executed

[falko]

Have a look here: http://www.howtoforge.com/forums/showthread.php?t=4078&highlight=mysqladmin+server1.example.com

[falko]

How do you manage that apt-get suggest mysql 5 for upgrade ?
Maybe he used backports.org?

[nenad]

Have a look here: http://www.howtoforge.com/forums/showthread.php?t=4078&highlight=mysqladmin+server1.example.com

Yes, but with mysql this is passing, with 4.1 it's not.

Anyway, maybie in howto it should be noticed that one who is installing don't have to do that step.