mysql在查询表结构(比如desc table1;),报错:ERROR 1 (HY000): Can't create/write to file 'D:\data_3306\Temp\#sql590_1_2.MYI' (Errcode: 2 - No such file or directory)
解决方案:
1、先创建Temp文件夹,拷贝Temp文件夹的路径
2、在my.ini中添加tmpdir字段为拷贝Temp文件夹的路径,重启mysql服务
[mysqld]
tmpdir=D:\mysql_3306\Temp #指定临时文件目录
3、在执行desc table1;就成功解决问题了