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

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: 8

1 6 7 8 9 10 11
    1. I don’t think you should be getting anything in the lib until you’ve done something with mysql. Such as creating a database or at least some users. Also, if you really screwed up a previous installation like I have, yum won’t remove the /var/lib/mysql folder (at least, it didn’t for me).

      I used this method to attempt reinstalling it several times over, and it failed each time. If you go and delete it manually as root, and then perform the above steps again, it should work.

      Reply
    2. Hi,

      i did each step of this tutorial under Fedora 17 KDE (which is in VMWare workstation as guest machine) and i can’t access from my host machine (windows 7) to MySQL database (which is on Fedora).

      during the whole installation process i had no error or warning.

      so where is the problem ?
      thx

      Reply
      • Hi alain,

        Do you have own ip address on Fedora? And did you used your Windows 7 ip address when you created user and granted permissions?

        Reply
    3. Thanks a lot
      was really helpful updating my server
      God Bless

      Reply
      • Hi James,

        Nice note, thanks! I updated all guides to use latest epel-release-6-8.noarch.rpm version. :)

        Reply
    4. Can u please give step for install Mysql 5.6 ?

      Reply
      • Hi Bhavesh,

        Not yet, this style guide, but if you want to build MySQL 5.6 yourself, then it’s of course possible to install.

        Reply
    5. Still i’m getting error
      Can’t Connect to mysql on ‘Localhost ip’ (113)

      i’m using Cent OS 6.3

      Reply
      • Hi Kartik,

        Could you post full mysql command and error?

        Reply
    6. Hi, this post is great but my problem is this line
      #mysqladmin -u root password my_pass
      mysqladmin: connect to server at ‘localhost’ failed
      error: ‘Access denied for user ‘root’@’localhost’ (using password: NO)’

      what is the solution ?

      Reply
      • Hi KürÅŸat,

        Do you try to change root password?

        You will need use old root password when you connect to MySQL server, like:

        
        ## Password prompt ##
        mysqladmin -u root -p password my_new_pass
        
        ## Password as a parameter (note: no space between -p and old pass) ##
        mysqladmin -u root -pmy_old_pass password my_new_pass
        
        Reply
    7. when i tipe in the last command the output is the following: error 2003 (HY000) can´t connect to mysql server on ‘10.0.15.25’ (110)

      Reply
    8. plz update to Mysql 5.6 is not GA.

      Reply
    9. can you tell me how to do it please? because when i use yum update the output says that there are no packages available for update

      Reply
      • Hi MB,

        This is just example row, you have to use your real ip address, which might be something totally different that 10.0.15.25.

        Reply
    10. awsm! i was setting my own rackspace centos 5.9 cloud server, and this article really got me over the line with getting my LAMP stack going. great repo! great post!

      Reply
    11. Hello! I followed your instruction and I get this error when connecting remotely.

      ERROR 2003 (HY000): Can’t connect to MySQL server on ‘ip-address’ (113)

      Reply
      • Hi Ryan,

        First few questions.

        What OS you use?
        Is your MySQL installation working normally from localhost?
        Did you opened MySQL port on Iptables?
        How did you created MySQL user?

        Reply
    12. Hey, i’m doing a project where i’m trying to install a blog, but first I need MySQL, Apache, WordPress, and php-mysql.

      When doing #7 Connect to MySQL I get this error:

      ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’ (111)

      All the help I can get will be great! Project submission is coming fast.

      Reply
      • Hi Josh,

        Is your MySQL server running?

        Reply
        • I was actually able to fix the problem i was having here. To be honest, i completely forgot what i did to fix it because i did it about 10+ hours ago.

          I’m very new to this, and have almost no experience. I’m doing this as a school project using VMWare in a Fedora 18 core and literally have no clue what i’m doing with your tutorial and notes.

          I do have another problem though.
          I tried to do:
          service httpd restart and was told to see ‘systemctl status httpd.service’ and ‘journalctl -n’ for details.

          The last command that I did that DID work was the yum –enablerepo=remi,remi-test install httpd php php-common.

          I then typed “/etc/init.d/httpd start” and was told there was no file or directory, so i did ls -l /etc/init and saw “/etc/init.d -> rc.d/init.d”

          So then i did service httpd start and it said “redirecting to /bin/systemctl start httpd.service”

          I then did “systemctl enable httpd.service” and didn’t receive any error message so i assumed that it worked.

          I then went on to the test page portion, and typed “/var/www/html/test.php” and added <?php and phpinfo(); to the page, like you said on the apache web page tutorial (sorry it's for the apache site).

          So, when I went to my browser to check it, i didn't receive anything but a "oops. google chrome could not connect to local host." — Is this because i'm using VMWare?

          So i went to look at other comments to see what was there, and followed your directs under Priyabrata to type httpd -t for any syntax errors, and now i'm stuck at this point.

          I get this error/message:
          http: syntax error on line 56 of /etc/httpd/conf/httpd.conf: Syntax error on line 6 of /etc/httpd/conf.modules.d/10-php.conf: Cannot load modules/libphp5.so in to server: /etc/httpd/modules/libphp5.so: symbol SSLeay_version, version OPENSSL_1.0.1 not defined in file libcrypto.so.10 with link time reference

          I have no idea what i'm doing or how to fix this. I still have to finish this stuff in order to start my project that I found on this site:
          http://www.tuxradar.com/content/nine-linux-projects-90-minutes and it's Project 5: Blog from Home.

          I appreciate all the time, effort and help you are giving me in order to solve my problems. If it's as easy and simple as i'm not able to do it in VMWare, do you have another idea for A project I could do in a couple of days worth of time? :D

          Reply
1 6 7 8 9 10 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