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;
阅读(689) | 评论(0) | 转发(0) |