这个是报错的原因:
2024-02-04T13:22:09.821051Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.36-0ubuntu0.20.04.1) starting as process 7845 2024-02-04T13:22:09.822289Z 0 [Warning] [MY-010122] [Server] One can only use the --user switch if running as root mysqld: File './binlog.index' not found (OS errno 13 - Permission denied) 2024-02-04T13:22:09.822714Z 0 [ERROR] [MY-010119] [Server] Aborting 2024-02-04T13:22:09.822804Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.36-0ubuntu0.20.04.1) (Ubuntu). 2024-02-04T13:22:10.299548Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.36-0ubuntu0.20.04.1) starting as process 7854 2024-02-04T13:22:10.300784Z 0 [Warning] [MY-010122] [Server] One can only use the --user switch if running as root mysqld: File './binlog.index' not found (OS errno 13 - Permission denied) 2024-02-04T13:22:10.301185Z 0 [ERROR] [MY-010119] [Server] Aborting 2024-02-04T13:22:10.301273Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.36-0ubuntu0.20.04.1) (Ubuntu).
报错原因查看日志,我的日志目录是/var/log/mysql/error.log,因人而异
解决方法:
根据日志信息,MySQL 启动失败的原因是权限被拒绝。具体来说,错误信息中提到了文件 './binlog.index' 权限被拒绝。这个问题可能是由于 MySQL 数据目录的权限设置不正确导致的。请确保 MySQL 数据目录及其文件的所有者和权限设置正确。
-
确认 MySQL 数据目录的所有者和所属组是否为 MySQL 用户或者具有读写权限的用户。可以使用以下命令修改:sudo chown -R mysql:mysql /var/lib/mysql
-
确认 MySQL 数据目录及其子目录的权限是否正确。可以使用以下命令修改:sudo chmod -R 755 /var/lib/mysql
-
如果上诉的都失败了,可以尝试新建一个二进制日志文件:①sudo touch /var/lib/mysql/binlog.index;②sudo chown mysql:mysql /var/lib/mysql/binlog.index;③sudo chmod 644 /var/lib/mysql/binlog.index