Verify MySQL package integrity

Let us understand how to verify the package integrity of MySQL -

Once you have downloaded the MySQl package that suits your user requirements, you must install it. Before installation, please ensure that the package is complete and has not been tampered with.

Check the integrity of the package

There are 3 ways to check the integrity of the package. They are listed below.

• MD5 checksum

• Cryptographic signature with the help of GnuPG, which is GNU Privacy Guard

• For RPM packages, the built-in PRM integrity verification mechanism

Let us understand the MD5 checksum method to check the integrity of the package.

MD5 Checksum

If the MD5 checksum or GPG signature does not match, the user should try to download the corresponding package again from the mirror site.

After downloading the package, make sure its MD5 checksum matches the MD5 checksum provided on the MySQL download page. Each package has an individual checksum that can be verified against the package downloaded by the user.

The correct MD5 checksum will be listed on every MySQL Download page Packaging/Product. Compare the MD5 checksum of the downloaded package with the mentioned package on the Downloads page.

Every operating system and setup has its own version of the tool to check MD5 checksums. Generally, the name of the command is "md5sum" or "md5", but some operating systems don't have this at all.

On Linux, this checksum appears as part of the GNU text utility package, available on a variety of platforms.

If OpenSSL is installed, you can use the command "openssl md5 package_name".

The Windows implementation of the command line utility for md5 can be found here http://www.fourmilab.ch/md5/

"winMd5Sum" is a graphical MD5 checking tool available here Found at http://www.nullriver.com/ index/products/winmd5sum

Let’s look at the Windows and Linux equivalents of this MD5 checksum -

shell> md5sum mysql−standard−8.0.25−linux−i686.tar.gz
aaab65abbec64d5e907dcd41b8699945 mysql−standard−8.0.25−linux−i686.tar.gz
shell> md5.exe mysql−installer−community−8.0.25.msi
aaab65abbec64d5e907dcd41b8699945 mysql−installer−community−8.0.25.msi

User needs to authenticate Whether the generated checksum (a string of hexadecimal digits) matches the checksum displayed on the download page just below the specific package. Make sure to verify the checksum of archive files (e.g. .zip, .tar.gz, .msi) rather than the files that exist in the archive. Basically, validate the file before extracting the content from it.

The above is the detailed content of Verify MySQL package integrity. For more information, please follow other related articles on the PHP Chinese website!