MySQL is the world’s most popular Open Source SQL database management system and I too thought giving it a try and learn MySQL server on Red hat Linux operating system some time ago. Being a free software MySQL is easy to download from their official website. Many big companies and organization use the MySQL database server as it is very fast, reliable, and easy to use.
Downloading any software from the internet and installing it on your machine is not a big task but sometimes we may face some issue/error where we are unable to install the software and continuously gets an error.
Recommended Article: Passed RHCSA & RHCE Exam with Good Marks
When I downloaded latest MySQL server package from their official website, I was very happy and thought to work immediately after installing the MySQL server.
But when I unzip the downloaded tar file and run RPM command to install it, I was surprised to see the Public key error which is given below.
Transaction Summary ============================================================================= Install 1 Package(s) Upgrade 0 Package(s) Total size: 212 M Installed Size: 212 M Is this ok [y/N]: y Downloading Packages: warning: rpmts_HdrFromFdno: V3 DSA/SHA1 signature: key ID 5072e1f5: NOKEY Public key for MySQL-server-5.6.17-1.el6.i686.rpm is not installed
So after reading and analyzing this error carefully, I came to the conclusion that this package needs a public key to install, which was missing on my Linux OS. This is mainly due to when our package repository checks for keys.
So there can be two solution of it. First we can install the key from the repository we are using and secondly we can configure our YUM such that it does not check for key’s.
I used the second method, as it was very easy. I just modified my /etc/yum.conf file and disabled the gpgcheck option. This can be done by just putting gpgcheck value to zero from one.
Command I used
# vim /etc/yum.conf
Now just edit the gpgcheck option. You can do this by entering r0 when your cursor is at 1, which is highlighted in the above image.
Just my making above changes I was able to proceed further with my installation and it solved ”
Public key for MySQL-Server-5.6.rpm is not installed” error for me.
But my problem does not end here. Now when I again try to install the MySQL server on Red hat Linux I was now getting file conflict error with file from package mysql-libs-5.1.47-4.el6.i686 error.
So, I Google’d about this error and found that there is some bug and It can be overcome by forcefully installing the MySQL RPM package.
# rpm -ivh --force MySQL-server-5.6.17-1.el6.i686.rpm
Note: Please uninstall previous version of MySQL before installing new.
After using above command my issue was resolved and I was able to install a MySQL server on my Red hat Linux machine.