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

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 This is guide, howto install or upgrade MariaDB 10.2.13 [stable] (10.1.31 [stable] or 10.3.5 [release candidate]) on Fedora 27/26/25, CentOS 7.4/6.9/5.11 and Red Hat (RHEL) 7.4/6.9/5.11. Installing MariaDB is almost same process than install MySQL. Note: If you are moving from MySQL, then make...

30 comments on “Install MariaDB 10.2 on Fedora 27/26, CentOS/RHEL 7.4/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
1 2

Leave a Reply

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

Close