edit: this is on RH8

I know just enough to get myself in trouble apparently.

Using Webmin I restricted security so much within MySQL that root was no longer allowed to do anything. Trying various suggestions, I finally resolved to exporting the one database being used to a SQL file and simply (for some) reinstalling MySQL. Apparently, I took the wrong approach:

Here are the events:

• ran rpm -qa | grep mysql which only returned php-mysql-4.2.2-8.0.8, which incidentally was not the version that I had running on the machine (4.0.16-0).
• ran rpm -e php-mysql-4.2.2-8.0.8
• ran rpm -qa | grep mysql again, which returned nothing. At this point however, MySQL was still running on the box, but although I had originally installed via RPM, it was not being displayed via the method above.
• ran whereis mysql, which returned /usr/lib/mysql; /usr/include/mysql; /usr/share/mysql; /usr/share/man/man1/mysql1.1.gz
• ran rm -rf on each of the previously listed directories/files
• ran whereis mysql which simply returned mysql:
• using Webmin I removed mysql from the Bootup and Shutdown list

At this point I felt that I had cleared out my installation and was ready to install the RPMs again. I did the following:

• rpm -i MySQL-client-4.0.16-0.i386.rpm which returned warning: MySQL-client-4.0.16-0.i386.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5
  package MySQL-client-4.0.16-0 is already installed
• rpm -i MySQL-server-4.0.16-0.i386.rpm which returned warning: MySQL-server-4.0.16-0.i386.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5
  package MySQL-server-4.0.16-0 is already installed
• rpm -i MySQL-shared-4.0.16-0.i386.rpm which returned warning: MySQL-shared-4.0.16-0.i386.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5 (note: it did not say 'package xxxx is already installed' like the previous ones)
• rpm -i MySQL-shared-compat-4.0.16-0.i386.rpm which returned warning: MySQL-shared-compat-4.0.16-0.i386.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5 (again, no 'package xxxx is already installed')

So, starting to sense that I am headed a bad direction I decided that since it said they were installed, I would do the following:

• rpm -e MySQL-shared-compat-4.0.16-0.i386.rpm which returned error: package MySQL-shared-compat-4.0.16-0.i386.rpm is not installed
• rpm -e MySQL-shared-4.0.16-0.i386.rpm which returned error: package MySQL-shared-4.0.16-0.i386.rpm is not installed
• rpm -e MySQL-server-4.0.16-0.i386.rpm which returned error: package MySQL-server-4.0.16-0.i386.rpm is not installed
• rpm -e MySQL-client-4.0.16-0.i386.rpm which returned error: package MySQL-client-4.0.16-0.i386.rpm is not installed

So... I am now obviously stuck somewhere between installed and uninstalled and honestly don't have a freaking clue what to do. I realize this is a lot of reading, but I just wanted to be as detailed as possible in hopes that someone could possibly tell me where I went wrong and how to recover.

Any advice would be wholly appreciated. Thanks in advance.

Drop the .rpm in the package name for the uninstall

IE: rpm -e MySQL-client-4.0.16-0.i386 vs rpm -e MySQL-client-4.0.16-0.i386.rpm

# Red Hat links
Red Hat Linux Manuals
Get your mp3 support here
Maximum RPM
rpmfind
Easier software management: apt4rpm - Red Carpet
Red Hat 8.0 Tips & Tricks

# Red Hat 7.3 down configuration commands
setup leads to several configuration tools

# Red Hat 7.3 up configuration commands
Configure soundcard:
redhat-config-soundcard
Configure X server:
redhat-config-xfree86
Configure network:
redhat-config-network
Manage software:
redhat-config-packages
Red Hat Linux 8.0 Package Management Tool
Red Hat 9.0 Package Management Tool
Manage users
redhat-config-users

# Handling NTFS
New Technology FileSystem (NTFS) HOWTOs
Linux NTFS project
Rute Guide's software explanation
You might want to check out CheckInstall to manage source code installations/uninstallation

# Guides to software management
LNAG - How do I install a program I downloaded from the Internet?
Rute Guide's software explanation
You might want to check out CheckInstall to manage source code installations/uninstallation

Thanks for the reply... however, still in the same place. the following is a copy/paste:

[root@69-x-x-x root]# rpm -e MySQL-client-4.0.16-0.i386
error: package MySQL-client-4.0.16-0.i386 is not installed
[root@69-x-x-x root]# rpm -i MySQL-client-4.0.16-0.i386.rpm
warning: MySQL-client-4.0.16-0.i386.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5
package MySQL-client-4.0.16-0 is already installed

If you really want to install the packages, you can use --force and it will install over the other one. or just use -U to upgrade. This sometimes creates problems, but usually it fixes any package errors you might be having

You should also drop the .i386 from the package name in your rpm -e command.

John

I have tried a WHOLE lot of differnt approaches on this, but a common thread is that no mater what switches I throw at it, I seem to always get this:

V3 DSA signature: NOKEY, key ID 5072e1f5

It should be noted that I updated RH between the time that I installed MySQL and attempted to uninstall. I have no idea if that has any bearing, but I figured I should mention it.

Thanks again.

You do not have that key installed, no problem


rpm -e MySQL-client MySQL-server

rpm -i MyS*

If the uninstall fails, as stated above force it

rpm -i --force MyS*