Can't create/write to file '/tmp/#sql_909_0.MYI' (Errcode: 13)

mysql> desc tablename; 

ERROR 1 (HY000): Can't create/write to file '/tmp/#sql_909_0.MYI' (Errcode: 13)

1mysql> desc cmstop_picture;

2ERROR 1 (HY000): Can't create/write to file '/tmp/#sql_909_0.MYI' (Errcode: 13)

解决办法：

1#mkdir /var/lib/mysql/tmp

2#chown mysql.mysql /var/lib/mysql/tmp

3#vi /etc/my.cnf  add [mysqld] tmpdir = /var/lib/mysql/tmp

4#/etc/init.d/mysqld restart