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...
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?
Hi ncl,
Could you post output of following commands:
very good information,
Thank you
Thanks in advance! You save my day!
Free access to User root from any address.
How do I do?
Thank you.
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
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
It worked fine ! Thanks.