1. need to create directory for it
2. set the right owner
3. add it to config and restart mysql/mariadb

mkdir -pv /var/lib/mysql/own_tmp;chown -R mysql:mysql /var/lib/mysql/own_tmp; echo -e "tmpdir = /var/lib/mysql/own_tmp" >> /etc/my.cnf; service mariadb restart