mysql 安装的时候报错

cookqq 发布于 2013/04/23 17:17
阅读 1K+
收藏 0

安装mysql,执行命令行:scripts/mysql_install_db --user=mysql包下面的错误:

ubuntu12.0.4 mysql-5.6.10-linux-glibc2.5-i686.tar.gz


root@tianbaoxing-virtual-machine:/usr/local/mysql# scripts/mysql_install_db --user=mysql

Installing MySQL system tables...2013-04-23 17:14:51 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2013-04-23 17:14:51 23738 [Note] InnoDB: The InnoDB memory heap is disabled
2013-04-23 17:14:51 23738 [Note] InnoDB: Mutexes and rw_locks use InnoDB's own implementation
2013-04-23 17:14:51 23738 [Note] InnoDB: Compressed tables use zlib 1.2.3
2013-04-23 17:14:51 23738 [Note] InnoDB: CPU does not support crc32 instructions
2013-04-23 17:14:51 23738 [Note] InnoDB: Using Linux native AIO
./bin/mysqld: Can't create/write to file '/tmp/ib50RNsu' (Errcode: 13 - Permission denied)
2013-04-23 17:14:51 b73bb700  InnoDB: Error: unable to create temporary file; errno: 13
2013-04-23 17:14:51 23738 [ERROR] Plugin 'InnoDB' init function returned error.
2013-04-23 17:14:51 23738 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2013-04-23 17:14:51 23738 [ERROR] Unknown/unsupported storage engine: InnoDB
2013-04-23 17:14:51 23738 [ERROR] Aborting


2013-04-23 17:14:51 23738 [Note] Binlog end
2013-04-23 17:14:51 23738 [Note] ./bin/mysqld: Shutdown complete


root@tianbaoxing-virtual-machine:/usr/local/mysql# 

加载中
0
李笑石
李笑石

tmp  权限的问题吧。

chown root:root /tmp
chmod 1777 /tmp

cookqq
cookqq
这个权限我设置了,没有问题啊
0
李笑石
李笑石
The InnoDB memory heap is disabled    这句是说内存不够么  ?
李笑石
李笑石
http://www.2hand.cn/977.html
0
李笑石
李笑石

http://dev.mysql.com/doc/refman/5.6/en/binary-installation.html

我比较懒  通常yum的,ubuntu下可以apt-get。上面是安装手册。参考一下。我看麻烦得很,要创建用户什么的。

0
0-1
0-1
查下mysql bin目录,指定basedir看看
0
逝水fox
逝水fox
检查一下 /tmp/ib50RNsu 这个文件是否存在,如果存在他的所有用户是否是mysql
0
hnynes
hnynes

找了下,有人有遇到你同样的问题的,解决方法就是三条命令

# chown root:root /tmp
# chmod 1777 /tmp
# /etc/init.d/mysqld start

原文地址: http://www.cyberciti.biz/faq/mysqld-innodb-error-unable-to-create-temporary-file/

0
tysailor
tysailor
我也是同样的问题,把socket=/var/lib/mysql/mysql.sock设置就ok了。还是权限的问题,没有试修改/tmp的用户
返回顶部
顶部