因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