安装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#
tmp 权限的问题吧。
http://dev.mysql.com/doc/refman/5.6/en/binary-installation.html
我比较懒 通常yum的,ubuntu下可以apt-get。上面是安装手册。参考一下。我看麻烦得很,要创建用户什么的。
找了下,有人有遇到你同样的问题的,解决方法就是三条命令
# 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/