问题:
2024-09-09T07:36:17.357116Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2024-09-09T07:36:17.389622Z 1 [ERROR] [MY-012526] [InnoDB] Upgrade is not supported after a crash or shutdown with innodb_fast_shutdown = 2. This redo log was created with MySQL 5.7.44, and it appears logically non empty. Please follow the instructions at http://dev.mysql.com/doc/refman/8.0/en/upgrading.html
2024-09-09T07:36:17.389653Z 1 [ERROR] [MY-012930] [InnoDB] Plugin initialization aborted with error Generic error.
2024-09-09T07:36:17.390093Z 1 [ERROR] [MY-010334] [Server] Failed to initialize DD Storage Engine
2024-09-09T07:36:17.390145Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2024-09-09T07:36:17.390160Z 0 [ERROR] [MY-010119] [Server] Aborting
2024-09-09T07:36:17.390369Z 0 [System] [MY-010910] [Server] /opt/xx/mysql@8.0/8.0.37/bin/mysqld: Shutdown complete (mysqld 8.0.37) Homebrew.
2024-09-09T07:36:17.6NZ mysqld_safe mysqld from pid file /Users/xx/Library/PhpWebStudy/server/mysql/mysql.pid ended
2024-09-09T07:38:27.6NZ mysqld_safe Logging to '/xx/server/mysql/error.log'.
2024-09-09T07:38:27.6NZ mysqld_safe Starting mysqld daemon with databases from /xx/server/mysql/data-8.0
2024-09-09T07:38:27.883234Z 0 [System] [MY-010116] [Server] /xx/mysql@8.0/8.0.37/bin/mysqld (mysqld 8.0.37) starting as process 16000
2024-09-09T07:38:27.888601Z 0 [Warning] [MY-010159] [Server] Setting lower_case_table_names=2 because file system for /xx/server/mysql/data-8.0/ is case insensitive
解决方法:
删除数据目录下
/PhpWebStudy/server/mysql/data-8.0/
rm ib_logfile0 ib_logfile1