mysql當機問題：Failed to start LSB: start and stop MariaDB.

因mysql環境問題導緻資料庫當機系統連結錯誤解決

剛才協助客戶解了一下Centos系統下mysql當機問題，在寶塔下試了幾次沒啟動成功，查了一下mysql資料庫的相關配置發現裝了2套mysql,都使用着用ln軟連結互相關聯着，有一套居然沒有初始化，解決方案:

1.将其中1套初始化啟動即可

2.将真正的mysql的初始檔案複制或引到啟動的mysql啟動即可

mysql資料庫錯誤提示如下:

2022-10-29 12:59:02 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool

2022-10-29 12:59:02 0 [Note] InnoDB: Buffer pool(s) load completed at 221029 12:59:02

2022-10-29 12:59:02 0 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.db' doesn't exist

2022-10-29 12:59:02 0 [ERROR] Aborting

2022-10-29 13:02:59 0 [Note] InnoDB: Using Linux native AIO

2022-10-29 13:02:59 0 [Note] InnoDB: Uses event mutexes

2022-10-29 13:02:59 0 [Note] InnoDB: Compressed tables use zlib 1.2.7

2022-10-29 13:02:59 0 [Note] InnoDB: Number of pools: 1

2022-10-29 13:02:59 0 [Note] InnoDB: Using SSE4.2 crc32 instructions

2022-10-29 13:02:59 0 [Note] mariadbd: O_TMPFILE is not supported on /tmp (disabling future attempts)

2022-10-29 13:02:59 0 [Note] InnoDB: Initializing buffer pool, total size = 134217728, chunk size = 134217728

2022-10-29 13:02:59 0 [Note] InnoDB: Completed initialization of buffer pool

2022-10-29 13:02:59 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().

2022-10-29 13:02:59 0 [Note] InnoDB: 128 rollback segments are active.

2022-10-29 13:02:59 0 [Note] InnoDB: Creating shared tablespace for temporary tables

2022-10-29 13:02:59 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...

2022-10-29 13:02:59 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.

2022-10-29 13:02:59 0 [Note] InnoDB: 10.5.6 started; log sequence number 35593; transaction id 9

2022-10-29 13:02:59 0 [Note] Plugin 'FEEDBACK' is disabled.

2022-10-29 13:02:59 0 [ERROR] Could not open mysql.plugin table: "Table 'mysql.plugin' doesn't exist". Some plugins may be not loaded

2022-10-29 13:02:59 0 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist

2022-10-29 13:02:59 0 [Note] Server socket created on IP: '::'.

2022-10-29 13:02:59 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool

2022-10-29 13:02:59 0 [Note] InnoDB: Buffer pool(s) load completed at 221029 13:02:59

2022-10-29 13:02:59 0 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.db' doesn't exist

2022-10-29 13:02:59 0 [ERROR] Aborting