====
If you do not have any /tmp partition you will need to follow the directions below to create and mount a partition.
Create a 190Mb partition
shell: cd /dev/; dd if=/dev/zero of=tmpMnt bs=1024 count=200000
Format the partition
shell: mke2fs /dev/tmpMnt
Make a backup of the old data
shell: cp -Rp /tmp /tmp_backup
Mount the temp filesystem
shell: mount -o loop,noexec,nosuid,rw /dev/tmpMnt /tmp
Set the permissions
shell: chmod 1777 /tmp
Copy the old files back
shell: cp -Rp /tmp_backup/* /tmp/
Once you do that go ahead and start mysql and make sure it works ok.
If it does you can add this line to the bottom of the /etc/fstab to automatically have it mounted:
/dev/tmpMnt /tmp ext2 loop,noexec,nosuid,rw 0 0
While we are at it we are going to secure /dev/shm. Look for the mount line for /dev/shm and change it to the following:
none /dev/shm tmpfs noexec,nosuid 0 0
Umount and remount /dev/shm for the changes to take effect.
shell: umount /dev/shm
shell: mount /dev/shm
If everything still works fine you can go ahead and delete the /tmp_backup directory.
shell: rm -rf /tmp_backup
====
