I have installed Debian Lenny, PHPmyadmin and postfix.
When using PHPmyadmin GUI and access any table with data i get:
Can't create/write to file '/tmp/#sql_xxxx.MYI' (Errcode: 13)
doing perror 13 says:
OS error code 13: Permission denied
I find the tmpdir lik so:
mysqladmin -p variables | grep -w tmpdir | tmpdir | /tmp
Now that means that mysql cannot write to /tmp. Making the permissions to :777 fixes that. But I doesn't feel right I have to do that. Is there a better way/fix?
Should I change the value tmpdir in /etc/mysql/my.cnf?