Install MySQL 8.0/5.7 on Fedora 29/28, CentOS/RHEL 7.5/6.10 - Comment Page: 1

Are you looking MariaDB 10.3/10.2 Install guide? MySQL is a relational database management system (RDBMS) that runs as a server providing multi-user access to a number of databases. This is guide, howto install or upgrade MySQL Community Server latest version 8.0 (8.0.13)/5.7 (5.7.24) on Fedora 29/28/27, CentOS 7.5/6.10 and Red Hat (RHEL) 7.5/6.10. This guide works of course with Oracle Linux and Scientific Linux too. [inttf_post_ad1] Note: If you are upgrading MySQL (from earlier version), then make sure that you backup (dump and copy) your database and configs. And remember run mysql_upgrade command. Install MySQL Database 8.0.13/5.7.24 on Fedora 29/28/27,...

285 comments on “Install MySQL 8.0/5.7 on Fedora 29/28, CentOS/RHEL 7.5/6.10 - Comment Page: 1

1 2 3 11
    1. […] artykuÅ‚: Install MySQL 5.1 (5.1.49) on Fedora 13, CentOS 5.5, Red Hat (RHEL … a-server-providing, fedora, greatest-version, howto-install, install-or-upgrade, latest-and, […]

      Reply
    2. Thanks for the tutorial.

      When I run the commands to install/upgrade mysql and mysql-server, PHP 5.3 is included in the list of dependencies. Is there a reason for this? I do a lot of Drupal development, which doesn’t support PHP 5.3 at this point.

      Is there a way to upgrade mysql and not upgrade PHP?

      Reply
      • Hi Erich,

        Could you post full list of dependencies, what packages is going to be installed?

        Reply
        • 
          ================================================================================================================================================================================================
           Package                                        Arch                                  Version                                                   Repository                                 Size
          ================================================================================================================================================================================================
          Updating:
           mysql-server                                   i386                                  5.5.12-1.el5.remi                                         remi                                       12 M
          Installing for dependencies:
           libXaw                                         i386                                  1.0.2-8.1                                                 base                                      324 k
           libXmu                                         i386                                  1.0.2-5                                                   base                                       62 k
           libedit                                        i386                                  20090923-3.0_1.el5.rf                                     rpmforge                                  262 k
           mysql-libs                                     i386                                  5.5.12-1.el5.remi                                         remi                                      1.1 M
           mysqlclient15                                  i386                                  5.0.67-1.el5.remi                                         remi                                      1.3 M
           t1lib                                          i386                                  5.1.2-1.el5.rf                                            rpmforge                                  362 k
          Updating for dependencies:
           mysql                                          i386                                  5.5.12-1.el5.remi                                         remi                                      7.5 M
           mysql-devel                                    i386                                  5.5.12-1.el5.remi                                         remi                                      168 k
           php                                            i386                                  5.3.6-4.el5.remi                                          remi                                      1.3 M
           php-cli                                        i386                                  5.3.6-4.el5.remi                                          remi                                      2.6 M
           php-common                                     i386                                  5.3.6-4.el5.remi                                          remi                                      970 k
           php-devel                                      i386                                  5.3.6-4.el5.remi                                          remi                                      623 k
           php-gd                                         i386                                  5.3.6-4.el5.remi                                          remi                                      205 k
           php-ldap                                       i386                                  5.3.6-4.el5.remi                                          remi                                       53 k
           php-mysql                                      i386                                  5.3.6-4.el5.remi                                          remi                                      148 k
           php-pdo                                        i386                                  5.3.6-4.el5.remi                                          remi                                      113 k
          
          Transaction Summary
          ================================================================================================================================================================================================
          Install      6 Package(s)         
          Update      11 Package(s)         
          Remove       0 Package(s)         
          
          Reply
    3. Merci Rémi pour cet article et l’accès au repos.

      Reply
    4. This update doesn’t work with perl , i need perl to connect to mysql database

      Reply
      • Hi Um,

        What distro and Perl version are you using?

        What error message you get when trying to connect to MySQL database?

        Reply
    5. When I attempt the last step I get the following:
      # service iptables restart
      iptables: Flushing firewall rules: [ OK ]
      iptables: Setting chains to policy ACCEPT: filter [ OK ]
      iptables: Unloading modules: [ OK ]
      iptables: Applying firewall rules: iptables-restore: line 14 failed [FAILED]

      Here is the content of iptables:
      # Firewall configuration written by system-config-firewall
      # Manual customization of this file is not recommended.
      *filter
      :INPUT ACCEPT [0:0]
      :FORWARD ACCEPT [0:0]
      :OUTPUT ACCEPT [0:0]
      -A INPUT -m state –state ESTABLISHED,RELATED -j ACCEPT
      -A INPUT -p icmp -j ACCEPT
      -A INPUT -i lo -j ACCEPT
      -A INPUT -m state –state NEW -m tcp -p tcp –dport 22 -j ACCEPT
      -A INPUT -m state –state NEW -m tcp -p tcp –dport 80 -j ACCEPT
      -A INPUT -j REJECT –reject-with icmp-host-prohibited
      -A FORWARD -j REJECT –reject-with icmp-host-prohibited
      -A RH-Firewall-1-INPUT -m state –state NEW -m tcp -p tcp –dport 3306 -j ACCEPT
      COMMIT

      Any idea what is wrong?

      Reply
      • Hi WM,

        Try to change -A RH-Firewall-1-INPUT -m state –state NEW -m tcp -p tcp –dport 3306 -j ACCEPT row to following -A INPUT -m state –state NEW -m tcp -p tcp –dport 3306 -j ACCEPT line.

        Something like following:

        
        ...
        -A INPUT -m state --state NEW -m tcp -p tcp --dport 22 -j ACCEPT
        -A INPUT -m state --state NEW -m tcp -p tcp --dport 80 -j ACCEPT
        -A INPUT -m state --state NEW -m tcp -p tcp --dport 3306 -j ACCEPT
        -A INPUT -j REJECT --reject-with icmp-host-prohibited
        -A FORWARD -j REJECT --reject-with icmp-host-prohibited
        COMMIT
        
        Reply
        • ‘service iptables save’
          is required before the ‘service iptables restart’ step;

          Reply
    6. thumbs up, thanks a lot…… It worked perfectly for my Fedora 13

      Reply
    7. Thanks, I was very useful!!!

      Reply
    8. Hello, the tutorial works, thanks, man. I used the tutorial and any information that appears when we install the mysql.

      Look:

      “To start mysqld at boot time you have to copy
      support-files/mysql.server to the right place for your system

      PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
      To do so, start the server, then issue the following commands:

      /usr/bin/mysqladmin -u root password ‘new-password’
      /usr/bin/mysqladmin -u root -h localhost.localdomain password ‘new-password’

      Alternatively you can run:
      /usr/bin/mysql_secure_installation

      which will also give you the option of removing the test
      databases and anonymous user created by default. This is
      strongly recommended for production servers.

      See the manual for more instructions.

      You can start the MySQL daemon with:
      cd /usr ; /usr/bin/mysqld_safe &

      You can test the MySQL daemon with mysql-test-run.pl
      cd /usr/mysql-test ; perl mysql-test-run.pl

      Please report any problems with the /usr/bin/mysqlbug script!”

      ========================================================

      This was very usefull, thank you, man!

      Reply
    9. I’ve got Error message file ‘/usr/share/mysql/english/errmsg.sys’ had only 480 error messages instead of 641

      It is due that I have duplicated packages (mysql.i386 and mysql.x86_64 from remi). You can list that with: yum list *.i386 –> And after that you can remove dupes: yum remove *.i386

      After restart, it does not work:
      – ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’
      – Error message file ‘/usr/share/mysql/english/errmsg.sys’ had only 480 error messages,
      but it should contain at least 641 error messages.

      The mysql-server-5.1.47-1.el5.remi.x86_64.rpm does not contain the language files.

      The language files are in: mysql-libs-5.1.47-1.el5.remi.x86_64.

      The language files from the 5.0.x version remain installed and cause this error. In order to avoid this, I explicitly installed the 64 bit versions: yum –enablerepo=remi install mysql-libs mysql.x86_64 mysql-devel.x86_64 mysql-server php-mysql

      After install it, it works.

      Reply
    10. mysql_secure_installation is nowhere to be found. The default initial mysql database is not created.

      Reply
    11. server was not installed, that’s why the installation script was not there. Sorry!

      Reply
    12. when i type to command prompt “yum –enablerepo=remi install mysql-libs mysql.x86_64 mysql-devel.x86_64 mysql-server php-mysql”

      i saw this errors:

      file /usr/share/mysql/estonian/errmsg.sys from install of mysql-libs-5.1.53-16
      file /usr/share/mysql/french/errmsg.sys from install of mysql-libs-5.1.53-1.e6
      file /usr/share/mysql/german/errmsg.sys from install of mysql-libs-5.1.53-1.e6
      file /usr/share/mysql/greek/errmsg.sys from install of mysql-libs-5.1.53-1.el6
      file /usr/share/mysql/hungarian/errmsg.sys from install of mysql-libs-5.1.53-6
      file /usr/share/mysql/italian/errmsg.sys from install of mysql-libs-5.1.53-1.6
      file /usr/share/mysql/japanese/errmsg.sys from install of mysql-libs-5.1.53-16
      file /usr/share/mysql/korean/errmsg.sys from install of mysql-libs-5.1.53-1.e6
      file /usr/share/mysql/norwegian-ny/errmsg.sys from install of mysql-libs-5.1.6
      file /usr/share/mysql/norwegian/errmsg.sys from install of mysql-libs-5.1.53-6
      file /usr/share/mysql/polish/errmsg.sys from install of mysql-libs-5.1.53-1.e6
      file /usr/share/mysql/portuguese/errmsg.sys from install of mysql-libs-5.1.536
      file /usr/share/mysql/romanian/errmsg.sys from install of mysql-libs-5.1.53-16
      file /usr/share/mysql/russian/errmsg.sys from install of mysql-libs-5.1.53-1.6
      file /usr/share/mysql/serbian/errmsg.sys from install of mysql-libs-5.1.53-1.6
      file /usr/share/mysql/slovak/errmsg.sys from install of mysql-libs-5.1.53-1.e6
      file /usr/share/mysql/spanish/errmsg.sys from install of mysql-libs-5.1.53-1.6
      file /usr/share/mysql/swedish/errmsg.sys from install of mysql-libs-5.1.53-1.6
      file /usr/share/mysql/ukrainian/errmsg.sys from install of mysql-libs-5.1.53-6

      any solutions ?

      Reply
      • Hi haberler,

        What OS you are using?

        Is that the entire error message? I guess that the error message is missing something?

        Is the full error message something like?

        
        file /usr/share/mysql/greek/errmsg.sys from install of
        mysql-libs-5.1.53-1.el5.x86_64 conflicts with file from package
        mysql-5.0.77-4.el5.x86_64
          file /usr/share/mysql/hungarian/errmsg.sys from install of
        mysql-libs-5.1.53-1.el5.x86_64 conflicts with file from package
        mysql-5.0.77-4.el5.x86_64
        
        Reply
        • Hi JR, I have the problem that you describe. What i need to do to solved?.
          Could you please help me with this.

          Reply
          • Hi Wilder,

            Could you post output of following command:

            
            yum list installed |grep mysql
            
            Reply
    13. Thank you very much!!!

      Reply
    14. This works great for Centos 5.5 i386, but not for x86_64 version.

      Reply
      • Hi Lucas,

        Could you tell me what’s your problem with CentOS 5.5 x86_64 version?

        I can get MySQL 5.5.8 running on CentOS 5.5 x86_64 normally.

        Reply
        • Hi JR:

          I have a Centos 5.5 x86_64
          uname -a says

          Linux xxx 2.6.18-194.32.1.el5 #1 SMP Wed Jan 5 17:52:25 EST 2011 x86_64 x86_64 x86_64 GNU/Linux

          The mysql not start.

          This say mysql.log


          [ERROR] Error message file '/usr/share/mysql/english/errmsg.sys' had only 480 error messages, but it should contain at least 705 error messages.
          Check that the above file is the right version for this program!
          [Note] Plugin 'FEDERATED' is disabled. /usr/libexec/mysqld: Unknown error 1146
          [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
          InnoDB: The InnoDB memory heap is disabled
          InnoDB: Mutexes and rw_locks use GCC atomic builtins
          InnoDB: Compressed tables use zlib 1.2.3
          ....
          [ERROR] Aborting

          Regards

          Reply
          • Hi again Lucas,

            Could you post output of following command:

            
            yum list installed |grep mysql
            
            Reply
            • Hi JR:

              [[email protected] ~]# yum list installed |grep mysql
              compat-mysql51.x86_64 5.1.54-1.el5.remi installed
              mysql.x86_64 5.5.8-1.el5.remi installed
              mysql-connector-odbc.x86_64 3.51.26r1127-1.el5 installed
              mysql-devel.x86_64 5.5.8-1.el5.remi installed
              mysql-libs.x86_64 5.5.8-1.el5.remi installed
              mysql-server.x86_64 5.5.8-1.el5.remi installed
              mysqlclient15.x86_64 5.0.67-1.el5.remi installed
              php-mysql.x86_64 5.3.5-1.el5.remi installed

              Thanks for your help.

              Reply
    15. could solve the problem with this

      yum –enablerepo=remi,remi-test install mysql-libs mysql.x86_64 mysql-devel.x86_64 mysql-server php-mysql

      Greetings

      Reply
      • Hi Lucas,

        I think that could solve your problem. Please let me know is it working?

        Reply
        • I used…

          # yum --enablerepo=remi install mysql.x86_64 mysql-server.x86_64
          # shutdown -r now
          # sudo /etc/init.d/mysqld start
          # /usr/bin/mysql_secure_installation

          And that worked fine for me :)

          Reply
1 2 3 11

Leave a Reply

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.

Close