MySQL错误1(HY000)创建文件Errcode 2时遇到问题 [英] MySQL Error 1 (HY000) Trouble creating file Errcode 2

问题描述

我在为Rails应用程序上的红宝石创建表格时遇到问题.这让我疯狂！当我尝试创建表时，将返回以下内容:

I'm having issues creating a table for my ruby on rails app. It's driving me crazy! The following is returned when I try to create the table:

错误1(HY000):无法创建/写入文件'/usr/local/mysql/data/test_development/users.MYI'(错误代码:2)

ERROR 1 (HY000): Can't create/write to file '/usr/local/mysql/data/test_development/users.MYI' (Errcode: 2)

值得一提的是，我是个新手.

It's worth mentioning I'm a total newbie, btw.

推荐答案

此

This forum post seems to deal with the same problem:

尝试以下操作:

Try the following:

1. mkdir/var/lib/mysql/tmp
2. chown mysql:mysql/var/lib/mysql/tmp
3. 将以下行添加到[mysqld]部分:tmpdir = /var/lib/mysql/tmp
4. 重新启动服务器

1. mkdir /var/lib/mysql/tmp
2. chown mysql:mysql /var/lib/mysql/tmp
3. Add the following line into the [mysqld] section: tmpdir = /var/lib/mysql/tmp
4. Restart the server

这篇关于MySQL错误1(HY000)创建文件Errcode 2时遇到问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！