mysql报Can't create/write to file '/tmp/ib0n3frL' (Errcode: 13 - Permission denied)
2021/9/5 19:39:56
本文主要是介绍mysql报Can't create/write to file '/tmp/ib0n3frL' (Errcode: 13 - Permission denied),对大家解决编程问题具有一定的参考价值,需要的程序猿们随着小编来一起学习吧!
初始化数据库报错
[root@Master mysql-5.6.24]# /usr/local/mysql/scripts/mysql_install_db --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data
Installing MySQL system tables...2017-04-03 19:52:21 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2017-04-03 19:52:21 0 [Note] /usr/local/mysql/bin/mysqld (mysqld 5.6.24) starting as process 7918 ...
2017-04-03 19:52:21 7918 [Note] InnoDB: Using atomics to ref count buffer pool pages
2017-04-03 19:52:21 7918 [Note] InnoDB: The InnoDB memory heap is disabled
2017-04-03 19:52:21 7918 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2017-04-03 19:52:21 7918 [Note] InnoDB: Memory barrier is not used
2017-04-03 19:52:21 7918 [Note] InnoDB: Compressed tables use zlib 1.2.3
2017-04-03 19:52:21 7918 [Note] InnoDB: Using CPU crc32 instructions
/usr/local/mysql/bin/mysqld: Can't create/write to file '/tmp/ib0n3frL' (Errcode: 13 - Permission denied)
2017-04-03 19:52:21 7fce976e27e0 InnoDB: Error: unable to create temporary file; errno: 13
2017-04-03 19:52:21 7918 [ERROR] Plugin 'InnoDB' init function returned error.
2017-04-03 19:52:21 7918 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2017-04-03 19:52:21 7918 [ERROR] Unknown/unsupported storage engine: InnoDB
2017-04-03 19:52:21 7918 [ERROR] Aborting
2017-04-03 19:52:21 7918 [Note] Binlog end
2017-04-03 19:52:21 7918 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete
报/tmp没有权限
解决办法:
chmod 777 /tmp
再执行初始
这篇关于mysql报Can't create/write to file '/tmp/ib0n3frL' (Errcode: 13 - Permission denied)的文章就介绍到这儿,希望我们推荐的文章对大家有所帮助,也希望大家多多支持为之网!
- 2024-06-25MySQL报错Duplicate entry '0' for key 'PRIMARY'
- 2024-05-29阿里 Canal 实时同步 MySQL 增量数据至 ClickHouse 数据库
- 2024-05-24在Linux下管理MySQL的大小写敏感性
- 2024-04-26MySQL查出时间比实际晚8小时的解决方案
- 2024-04-01JPA不识别MySQL的枚举类型
- 2024-03-30mysql数据库表卡死解决方法
- 2024-03-15MySQL多数据源笔记5-ShardingJDBC实战
- 2024-03-11natural join mysql
- 2024-03-11关于VS2017,VS2015 中利用 EF使用Mysql 不显示数据源问题解决方案
- 2024-02-26mysql 阿里云xb后缀备份文件恢复-icode9专业技术文章分享