Install MariaDB 10.6/10.5 on Fedora 35/34, CentOS Stream 8/RHEL 8.5/Rocky Linux 8.5 - 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/Rocky Linux use MariaDB instead of MySQL
[inttf_post_ad1]
This is guide, howto install or upgrade MariaDB 10.7.1 [RC], 10.6.3 [stable] or 10.5.13 [stable] on Fedora 35/34/33, CentOS Stream 8, Red Hat (RHEL) 8.5 and Rocky Linux 8.5. Installing MariaDB is almost same process than install MySQL.
Note: If you are moving from MySQL, then make sure that you backup...
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.
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?
Hi Minna,
Could you post output of following command:
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.
Thanks for pointing this out, it is actually old syntax and I fixed once all guides, but some reason this one was still wrong.
Super! well detailed steps.
Dang man, why didn’t I find this,.. 20 years or so ago when I was first playing around with Linux and database related things. This is certainly a bookmark worthy site. (especially when you’re loosing your memory slowly)