How to work with rpm packages installation, upgrade and roll-back, delete?

• The following rpm command installs Mysql client package.

             # rpm -ivh  MySQL-client-3.23.57-1.i386.rpm

• You can use rpm command to query all the packages installed in your system.

             # rpm -qa
             # rpm -qa | grep MySQL-client

• Query a Particular RPM Package using rpm -q

              # rpm -q MySQL-client

• Information about Installed RPM Package using rpm -qi

             # rpm -qi MySQL-client

• If you have an RPM file that you would like to install, but want to know more information about it before installing, you can do the following:

                # rpm -qip MySQL-client-3.23.57-1.i386.rpm

• List all the Files in a Package using rpm -qlp

               $ rpm -qlp MySQL-client-3.23.57-1.i386.rpm

• Uninstalling a RPM Package using rpm -e

                 # rpm -ev MySQL-client

• Upgrading a RPM Package using rpm -Uvh

                  # rpm -Uvh MySQL-client-3.23.57-1.i386.rpm

• Downgrade or rollback rpm to old version

                # rpm -Uvh --oldpackage "~/MySQL-client-3.23.57-1.i386.rpm"