针对您遇到的MySQL错误 [error] [my-013236] [server] the designated data directory /var/lib/mysql/,我们可以按照以下步骤进行排查和解决: 1. 识别错误代码和信息 错误代码 my-013236 通常指示MySQL服务器无法访问或初始化其指定的数据目录(在这个案例中是 /var/lib/mysql/)。这可能是由于多种原因造成的,包括...
日志报错: 2022-06-23T06:29:40.071157Z 0 [ERROR] [MY-010457] [Server] --initialize specified but the data directory has files in it. Aborting.2022-06-23T06:29:40.071249Z 0 [ERROR] [MY-013236] [Server] The designated data directory /hqdata/mysql/ is unusable. You can remove all files...
2024-05-14T09:21:52.008687Z 0 [ERROR] [MY-013236] [Server] The designated data directory /var/lib/mysql/ is unusable. You can remove all files that the server added to it. 2024-05-14T09:21:52.008698Z 0 [ERROR] [MY-010119] [Server] Aborting 2024-05-14T09:21:52.010143Z 0 [Syst...
2021-02-02T02:36:56.893418Z 0 [ERROR] [MY-013236] [Server] The designated data directory /usr/local/mysql/data/ is unusable. You can remove all files that the server added to it. 2021-02-02T02:36:56.894171Z 0 [ERROR] [MY-010119] [Server] Aborting 2021-02-02T02:36:58.732816Z 0 ...
If you have upgraded your server, make sure you’re executing mysql_upgrade to correct the issue. 2019-11-25T15:33:45.477857Z 0 [ERROR] [MY-013236] [Server] Newly created data directory /usr/local/mysql/data/ is unusable. You can safely remove it. 2019-11-25T15:33:45.478076Z 0 [...
MY-013169] [Server] /usr/sbin/mysqld (mysqld 8.0.27) initializing of server in progress as process 432021-11-11T20:04:03.155684Z 0 [ERROR] [MY-010457] [Server] --initialize specified but the data directory has files in it. Aborting.2021-11-11T20:04:03.155696Z 0 [ERROR] [MY-013236...
2021-03-10T09:35:53.227255Z 0 [ERROR] [MY-013236] [Server] The designated data directory C:webmysql-8.0.11data is unusable. You can remove all files that the server added to it. 博客里都说 要注释掉datadir那一行 , 然而我反而是注释了出错,不注释是对的 我的 mysql 版本是 mysql-8.0....
2022-06-23T06:29:40.071249Z 0 [ERROR] [MY-013236] [Server] The designated data directory /hqdata/mysql/ is unusable. You can remove all files that the server added to it. 2022-06-23T06:29:40.071477Z 0 [ERROR] [MY-010119] [Server] Aborting ...
2022-06-23T06:29:40.071157Z 0 [ERROR] [MY-010457] [Server] --initialize specified but the data directory has files in it. Aborting.2022-06-23T06:29:40.071249Z 0 [ERROR] [MY-013236] [Server] The designated data directory /hqdata/mysql/ is unusable. You can remove all files that the...
[ERROR] [MY-011087] [Server] Different lower_case_table_names settings for server (‘1’) and data dictionary (‘0’). [ERROR] [MY-011087] [Server] Different lower_case_table_names settings for server (‘0’) and data dictionary (‘1’). 6.参考资料: https://blog.csdn.net/vkingnew...