Solution:

mkdir /var/lib/mysql/tmp

chown mysql:mysql /var/lib/mysql/tmp

Modify the /etc/my.cnf configuration file by adding in the [mysqld] field: tmpdir = /var/lib/mysql/tmp

Restart mysqld service