mysql 小错误解决

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

 

show errors  问题和上边差不多。 经过百度，google 找到解决方法：

 

vim /etc/my.cnf

[mysqld]

....

tmpdir=/var/lib/mysql/tmp

 

mkdir /var/lib/mysql/tmp

chown mysql:mysql /var/lib/mysql/tmp

 

over!

describe employee;