mysql导入csv centos_CentOS7安装mysql并导入csv文件问题汇总

最新推荐文章于 2021-05-09 19:33:35 发布

当轩

最新推荐文章于 2021-05-09 19:33:35 发布

阅读量152

点赞数

文章标签： mysql导入csv centos

本文链接：https://blog.csdn.net/weixin_36488064/article/details/113225023

版权

本文总结了CentOS7上安装MySQL后启动失败的问题，通过查看日志发现是权限问题，解决方法是调整data目录的selinux类型。此外，还介绍了导入CSV文件时遇到的local_infile参数未开启的错误，开启该参数并正确设置数据导入语句后，成功导入数据。

摘要由CSDN通过智能技术生成

一、mysql安装之后启动失败，通过查看/var/log/mysqld.log日志文件报如下错误：

2018-10-17T04:29:31.727009Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.12) starting as process 1654

2018-10-17T04:29:31.738339Z 1 [ERROR] [MY-012592] [InnoDB] InnoDB: Operating system error number 13 in a file operation.

2018-10-17T04:29:31.738373Z 1 [ERROR] [MY-012595] [InnoDB] InnoDB: The error means mysqld does not have the access rights to the directory.

2018-10-17T04:29:31.738386Z 1 [ERROR] [MY-012270] [InnoDB] InnoDB: os_file_get_status() failed on './ibdata1'. Can't determine file permissions

2018-10-17T04:29:31.738406Z 1 [ERROR] [MY-010334] [Server] Failed to initialize DD Storage Engine

2018-10-17T04:29:31.738524Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.

2018-10-17T04:29:31.738549Z 0 [ERROR] [MY-010119] [Server] Aborting

查看数据库data目录权限：

关注