Mysql server will not start. It turns green and immediately goes inactive. below is the error log.
2024-06-01T17:09:15.057868Z 0 [System] [MY-015015] [Server] MySQL Server – start.
2024-06-01T17:09:15.195876Z 0 [System] [MY-010116] [Server] /usr/local/mysql/bin/mysqld (mysqld 8.4.0) starting as process 62077
2024-06-01T17:09:15.196769Z 0 [Warning] [MY-010159] [Server] Setting lower_case_table_names=2 because file system for /usr/local/mysql/data/ is case insensitive
2024-06-01T17:09:15.200276Z 0 [ERROR] [MY-010901] [Server] Can’t open shared library ‘/usr/local/mysql/lib/plugin/keyring_file.so’ (errno: 2 dlopen(/usr/local/mysql/lib/plugin/keyring_file.so, 0x0002): tried: ‘/usr/local/mysql/lib/plugin/keyring_file.so’ (no such file)).
2024-06-01T17:09:15.200285Z 0 [ERROR] [MY-010736] [Server] Couldn’t load plugin named ‘keyring_file’ with soname ‘keyring_file.so’.
2024-06-01T17:09:15.201343Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2024-06-01T17:09:15.228660Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2024-06-01T17:09:15.257084Z 0 [ERROR] [MY-011300] [Server] Plugin mysqlx reported: ‘Setup of socket: ‘/tmp/mysqlx.sock’ failed, can’t open lock file /tmp/mysqlx.sock.lock’
2024-06-01T17:09:15.323818Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2024-06-01T17:09:15.323835Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2024-06-01T17:09:15.325329Z 0 [ERROR] [MY-010274] [Server] Could not open unix socket lock file /tmp/mysql.sock.lock.
2024-06-01T17:09:15.325337Z 0 [ERROR] [MY-010268] [Server] Unable to setup unix socket lock file.
2024-06-01T17:09:15.325342Z 0 [ERROR] [MY-010119] [Server] Aborting
2024-06-01T17:09:16.343238Z 0 [System] [MY-010910] [Server] /usr/local/mysql/bin/mysqld: Shutdown complete (mysqld 8.4.0) MySQL Community Server – GPL.
2024-06-01T17:09:16.343254Z 0 [System] [MY-015016] [Server] MySQL Server – end.