I'm trying to upgrade the default MySQL 3.xx installation on my Redhat 8.0 machine to MySQL 4. In the past I've just installed my programs using tarballs and compiling the source, but it seems to be difficult to upgrade to new versions of an application when I do that. I'm not always sure where everything is installed. So instead, I'm trying to learn to use rpm. When I ran the upgrade command I received the following errors:

[root@localhost root]# rpm -U MySQL-server-4.0.18-0.i386.rpm
warning: MySQL-server-4.0.18-0.i386.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5
error: Failed dependencies:
libmysqlclient.so.10 is needed by (installed) libdbi-dbd-mysql-0.6.5-2
libmysqlclient.so.10 is needed by (installed) mod_auth_mysql-1.11-10
libmysqlclient.so.10 is needed by (installed) MyODBC-2.50.39-7
libmysqlclient.so.10 is needed by (installed) MySQL-python-0.9.1-4
libmysqlclient.so.10 is needed by (installed) perl-DBD-MySQL-2.1017-3
libmysqlclient.so.10 is needed by (installed) qt-MySQL-3.0.5-17
libmysqlclient.so.10 is needed by (installed) php-mysql-4.2.2-8.0.8


What exactly does this mean? It looks like it's trying to tell me these dependencies do not exist. However, I did a rpm -qa | grep <module> for the first three, and they were there. So what's the problem? Any suggestions?

Thanks in advance.

Which three are there? The right hand column, or the left hand column? This is telling you that the item named the the left hand column is missing, or it can't find it.

libdbi-dbd-mysql-0.6.5-2
mod_auth_mysql-1.11-10
MyODBC-2.50.39-7

These three popped up when I ran:
rpm -qa | grep <module>

So I'm assuming they're installed. I can test the rest if necessary, but if those first three were installed, I'm wondering why I received the message that they weren't.

The problem is that you're just trying to update the mysql-server RPM. There are several other RPMs related to MySQL such as mysql-client and others. If you just upgrade the server without upgrading the others, various things such as libraries are goinmg to break since they change with new MySQL releases.

Do rpm -qa | grep mysql and get updated MySQL packages for all of your MySQL RPMs, not just the server. Then install them all in one batch, and it should work.

Okay. How do I install them in one batch?

Just give the filename of each RPM that you are wanting to update separating them by spaces. For Example:

[root@localhost root]# rpm -U MySQL-server-4.0.18-0.i386.rpm MySQL-shared-compat-4.0.18-0.i386.rpm

btw
Be sure to include MySQL-shared-compat-4.0.18-0.i386.rpm since it contains libmysqlclient.so.10