MySQL 错误:无法创建/写入文件“/var/mysqltmp/#sql_1fbd_0.MYI"(错误代码:13) [英] MySQL Error : Can't create/write to file '/var/mysqltmp/#sql_1fbd_0.MYI' (Errcode: 13)

问题描述

昨天我在浏览我的 vb 论坛时遇到了错误的 getway 错误

yesterday i got bad getway error while browsing my vb forum

今天我的论坛恢复工作......但大多数链接都出现此错误

and today my forum back to work ... but most of links give this error

MySQL Error   : Can't create/write to file '/var/mysqltmp/#sql_1fbd_0.MYI' (Errcode: 13)

我搜索了类似的问题，发现这是前提问题

i search for simillar problem and got that this is premission problem

使用 FTP 帐户我没有找到这个目录 "var/mysqltmp" 所以我做了它并将权限设置为 777

using FTP account i didnt found this directory "var/mysqltmp" so i made it and set premission to 777

但问题没有解决

我读到这必须使用 Shell SSH 修复……但我没有找到关于 hoe 使用 shell SSH 的好解释，因为我是 Win Xp 用户 :(

i read that this must fixed using Shell SSH ... but i didnt found a good explain about hoe to use shell SSH , because im Win Xp user :(

这个问题可以通过 FTP 或 Cpanel 解决吗?还是服务器问题?

does this problem can be solved from FTP or Cpanel ? or its a server problem ?

提前感谢您的帮助

推荐答案

您对/tmp 的权限似乎有误.对于设置了粘性位的每个人，它们确实应该被读取/写入/执行.

It looks like your permissions on /tmp are wrong. They really should be read/write/execute for everyone with the sticky bit set.

chmod 1777/tmp

chmod 1777 /tmp

粘滞位对其他用户如何与非他们创建或拥有的文件进行交互添加了一些限制，因此无需担心.

The sticky bit add some restrictions to how other users interact with files not created or owned by them, so there's no reason to worry.

如果您愿意，您还可以创建一个由 mysql 用户拥有和可写的单独目录，并在 my.cnf 中指定要使用的目录，而不是系统范围的/tmp.

If you wish, you may also create a seperate directory owned and writeable by the mysql user and specify that directory in my.cnf to be used instead of the system wide /tmp.

这篇关于MySQL 错误:无法创建/写入文件“/var/mysqltmp/#sql_1fbd_0.MYI"(错误代码:13)的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！