Issues Upgrading MySQL (3.23 -> 4.1)
I've been upgrading MySQL from 3.23 to 4.1 in my first dedicated server. Apparently there were no issues upgrading the files with rpm -Uvh (I installed the packages "client", "server", "shared" and "shared-compat"), but later I got the "DBI" and "client does not support protocol" error message in my WebMin (when trying to access table or user permissions logged as root).
I read and followed some tutorials out there and managed to make this work (playing with the mysql console and the old_password function), and phpMyAdmin worked too, so I started creating a table for a website I just wanted to test (PHP+MySQL).
Later, I found that when setting a password to this new user I created (for the site), all the thing messed up again.
I THEN understood that the steps I followed before were to be able to log in in MySQL using the OLD password format (I though I was just "repairing" something :/ ). So now I discovered that my installation works only if I assign old password formats to MySQL.
Webmin reports the following in the Package list when searching for "mysql":
o MySQL-client 4.1.7-0 Applications/Databases MySQL - Client
o MySQL-devel 4.1.7-0 Applications/Databases MySQL - Development header files and libraries
o MySQL-server 4.1.7-0 Applications/Databases MySQL: a very fast and reliable SQL database server
o MySQL-shared 4.1.7-0 Applications/Databases MySQL - Shared libraries
o MySQL-shared-compat 4.1.7-0 Applications/Databases MySQL shared libraries for MySQL 4.1.7 and 3.23.58
o perl-DBD-MySQL 2.9002-1 Applications/Databases A MySQL interface for perl
o php-mysql 4.3.8-1.1 Development/Languages A module for PHP applications that use MySQL databases.
So I guess that all is correct. Or should be...
Then... why I can't use the new password format?
When setting a new password from Webmin to this user, I get a long encrypted string (the new password format), but when trying to view the site from the web browser I get the error about "Warning: mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client".
But if I go to the SSH and open the mysql console and set a new password using the old_password function, the Web seems to work.
When the whole things stops working is when I set a new password for "root", and I can't even edit the permisions in Webmin, so I have to edit the user again manually in the console.
Any help will be appreciated.
Thanks in advance.