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)

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#chownmysql.mysql /var/lib/mysql/tmp

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

4#/etc/init.d/mysqld restart