mysql> desc tablename; ERROR 1 (HY000): Can't create/write to file '/tmp/#sql_909_0.MYI'

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

1	mysql> desc cmstop_picture;

2	ERROR 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