开发者社区> 问答> 正文

mysql 安装的时候报错?报错

安装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# 

展开
收起
爱吃鱼的程序员 2020-06-22 20:00:29 511 0
1 条回答
写回答
取消 提交回答
  • https://developer.aliyun.com/profile/5yerqm5bn5yqg?spm=a2c6h.12873639.0.0.6eae304abcjaIB

    tmp 权限的问题吧。

    chownroot:root/tmpchmod1777/tmp

    这个权限我设置了,没有问题啊 TheInnoDBmemoryheapisdisabled  这句是说内存不够么 ?http://www.2hand.cn/977.html

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

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

    查下mysqlbin目录,指定basedir看看检查一下/tmp/ib50RNsu这个文件是否存在,如果存在他的所有用户是否是mysql

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

    #chownroot:root/tmp
    #chmod1777/tmp
    #/etc/init.d/mysqldstart

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

    我也是同样的问题,把socket=/var/lib/mysql/mysql.sock设置就ok了。还是权限的问题,没有试修改/tmp的用户
    2020-06-22 20:00:46
    赞同 展开评论 打赏
问答排行榜
最热
最新

相关电子书

更多
搭建电商项目架构连接MySQL 立即下载
搭建4层电商项目架构,实战连接MySQL 立即下载
PolarDB MySQL引擎重磅功能及产品能力盛大发布 立即下载

相关镜像