How to Install Latest MySQL 8.0 on RHEL/CentOS and Fedora

If You Appreciate What We Do Here On TecMint, You Should Consider:

  1. Stay Connected to: Twitter | Facebook | Google Plus
  2. Subscribe to our email updates: Sign Up Now
  3. Get your own self-hosted blog with a Free Domain at ($3.45/month).
  4. Become a Supporter - Make a contribution via PayPal
  5. Support us by purchasing our premium books in PDF format.
  6. Support us by taking our online Linux courses

We are thankful for your never ending support.

Ravi Saive

I am Ravi Saive, creator of TecMint. A Computer Geek and Linux Guru who loves to share tricks and tips on Internet. Most Of My Servers runs on Open Source Platform called Linux. Follow Me: Twitter, Facebook and Google+

Your name can also be listed here. Got a tip? Submit it here to become an TecMint author.

RedHat RHCE and RHCSA Certification Book
Linux Foundation LFCS and LFCE Certification Preparation Guide

You may also like...

93 Responses

  1. steven says:

    Inadequte instructions for genuine RHEL7.5. mysql 5.7 will not start on reboot.

  2. Anil says:

    Hi, Can I install latest mysql on rhel 6/7 offline? My organization doesn’t permit me to use internet on my rhel server.

  3. Roger says:

    Hello,

    I have a Question about to upgrading the already installed MySQL version: 5.5.56-MariaDB to the 5.7 version. I running Webmin control panel, and by the installing on my VPS server, the MySQL server was included in the installation packet.

    I have an Issue with backup my system, they run in error when I try to make a whole backup, include my databases, the problem are the follow:

    mysqldump: Couldn’t execute ‘show events’: Access denied for user ‘root’@’localhost’ to database ‘performance_schema’ (1044).

    I have try many things to go ride of this, but nothing will works. Some people advice me to upgrade the MySQL server to the lasted version, the problem are a know bug in the earlier version.

    I read your suggestions, but I m’n not sure, if I do the right thing, on a working system, with a pre installed MySQL version, with the Yum in place upgrade.

    Best Regards,
    Roger

    • Ravi Saive says:

      @Roger,

      You can upgrade to MySQL 5.7 from earlier versions, all you need to do is first take the backup of all databases and configurations if any. Then remove the already installed MySQL version from the system, and install new MySQL 5.7 as explained in this article..

  4. capt says:

    HELP got error on fresh install

    [[email protected] home]# tail -f /var/log/mysqld.log
    2017-11-27T16:50:21.551671Z 0 [ERROR] InnoDB: The Auto-extending innodb_system data file ‘./ibdata1’ is of a different size 640 pages (rounded down to MB) than specified in the .cnf file: initial 768 pages, max 0 (relevant if non-zero) pages!
    2017-11-27T16:50:21.551689Z 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
    2017-11-27T16:50:22.153165Z 0 [ERROR] Plugin ‘InnoDB’ init function returned error.
    2017-11-27T16:50:22.153194Z 0 [ERROR] Plugin ‘InnoDB’ registration as a STORAGE ENGINE failed.
    2017-11-27T16:50:22.153211Z 0 [ERROR] Failed to initialize plugins.
    2017-11-27T16:50:22.153221Z 0 [ERROR] Aborting

    2017-11-27T16:50:22.153239Z 0 [Note] Binlog end
    2017-11-27T16:50:22.153485Z 0 [Note] /usr/sbin/mysqld: Shutdown complete

  5. Adrian says:

    Hi,

    I have got an old Cenots 5 system running mysql 5.6. I need to install MySQL 5.7 as additional instance on that old Centos. Is there a way to do that please ?

    • Ravi Saive says:

      @Adrian,

      Yes, you can install additional MySQL by compiling from source to specific directory with different port.

      • Adrian says:

        Hi Ravi,

        Thanks for your quick reply. Right – that option was in my mind but I thought there would be an easier way …. Anyway – thanks a lot !

  6. DHANASEKAR PANCHATCHARAM says:

    I am trying to install MySQL 5.7 over RHEL v7. The sad part is, RHEL came with the pre-installed MariaDB binaries and it is not allowing to install the MySQL. Below is what I’m seeing whenever I try to install:

    [[email protected] mysql_binaries]# yum repolist enabled | grep “mysql.*-community.*”
    mysql-connectors-community/x86_64 MySQL Connectors Community 36
    mysql-tools-community/x86_64 MySQL Tools Community 47
    mysql57-community/x86_64 MySQL 5.7 Community Server 187
    [[email protected] mysql_binaries]#

    [[email protected] mysql_binaries]# yum install mysql-community-server
    Loaded plugins: langpacks, product-id, search-disabled-repos, subscription-manager
    This system is not registered to Red Hat Subscription Management. You can use subscription-manager to register.
    Resolving Dependencies
    –> Running transaction check
    —> Package mariadb-server.x86_64 1:5.5.52-1.el7 will be obsoleted
    –> Processing Dependency: mariadb-server for package: akonadi-mysql-1.9.2-4.el7.x86_64
    —> Package mysql-community-server.x86_64 0:5.7.18-1.el7 will be obsoleting
    –> Processing Dependency: mysql-community-common(x86-64) = 5.7.18-1.el7 for package: mysql-community-server-5.7.18-1.el7.x86_64
    –> Processing Dependency: mysql-community-client(x86-64) >= 5.7.9 for package: mysql-community-server-5.7.18-1.el7.x86_64
    –> Running transaction check
    —> Package mariadb.x86_64 1:5.5.52-1.el7 will be obsoleted
    —> Package mariadb-server.x86_64 1:5.5.52-1.el7 will be obsoleted
    –> Processing Dependency: mariadb-server for package: akonadi-mysql-1.9.2-4.el7.x86_64
    —> Package mysql-community-client.x86_64 0:5.7.18-1.el7 will be obsoleting
    –> Processing Dependency: mysql-community-libs(x86-64) >= 5.7.9 for package: mysql-community-client-5.7.18-1.el7.x86_64
    —> Package mysql-community-common.x86_64 0:5.7.18-1.el7 will be installed
    –> Running transaction check
    —> Package mariadb-libs.x86_64 1:5.5.52-1.el7 will be obsoleted
    –> Processing Dependency: libmysqlclient.so.18()(64bit) for package: perl-DBD-MySQL-4.023-5.el7.x86_64
    –> Processing Dependency: libmysqlclient.so.18()(64bit) for package: 2:postfix-2.10.1-6.el7.x86_64
    –> Processing Dependency: libmysqlclient.so.18()(64bit) for package: 1:net-snmp-5.7.2-24.el7_2.1.x86_64
    –> Processing Dependency: libmysqlclient.so.18()(64bit) for package: 1:qt-mysql-4.8.5-13.el7.x86_64
    –> Processing Dependency: libmysqlclient.so.18(libmysqlclient_18)(64bit) for package: perl-DBD-MySQL-4.023-5.el7.x86_64
    –> Processing Dependency: libmysqlclient.so.18(libmysqlclient_18)(64bit) for package: 2:postfix-2.10.1-6.el7.x86_64
    –> Processing Dependency: libmysqlclient.so.18(libmysqlclient_18)(64bit) for package: 1:qt-mysql-4.8.5-13.el7.x86_64
    —> Package mariadb-server.x86_64 1:5.5.52-1.el7 will be obsoleted
    –> Processing Dependency: mariadb-server for package: akonadi-mysql-1.9.2-4.el7.x86_64
    —> Package mysql-community-libs.x86_64 0:5.7.18-1.el7 will be obsoleting
    –> Running transaction check
    —> Package mariadb-server.x86_64 1:5.5.52-1.el7 will be obsoleted
    –> Processing Dependency: mariadb-server for package: akonadi-mysql-1.9.2-4.el7.x86_64
    —> Package mysql-community-libs-compat.x86_64 0:5.7.18-1.el7 will be obsoleting
    –> Finished Dependency Resolution
    Error: Package: akonadi-mysql-1.9.2-4.el7.x86_64 (@anaconda/7.1)
    Requires: mariadb-server
    Removing: 1:mariadb-server-5.5.52-1.el7.x86_64 (@rhel-7-server-rpms)
    mariadb-server = 1:5.5.52-1.el7
    Obsoleted By: mysql-community-server-5.7.18-1.el7.x86_64 (mysql57-community)
    Not found
    You could try using –skip-broken to work around the problem
    You could try running: rpm -Va –nofiles –nodigest

    [[email protected] mysql_binaries]# yum update mysql-server
    Loaded plugins: langpacks, product-id, search-disabled-repos, subscription-manager
    This system is not registered to Red Hat Subscription Management. You can use subscription-manager to register.
    No Match for argument: mysql-server
    No package mysql-server available.
    No packages marked for update
    [[email protected] mysql_binaries]#

  7. MHDH says:

    Thank you Man

  8. shankar says:

    Hi,

    Are there any compatibility issues with RHEL 7.2 OS for mysql installation?

  9. Aakash says:

    I followed your instructions to install Latest MySQL on my CentOS 7.2 all went well, but now how to login into MySQL server?

Got something to say? Join the discussion.

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.