关于ERROR! The server quit without updating PID file问题

Question

出现图片中的问题，麻烦老师帮忙看看
mysql-error.log如下

2021-02-02T02:36:49.226896Z 0 [Warning] [MY-011070] [Server] 'Disabling symbolic links using --skip-symbolic-links (or equivalent) is the default. Consider not using this option as it' is deprecated and will be removed in a future release.
2021-02-02T02:36:49.227214Z 0 [Warning] [MY-011069] [Server] The syntax '--master-info-repository' is deprecated and will be removed in a future release.
2021-02-02T02:36:49.227233Z 0 [Warning] [MY-011069] [Server] The syntax '--relay-log-info-repository' is deprecated and will be removed in a future release.
2021-02-02T02:36:49.227461Z 0 [Warning] [MY-010086] [Server] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2021-02-02T02:36:49.227588Z 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.
2021-02-02T02:36:49.228149Z 0 [System] [MY-013169] [Server] /usr/local/mysql/bin/mysqld (mysqld 8.0.23) initializing of server in progress as process 17952
2021-02-02T02:36:49.234790Z 0 [Warning] [MY-013242] [Server] --character-set-server: 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
2021-02-02T02:36:49.286634Z 0 [Warning] [MY-013267] [InnoDB] The setting INNODB_UNDO_TABLESPACES is deprecated and is no longer used.  InnoDB always creates 2 undo tablespaces to start with. If you need more, please use CREATE UNDO TABLESPACE.
2021-02-02T02:36:49.301962Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2021-02-02T02:36:54.928627Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2021-02-02T02:36:56.892492Z 0 [ERROR] [MY-010147] [Server] Too many arguments (first extra is 'basedir=/usr/local/mysql').
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 [System] [MY-010910] [Server] /usr/local/mysql/bin/mysqld: Shutdown complete (mysqld 8.0.23)  MySQL Community Server - GPL.
2021-02-02T02:39:40.635555Z 0 [Warning] [MY-011070] [Server] 'Disabling symbolic links using --skip-symbolic-links (or equivalent) is the default. Consider not using this option as it' is deprecated and will be removed in a future release.
2021-02-02T02:39:40.635618Z 0 [Warning] [MY-011069] [Server] The syntax '--master-info-repository' is deprecated and will be removed in a future release.
2021-02-02T02:39:40.635628Z 0 [Warning] [MY-011069] [Server] The syntax '--relay-log-info-repository' is deprecated and will be removed in a future release.
2021-02-02T02:39:40.635674Z 0 [Warning] [MY-010086] [Server] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2021-02-02T02:39:40.635694Z 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.
2021-02-02T02:39:40.638486Z 0 [Warning] [MY-010101] [Server] Insecure configuration for --secure-file-priv: Location is accessible to all OS users. Consider choosing a different directory.
2021-02-02T02:39:40.638575Z 0 [System] [MY-010116] [Server] /usr/local/mysql/bin/mysqld (mysqld 8.0.23) starting as process 18956
2021-02-02T02:39:40.639957Z 0 [Warning] [MY-013242] [Server] --character-set-server: 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
2021-02-02T02:39:40.650465Z 0 [Warning] [MY-013267] [InnoDB] The setting INNODB_UNDO_TABLESPACES is deprecated and is no longer used.  InnoDB always creates 2 undo tablespaces to start with. If you need more, please use CREATE UNDO TABLESPACE.
2021-02-02T02:39:40.652786Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2021-02-02T02:39:41.618710Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
mysqld: Table 'mysql.plugin' doesn't exist
2021-02-02T02:39:42.046757Z 0 [ERROR] [MY-010735] [Server] Could not open the mysql.plugin table. Please perform the MySQL upgrade procedure.
2021-02-02T02:39:42.047637Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables
2021-02-02T02:39:42.048342Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables
2021-02-02T02:39:42.049045Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables
2021-02-02T02:39:42.049727Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables
2021-02-02T02:39:42.050394Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables
2021-02-02T02:39:42.051060Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables
2021-02-02T02:39:42.051701Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables
2021-02-02T02:39:42.056939Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33060, socket: /tmp/mysqlx.sock
2021-02-02T02:39:42.200128Z 0 [Warning] [MY-010015] [Repl] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2021-02-02T02:39:42.216256Z 0 [Warning] [MY-010015] [Repl] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2021-02-02T02:39:42.219565Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2021-02-02T02:39:42.219945Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2021-02-02T02:39:42.224032Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables
2021-02-02T02:39:42.224654Z 0 [ERROR] [MY-013129] [Server] A message intended for a client cannot be sent there as no client-session is attached. Therefore, we're sending the information to the error-log instead: MY-001146 - Table 'mysql.component' doesn't exist
2021-02-02T02:39:42.225066Z 0 [Warning] [MY-013129] [Server] A message intended for a client cannot be sent there as no client-session is attached. Therefore, we're sending the information to the error-log instead: MY-003543 - The mysql.component table is missing or has an incorrect definition.
2021-02-02T02:39:42.226233Z 0 [ERROR] [MY-010326] [Server] Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist
2021-02-02T02:39:42.226690Z 0 [ERROR] [MY-010952] [Server] The privilege system failed to initialize correctly. For complete instructions on how to upgrade MySQL to a new version please see the 'Upgrading MySQL' section from the MySQL manual.
2021-02-02T02:39:42.227494Z 0 [ERROR] [MY-010119] [Server] Aborting
2021-02-02T02:39:43.592462Z 0 [System] [MY-010910] [Server] /usr/local/mysql/bin/mysqld: Shutdown complete (mysqld 8.0.23)  MySQL Community Server - GPL.
2021-02-02T02:41:56.579827Z 0 [Warning] [MY-011070] [Server] 'Disabling symbolic links using --skip-symbolic-links (or equivalent) is the default. Consider not using this option as it' is deprecated and will be removed in a future release.
2021-02-02T02:41:56.580069Z 0 [Warning] [MY-011069] [Server] The syntax '--master-info-repository' is deprecated and will be removed in a future release.
2021-02-02T02:41:56.580088Z 0 [Warning] [MY-011069] [Server] The syntax '--relay-log-info-repository' is deprecated and will be removed in a future release.
2021-02-02T02:41:56.580271Z 0 [Warning] [MY-010086] [Server] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2021-02-02T02:41:56.580327Z 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.
2021-02-02T02:41:56.581498Z 0 [System] [MY-013169] [Server] /usr/local/mysql/bin/mysqld (mysqld 8.0.23) initializing of server in progress as process 19080
2021-02-02T02:41:56.585545Z 0 [Warning] [MY-013242] [Server] --character-set-server: 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
2021-02-02T02:41:56.587721Z 0 [ERROR] [MY-010457] [Server] --initialize specified but the data directory has files in it. Aborting.
2021-02-02T02:41:56.587833Z 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:41:56.588325Z 0 [ERROR] [MY-010119] [Server] Aborting
2021-02-02T02:41:56.588929Z 0 [System] [MY-010910] [Server] /usr/local/mysql/bin/mysqld: Shutdown complete (mysqld 8.0.23)  MySQL Community Server - GPL.
2021-02-02T02:42:26.108847Z 0 [Warning] [MY-011070] [Server] 'Disabling symbolic links using --skip-symbolic-links (or equivalent) is the default. Consider not using this option as it' is deprecated and will be removed in a future release.
2021-02-02T02:42:26.108908Z 0 [Warning] [MY-011069] [Server] The syntax '--master-info-repository' is deprecated and will be removed in a future release.
2021-02-02T02:42:26.108917Z 0 [Warning] [MY-011069] [Server] The syntax '--relay-log-info-repository' is deprecated and will be removed in a future release.
2021-02-02T02:42:26.108965Z 0 [Warning] [MY-010086] [Server] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2021-02-02T02:42:26.108985Z 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.
2021-02-02T02:42:26.110570Z 0 [Warning] [MY-010101] [Server] Insecure configuration for --secure-file-priv: Location is accessible to all OS users. Consider choosing a different directory.
2021-02-02T02:42:26.110654Z 0 [System] [MY-010116] [Server] /usr/local/mysql/bin/mysqld (mysqld 8.0.23) starting as process 20019
2021-02-02T02:42:26.111732Z 0 [Warning] [MY-013242] [Server] --character-set-server: 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
2021-02-02T02:42:26.119103Z 0 [Warning] [MY-013267] [InnoDB] The setting INNODB_UNDO_TABLESPACES is deprecated and is no longer used.  InnoDB always creates 2 undo tablespaces to start with. If you need more, please use CREATE UNDO TABLESPACE.
2021-02-02T02:42:26.121149Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2021-02-02T02:42:27.040760Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
mysqld: Table 'mysql.plugin' doesn't exist
2021-02-02T02:42:27.354982Z 0 [ERROR] [MY-010735] [Server] Could not open the mysql.plugin table. Please perform the MySQL upgrade procedure.
2021-02-02T02:42:27.355836Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables
2021-02-02T02:42:27.356544Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables
2021-02-02T02:42:27.357237Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables
2021-02-02T02:42:27.357915Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables
2021-02-02T02:42:27.358580Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables
2021-02-02T02:42:27.359248Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables
2021-02-02T02:42:27.360054Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables
2021-02-02T02:42:27.363090Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33060, socket: /tmp/mysqlx.sock
2021-02-02T02:42:27.462280Z 0 [Warning] [MY-010015] [Repl] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2021-02-02T02:42:27.476239Z 0 [Warning] [MY-010015] [Repl] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2021-02-02T02:42:27.479270Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2021-02-02T02:42:27.479660Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2021-02-02T02:42:27.482965Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables
2021-02-02T02:42:27.483603Z 0 [ERROR] [MY-013129] [Server] A message intended for a client cannot be sent there as no client-session is attached. Therefore, we're sending the information to the error-log instead: MY-001146 - Table 'mysql.component' doesn't exist
2021-02-02T02:42:27.483987Z 0 [Warning] [MY-013129] [Server] A message intended for a client cannot be sent there as no client-session is attached. Therefore, we're sending the information to the error-log instead: MY-003543 - The mysql.component table is missing or has an incorrect definition.
2021-02-02T02:42:27.485130Z 0 [ERROR] [MY-010326] [Server] Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist
2021-02-02T02:42:27.485588Z 0 [ERROR] [MY-010952] [Server] The privilege system failed to initialize correctly. For complete instructions on how to upgrade MySQL to a new version please see the 'Upgrading MySQL' section from the MySQL manual.
2021-02-02T02:42:27.486416Z 0 [ERROR] [MY-010119] [Server] Aborting
2021-02-02T02:42:28.895902Z 0 [System] [MY-010910] [Server] /usr/local/mysql/bin/mysqld: Shutdown complete (mysqld 8.0.23)  MySQL Community Server - GPL.
2021-02-02T02:44:41.231904Z 0 [Warning] [MY-011070] [Server] 'Disabling symbolic links using --skip-symbolic-links (or equivalent) is the default. Consider not using this option as it' is deprecated and will be removed in a future release.
2021-02-02T02:44:41.231962Z 0 [Warning] [MY-011069] [Server] The syntax '--master-info-repository' is deprecated and will be removed in a future release.
2021-02-02T02:44:41.231972Z 0 [Warning] [MY-011069] [Server] The syntax '--relay-log-info-repository' is deprecated and will be removed in a future release.
2021-02-02T02:44:41.232038Z 0 [Warning] [MY-010086] [Server] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2021-02-02T02:44:41.232059Z 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.
2021-02-02T02:44:41.233641Z 0 [Warning] [MY-010101] [Server] Insecure configuration for --secure-file-priv: Location is accessible to all OS users. Consider choosing a different directory.
2021-02-02T02:44:41.233729Z 0 [System] [MY-010116] [Server] /usr/local/mysql/bin/mysqld (mysqld 8.0.23) starting as process 21031
2021-02-02T02:44:41.234857Z 0 [Warning] [MY-013242] [Server] --character-set-server: 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
2021-02-02T02:44:41.242200Z 0 [Warning] [MY-013267] [InnoDB] The setting INNODB_UNDO_TABLESPACES is deprecated and is no longer used.  InnoDB always creates 2 undo tablespaces to start with. If you need more, please use CREATE UNDO TABLESPACE.
2021-02-02T02:44:41.244208Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2021-02-02T02:44:42.160155Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
mysqld: Table 'mysql.plugin' doesn't exist
2021-02-02T02:44:42.472143Z 0 [ERROR] [MY-010735] [Server] Could not open the mysql.plugin table. Please perform the MySQL upgrade procedure.
2021-02-02T02:44:42.472963Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables
2021-02-02T02:44:42.473714Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables
2021-02-02T02:44:42.474437Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables
2021-02-02T02:44:42.475144Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables
2021-02-02T02:44:42.475785Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables
2021-02-02T02:44:42.476465Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables
2021-02-02T02:44:42.477123Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables
2021-02-02T02:44:42.480213Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33060, socket: /tmp/mysqlx.sock
2021-02-02T02:44:42.577712Z 0 [Warning] [MY-010015] [Repl] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2021-02-02T02:44:42.591317Z 0 [Warning] [MY-010015] [Repl] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2021-02-02T02:44:42.594455Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2021-02-02T02:44:42.594848Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2021-02-02T02:44:42.598266Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables
2021-02-02T02:44:42.598886Z 0 [ERROR] [MY-013129] [Server] A message intended for a client cannot be sent there as no client-session is attached. Therefore, we're sending the information to the error-log instead: MY-001146 - Table 'mysql.component' doesn't exist
2021-02-02T02:44:42.599298Z 0 [Warning] [MY-013129] [Server] A message intended for a client cannot be sent there as no client-session is attached. Therefore, we're sending the information to the error-log instead: MY-003543 - The mysql.component table is missing or has an incorrect definition.
2021-02-02T02:44:42.600422Z 0 [ERROR] [MY-010326] [Server] Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist
2021-02-02T02:44:42.600883Z 0 [ERROR] [MY-010952] [Server] The privilege system failed to initialize correctly. For complete instructions on how to upgrade MySQL to a new version please see the 'Upgrading MySQL' section from the MySQL manual.
2021-02-02T02:44:42.601710Z 0 [ERROR] [MY-010119] [Server] Aborting
2021-02-02T02:44:44.021090Z 0 [System] [MY-010910] [Server] /usr/local/mysql/bin/mysqld: Shutdown complete (mysqld 8.0.23)  MySQL Community Server - GPL.
2021-02-02T02:49:39.882747Z 0 [Warning] [MY-011070] [Server] 'Disabling symbolic links using --skip-symbolic-links (or equivalent) is the default. Consider not using this option as it' is deprecated and will be removed in a future release.
2021-02-02T02:49:39.882951Z 0 [Warning] [MY-011069] [Server] The syntax '--master-info-repository' is deprecated and will be removed in a future release.
2021-02-02T02:49:39.882967Z 0 [Warning] [MY-011069] [Server] The syntax '--relay-log-info-repository' is deprecated and will be removed in a future release.
2021-02-02T02:49:39.883193Z 0 [Warning] [MY-010086] [Server] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2021-02-02T02:49:39.883251Z 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.
2021-02-02T02:49:39.883533Z 0 [System] [MY-013169] [Server] /usr/local/mysql/bin/mysqld (mysqld 8.0.23) initializing of server in progress as process 21106
2021-02-02T02:49:39.889439Z 0 [Warning] [MY-013242] [Server] --character-set-server: 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
2021-02-02T02:49:39.892351Z 0 [ERROR] [MY-010457] [Server] --initialize specified but the data directory has files in it. Aborting.
2021-02-02T02:49:39.892494Z 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:49:39.893040Z 0 [ERROR] [MY-010119] [Server] Aborting
2021-02-02T02:49:39.893712Z 0 [System] [MY-010910] [Server] /usr/local/mysql/bin/mysqld: Shutdown complete (mysqld 8.0.23)  MySQL Community Server - GPL.
2021-02-02T02:51:17.856035Z 0 [Warning] [MY-011070] [Server] 'Disabling symbolic links using --skip-symbolic-links (or equivalent) is the default. Consider not using this option as it' is deprecated and will be removed in a future release.
2021-02-02T02:51:17.856173Z 0 [Warning] [MY-011069] [Server] The syntax '--master-info-repository' is deprecated and will be removed in a future release.
2021-02-02T02:51:17.856184Z 0 [Warning] [MY-011069] [Server] The syntax '--relay-log-info-repository' is deprecated and will be removed in a future release.
2021-02-02T02:51:17.856306Z 0 [Warning] [MY-010086] [Server] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2021-02-02T02:51:17.856344Z 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.
2021-02-02T02:51:17.856537Z 0 [System] [MY-013169] [Server] /usr/local/mysql/bin/mysqld (mysqld 8.0.23) initializing of server in progress as process 1657
2021-02-02T02:51:17.859405Z 0 [Warning] [MY-013242] [Server] --character-set-server: 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
2021-02-02T02:51:17.860901Z 0 [ERROR] [MY-010457] [Server] --initialize specified but the data directory has files in it. Aborting.
2021-02-02T02:51:17.860978Z 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:51:17.861677Z 0 [ERROR] [MY-010119] [Server] Aborting
2021-02-02T02:51:17.862117Z 0 [System] [MY-010910] [Server] /usr/local/mysql/bin/mysqld: Shutdown complete (mysqld 8.0.23)  MySQL Community Server - GPL.
2021-02-02T02:58:10.091557Z 0 [Warning] [MY-011070] [Server] 'Disabling symbolic links using --skip-symbolic-links (or equivalent) is the default. Consider not using this option as it' is deprecated and will be removed in a future release.
2021-02-02T02:58:10.091802Z 0 [Warning] [MY-011069] [Server] The syntax '--master-info-repository' is deprecated and will be removed in a future release.
2021-02-02T02:58:10.091822Z 0 [Warning] [MY-011069] [Server] The syntax '--relay-log-info-repository' is deprecated and will be removed in a future release.
2021-02-02T02:58:10.092004Z 0 [Warning] [MY-010086] [Server] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2021-02-02T02:58:10.092062Z 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.
2021-02-02T02:58:10.093319Z 0 [System] [MY-013169] [Server] /usr/local/mysql/bin/mysqld (mysqld 8.0.23) initializing of server in progress as process 2656
2021-02-02T02:58:10.097490Z 0 [Warning] [MY-013242] [Server] --character-set-server: 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
2021-02-02T02:58:10.142858Z 0 [Warning] [MY-013267] [InnoDB] The setting INNODB_UNDO_TABLESPACES is deprecated and is no longer used.  InnoDB always creates 2 undo tablespaces to start with. If you need more, please use CREATE UNDO TABLESPACE.
2021-02-02T02:58:10.164107Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2021-02-02T02:58:13.211772Z 1 [ERROR] [MY-013039] [InnoDB] Can't create UNDO tablespace innodb_undo_001  since '/usr/local/mysql/undo/undo_001' already exists.
2021-02-02T02:58:13.212586Z 1 [ERROR] [MY-012929] [InnoDB] InnoDB Database creation was aborted with error Generic error. You may need to delete the ibdata1 file before trying to start up again.
2021-02-02T02:58:13.667555Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2021-02-02T02:58:13.668200Z 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:58:13.669087Z 0 [ERROR] [MY-010119] [Server] Aborting
2021-02-02T02:58:13.670903Z 0 [System] [MY-010910] [Server] /usr/local/mysql/bin/mysqld: Shutdown complete (mysqld 8.0.23)  MySQL Community Server - GPL.
2021-02-02T02:58:36.282981Z 0 [Warning] [MY-011070] [Server] 'Disabling symbolic links using --skip-symbolic-links (or equivalent) is the default. Consider not using this option as it' is deprecated and will be removed in a future release.
2021-02-02T02:58:36.283042Z 0 [Warning] [MY-011069] [Server] The syntax '--master-info-repository' is deprecated and will be removed in a future release.
2021-02-02T02:58:36.283052Z 0 [Warning] [MY-011069] [Server] The syntax '--relay-log-info-repository' is deprecated and will be removed in a future release.
2021-02-02T02:58:36.283098Z 0 [Warning] [MY-010086] [Server] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2021-02-02T02:58:36.283117Z 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.
2021-02-02T02:58:36.285667Z 0 [Warning] [MY-010101] [Server] Insecure configuration for --secure-file-priv: Location is accessible to all OS users. Consider choosing a different directory.
2021-02-02T02:58:36.285760Z 0 [System] [MY-010116] [Server] /usr/local/mysql/bin/mysqld (mysqld 8.0.23) starting as process 3637
2021-02-02T02:58:36.287153Z 0 [Warning] [MY-013242] [Server] --character-set-server: 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
2021-02-02T02:58:36.300009Z 0 [Warning] [MY-013267] [InnoDB] The setting INNODB_UNDO_TABLESPACES is deprecated and is no longer used.  InnoDB always creates 2 undo tablespaces to start with. If you need more, please use CREATE UNDO TABLESPACE.
2021-02-02T02:58:36.302290Z 1 [ERROR] [MY-011011] [Server] Failed to find valid data directory.
2021-02-02T02:58:36.302456Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2021-02-02T02:58:36.302545Z 0 [ERROR] [MY-010119] [Server] Aborting
2021-02-02T02:58:36.303061Z 0 [System] [MY-010910] [Server] /usr/local/mysql/bin/mysqld: Shutdown complete (mysqld 8.0.23)  MySQL Community Server - GPL.
2021-02-02T03:00:20.061987Z 0 [Warning] [MY-011070] [Server] 'Disabling symbolic links using --skip-symbolic-links (or equivalent) is the default. Consider not using this option as it' is deprecated and will be removed in a future release.
2021-02-02T03:00:20.062057Z 0 [Warning] [MY-011069] [Server] The syntax '--master-info-repository' is deprecated and will be removed in a future release.
2021-02-02T03:00:20.062066Z 0 [Warning] [MY-011069] [Server] The syntax '--relay-log-info-repository' is deprecated and will be removed in a future release.
2021-02-02T03:00:20.062114Z 0 [Warning] [MY-010086] [Server] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2021-02-02T03:00:20.062134Z 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.
2021-02-02T03:00:20.063561Z 0 [Warning] [MY-010101] [Server] Insecure configuration for --secure-file-priv: Location is accessible to all OS users. Consider choosing a different directory.
2021-02-02T03:00:20.063643Z 0 [System] [MY-010116] [Server] /usr/local/mysql/bin/mysqld (mysqld 8.0.23) starting as process 4586
2021-02-02T03:00:20.064708Z 0 [Warning] [MY-013242] [Server] --character-set-server: 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
2021-02-02T03:00:20.070751Z 0 [Warning] [MY-013267] [InnoDB] The setting INNODB_UNDO_TABLESPACES is deprecated and is no longer used.  InnoDB always creates 2 undo tablespaces to start with. If you need more, please use CREATE UNDO TABLESPACE.
2021-02-02T03:00:20.072827Z 1 [ERROR] [MY-011011] [Server] Failed to find valid data directory.
2021-02-02T03:00:20.072966Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2021-02-02T03:00:20.073055Z 0 [ERROR] [MY-010119] [Server] Aborting
2021-02-02T03:00:20.073546Z 0 [System] [MY-010910] [Server] /usr/local/mysql/bin/mysqld: Shutdown complete (mysqld 8.0.23)  MySQL Community Server - GPL.

Answer 1

提问者 Wonwayshon 2021-02-09 10:40:45

2021-02-09T02:36:14.931234Z 0 [Warning] [MY-011070] [Server] 'Disabling symbolic links using --skip-symbolic-links (or equivalent) is the default. Consider not using this option as it' is deprecated and will be removed in a future release.
2021-02-09T02:36:14.931387Z 0 [Warning] [MY-011069] [Server] The syntax '--master-info-repository' is deprecated and will be removed in a future release.
2021-02-09T02:36:14.931405Z 0 [Warning] [MY-011069] [Server] The syntax '--relay-log-info-repository' is deprecated and will be removed in a future release.
2021-02-09T02:36:14.931499Z 0 [Warning] [MY-010086] [Server] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2021-02-09T02:36:14.931535Z 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.
2021-02-09T02:36:14.933296Z 0 [Warning] [MY-010101] [Server] Insecure configuration for --secure-file-priv: Location is accessible to all OS users. Consider choosing a different directory.
2021-02-09T02:36:14.933440Z 0 [System] [MY-010116] [Server] /usr/local/mysql/bin/mysqld (mysqld 8.0.23) starting as process 1700
2021-02-09T02:36:14.935522Z 0 [Warning] [MY-013242] [Server] --character-set-server: 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
2021-02-09T02:36:14.947703Z 0 [Warning] [MY-013267] [InnoDB] The setting INNODB_UNDO_TABLESPACES is deprecated and is no longer used.  InnoDB always creates 2 undo tablespaces to start with. If you need more, please use CREATE UNDO TABLESPACE.
2021-02-09T02:36:14.951983Z 1 [ERROR] [MY-011011] [Server] Failed to find valid data directory.
2021-02-09T02:36:14.952304Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2021-02-09T02:36:14.952502Z 0 [ERROR] [MY-010119] [Server] Aborting
2021-02-09T02:36:14.953454Z 0 [System] [MY-010910] [Server] /usr/local/mysql/bin/mysqld: Shutdown complete (mysqld 8.0.23)  MySQL Community Server - GPL.

Answer 2

sqlercn 2021-02-02 21:38:50

这个错误是MySQL的数据目录没有初始化成功。你有按课程的内容对MySQL数据目录进行初始化吗？

• 提问者 Wonwayshon #1

  是的，因为第一次出现这个问题后尝试再重复初始化了，然后清除了data/下的内容再初始化了

• sqlercn 回复 提问者 Wonwayshon #2

  2021-02-02T02:58:13.211772Z 1 [ERROR] [MY-013039] [InnoDB] Can't create UNDO tablespace innodb_undo_001  since '/usr/local/mysql/undo/undo_001' already exists.
  2021-02-02T02:58:13.212586Z 1 [ERROR] [MY-012929] [InnoDB] InnoDB Database creation was aborted with error Generic error. You may need to delete the ibdata1 file before trying to start up again.
  2021-02-02T02:58:13.667555Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
  2021-02-02T02:58:13.668200Z 0 [ERROR] [MY-013236] [Server] The designated data directory /usr/local/mysql/data/ is unusable. 
   看以上日志，你初始化数据库时并没有删除undo目录下的日志。你要把data/  undo/  sql_log/ 目录下的内容全删除，然后再重新初始化。

• 提问者 Wonwayshon 回复 sqlercn #3

  清除后再重新初始化就一直出现这样的问题（字数限制发在回答中）看起来是data文件夹没办法设置，但是已经清空重新创建，尝试重启，修改文件夹访问权限，修改所有者所属组，创建新文件夹修改数据储存位置，最后删除了/usr/local/mysql然后重新解包从头配置，麻烦老师看看

点开查看后面1条评论