This article covers how to resolve the above maiadb problem "Job for mariadb.service failed because the control process exited with error code" which may arise during the installation of #MariaDB on #CentOS 8.
The /var/lib/mysql directory is not empty when MariaDB is installed, it contains e.g. the 'mysql' database and some other files.
Recreating the folder, even with correct permissions, will not help you.
Either MariaDB has not been successfully installed or the directory was removed. Reinstall MariaDB to get a working basic database system back.
Also, you can give access /var/log/mysql/* to mysql by running the command:
sudo chown mysql:mysql /var/log/mysql/*
MariaDB offers more and better storage engines, NoSQL support, provided by Cassandra, allows you to run SQL and NoSQL in a single database system.
MariaDB also supports TokuDB, which can handle big data for large organizations and corporate users.
To view mysql error logs:
1. edit /etc/my.cnf [mysqld] log=/tmp/mysql.log.
2. restart the computer or the mysqld service service mysqld restart.
3. open phpmyadmin/any application that uses mysql/mysql console and run a query.
4. cat /tmp/mysql.log ( you should see the query )