项目测试mysql数据导入功能,所以自己搭建数据库服务器,测试产品功能。在安装导入的过程中遇到了大量问题,最终一一解决,在自己记录下自己解决问题的过程,可供参考。
一、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