This howto post focuses on configuring the MariaDB user authentication using active directory. For the example in this post, we have used a CentOS 7.5 system. Follow the steps as given below: 1. In order to configure MariaDB to authenticate users against AD, first make sure the system is configured as an AD client as per the post below: How to connect to an Active Directory Domain using Realmd (Configure CentOS/RHEL 7 as active directory client) 2. Install MariaDB packages. # yum install … [Read more...] about How to configure MariaDB database to use Active Directory for user authentication in CentOS/RHEL 7
MariaDB
/var/tmp file system getting full due to Mariadb
By default MariaDB will create temporary table structure in /var/tmp and this fills up space of root file system(https://cdn.thegeekdiary.com/). We can change default setting by assigning a custom temp directory in '[mysqld]' section in my.cnf file. MariaDB creates temporary table structure in tmpdir(/var/tmp) directory when there are huge/bulk inserts into table. By default, MariaDB will create temporary table structure in /var/tmp directory. To change the default setting, add a variable tmpdir in [mysqld] section in … [Read more...] about /var/tmp file system getting full due to Mariadb
How to run MariaDB as a custom user and group other than mysql on CentOS / RHEL 7
So the requirement here is, we do not want to run MariaDB as the mysql user and group which is the default. We will see how we can configure MariaDB to run as a custom user and group other than mysql. Note: Many steps are required to permanently change the user and/or group under which MariaDB runs, in a way that survives updates of the mariadb-server package. Handle with care and make a backup first. 1. Stop MariaDB if it is running. # systemctl stop mariadb 2. Add the desired user … [Read more...] about How to run MariaDB as a custom user and group other than mysql on CentOS / RHEL 7
How to install and configure MariaDB in CentOS / RHEL 7
MariaDB is the default implementation of MySQL in Red Hat Enterprise Linux 7. MariaDB is a community-developed fork of the MySQL database project, and provides a replacement for MySQL. Installing MariaDB 1. As the MariaDB Database Management System (DBMS) is not installed by default on RHEL/CentOS 7, we will start this recipe by installing the required packages. # yum install -y mariadb mariadb-server Here, mariadb-server - is the MariaDB server package mariadb - is the client shell … [Read more...] about How to install and configure MariaDB in CentOS / RHEL 7