MySQL: Can’t create/write to file ‘/tmp/#sql_3c6_0.MYI’ (Errcode: 2) – What does it even mean?

I meet this error too when I run a wordpress on my Fedora system.

I googled it, and find a way to fix this.

Maybe this will help you too.

1. check mysql config : my.cnf

    cat /etc/my.cnf | grep tmpdir
   

   I can’t see anything in my my.cnf

2. add tmpdir=/tmp to my.cnf under [mysqld]

3. restart web/app and mysql server

   /etc/init.d/mysqld restart