生命不息,奋斗不止/创造价值-传递价值-获得价值
所谓迷茫,就是才华配不上梦想 每一个让你难堪的现在,都有一个不够努力的曾经

mysql启动不了,显示error message = ‘System schema directory does not exist.’._有问必答-CSDN问答

#mysql启动不成功查看错误日志显示
2022-02-26T08:57:37.597100Z 0 [Warning] [MY-000081] [Server] option ‘max_allowed_packet’: unsigned value 107374182400 adjusted to 1073741824.
2022-02-26T08:57:37.597178Z 0 [Warning] [MY-010915] [Server] ‘NO_ZERO_DATE’, ‘NO_ZERO_IN_DATE’ and ‘ERROR_FOR_DIVISION_BY_ZERO’ sql modes should be used with strict mode. They will be merged with strict mode in a future release.
2022-02-26T08:57:37.597266Z 0 [System] [MY-010116] [Server] /www/server/mysql/bin/mysqld (mysqld 8.0.24) starting as process 11150
2022-02-26T08:57:37.634849Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2022-02-26T08:57:37.881075Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2022-02-26T08:57:37.882114Z 1 [ERROR] [MY-013178] [Server] Execution of server-side SQL statement ‘CREATE SCHEMA mysql DEFAULT COLLATE utf8mb4_general_ci’ failed with error code = 1049, error message = ‘System schema directory does not exist.’.
2022-02-26T08:57:37.882402Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2022-02-26T08:57:37.882672Z 0 [ERROR] [MY-010119] [Server] Aborting
2022-02-26T08:57:38.403640Z 0 [System] [MY-010910] [Server] /www/server/mysql/bin/mysqld: Shutdown complete (mysqld 8.0.24) Source distribution.

解决方案:

是少了一个名字叫mysql的库,我自己在data目录下创建了一个mysql文件夹,设置好了权限,在里面创建了一个名字叫db.opt的文件,写了两行内容


default-character-set=utf8
default-collation=utf8_general_ci
然后就启动成功了!!!
总结一下吧:
碰到问题,一定要看错误日志,围绕着错误日志去解决就好了。
linux中所有的东西,都只是文件和文件夹

赞(1)
未经允许不得转载:jack361博客 » mysql启动不了,显示error message = ‘System schema directory does not exist.’._有问必答-CSDN问答

如果你爱我或恨我,请↓

联系我