How to redirect non-SSL/HTTP requests for Mailman to SSL/HTTPS

Create a custom .htaccess file for Mailman, as seen below:
Code:

# touch /usr/local/cpanel/3rdparty/mailman/cgi-bin/.htaccess
# chown -vv mailman:mailman /usr/local/cpanel/3rdparty/mailman/cgi-bin/.htaccess


Enter the following contents into the custom .htaccess file:
Code:
RewriteEngine On
RewriteCond %{HTTPS} off
RewriteRule (.*) https://%{HTTP_HOST}%{REQUEST_URI}

How to change the temp directory of Mysql

Add the below line in your my.cnf file and restart the mysql
tmpdir = /path/to/mysqltempdirectory