Mysql错误1005(HY000):无法创建表'tmp'(errno:13) [英] Mysql ERROR 1005 (HY000): Can't create table 'tmp' (errno: 13)
问题描述
我正在ubuntu 9.10上运行Mysql, Mysql的过程是作为root运行的,我登录到Mysql时会使用root帐户,这是我授予的所有特权,我正在使用自己的db(不是mysql),可以创建表,但是当我尝试创建表时临时表我收到此错误:
I'm Running Mysql on ubuntu 9.10, the process of Mysql is running as root, I'm using root account when logging to Mysql, which I gave all privileges, I'm using my own db(not mysql), I can create a table, but when i try to create Temporary table i get this error:
错误1005(HY000):无法创建表"tmp"(错误号:13)
ERROR 1005 (HY000): Can't create table 'tmp' (errno: 13)
此查询:
创建临时表tmp(id int);
CREATE TEMPORARY TABLE tmp (id int);
我的硬盘驱动器中有足够的空间,所有权限都被授予(var/lib/mysql也具有mysql权限).
I've plenty of space in my hard drive, all permissions are granted(also var/lib/mysql have mysql permissions).
有什么主意吗? 谢谢, 科比
Any idea? Thanks, Koby
推荐答案
好吧... 在/etc/mysql/my.cnf中,有一个"tmp"文件夹可供使用,默认情况下它是/tmp(从根目录)..并且没有mysql特权. chmod 0777/tmp可以解决问题
Well... in /etc/mysql/my.cnf there's the "tmp" folder for use which is /tmp (from root) as default.. and do not have mysql privileges. chmod 0777 /tmp will do the trick
这篇关于Mysql错误1005(HY000):无法创建表'tmp'(errno:13)的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!