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.
1 2 3 4 5 6 7 8 9 10 11 12 13 |
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
1 |
# 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.
1 |
# 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.
Incoming search terms:
- Solved PublickeyforMySQLServerisnotInstalled
- warning: /var/cache/yum/x86_64/7/mysql57-community/packages/mysql-community-common-5 7 32-1 el7 x86_64 rpm: header v3 dsa/sha1 signature key id 5072e1f5: nokey
- Header V3 DSA/SHA1 Signature key ID 5072e1f5: NOKEY
- public key for mysql-community-client is not installed
Tomas
“I used the second method, as it was very easy.”
Laziness at its best 🙂
Pawan Bahuguna
Yes, I always like to work as simple as possible.