Install MariaDB 10.2 on Fedora 28/27, CentOS/RHEL 7.5/6.9 - Comment Page: 2

Updated on by JR 34 comments
MariaDB is a binary drop in replacement for MySQL database server. This means that for most cases, you can just uninstall MySQL and install MariaDB and you are good to go. Why MariaDB? MariaDB is totally open source version of MySQL It works just like MySQL and is compatible with MySQL setups Fedora and Red Hat/CentOS is moving to use MariaDB from Fedora 19/RHEL 7/CentOS 7 versions [inttf_post_ad1] This is guide, howto install or upgrade MariaDB 10.2.13 [stable] (10.1.31 [stable] or 10.3.5 [release candidate]) on Fedora 28/27/26, CentOS 7.5/6.9 and Red Hat (RHEL) 7.5/6.9. Installing MariaDB is almost same process than install MySQL. Note: If you are moving from MySQL,...
See full post →

34 comments on “Install MariaDB 10.2 on Fedora 28/27, CentOS/RHEL 7.5/6.9 - Comment Page: 2”

1 2

    1. when i’m on “Enable Remote Connection to MariaDB Server –> Open MySQL Port (3306) on Iptables Firewall (as root user again)” at point 1.3 i run “service iptables restart” and i got this:

      [[email protected] sysconfig]# service iptables restart
      Redirecting to /bin/systemctl restart iptables.service
      Job for iptables.service failed. See ‘systemctl status iptables.service’ and ‘journalctl -xn’ for details.

      i fell stuck, i tryed lot’s of suggestion from the web but no one worked. how do i go on?

      Reply

      • Hi ncl,

        Could you post output of following commands:

        
uname -a

systemctl status iptables.service

firewall-cmd --state
        Reply

    2. very good information,
      Thank you

      Reply

    3. Thanks in advance! You save my day!

      Reply

    4. Free access to User root from any address.
      How do I do?

      Thank you.

      Reply

    5. I am unable to start the service of mariadb it gives me following error whenever i am trying to start

      [email protected] Sidkulshrestha]# systemctl start mariadb.service
      Job for mariadb.service failed because the control process exited with error code. See “systemctl status mariadb.service” and “journalctl -xe” for details.

      and when i try to log in it gives following error

      ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’ (2 “No such file or directory”)

      please help

      Reply

      • I seem to have a similar problem. I get the same error when systemctl start mariadb.service.

        systemctl status mariadb.service says
        “The log file /var/log/mariadb/mariadb.log cannot be written, please, fix its permissions.”

        What should the permissons be? They are now
        -rw-rw—-. 1 root root 5638 sep 28 21:06 /var/log/mariadb/mariadb.log

        Reply

    6. It worked fine ! Thanks.

      Reply

    7. I have CentOS 7. I’m trying to upgrade from MariaDB 5.5 to MariaDB 10.2. I’ve created the MariaDB.repo with the tool and placed it in correct place. When I try to install with sudo yum install MariaDB-server MariaDB-client I get a response that MariaDB-server and MariaDB-client are not available and a suggestion that maybe I mean mariadb-server and mariadb-client. If I use the lowercase names, yum installs 5.5 instead of the 10.2 that I have in the *.repo file. Can you help me?

      Reply

      • Hi Minna,

        Could you post output of following command:

        yum repolist --all
        Reply

    8. firewall-cmd –permanent –zone=public –add –port=3306/tcp
      This is a little bit wrong. It should be “–add-port=3306/tcp” to be correct.

      Reply

      • Thanks for pointing this out, it is actually old syntax and I fixed once all guides, but some reason this one was still wrong.

        Reply
1 2

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