1.重新加載配置 reload the configuration

mysql> ALTER INSTANCE RELOAD KEYRING;
ERROR 1227 (42000): Access denied; you need (at least one of) the ENCRYPTION_KEY_ADMIN privilege(s) for this operation

提示需要ENCRYPTION_KEY_ADMIN權限

重新授權

GRANT ENCRYPTION_KEY_ADMIN ON *.* TO 'root'@'%';

2.報錯信息,啟動報錯

[ERROR] [MY-012655] [InnoDB] Failed to create check sector file, errno:13 Please confirm O_DIRECT is supported and remove the file /database/check_sector_size if it exists.

問題可能出在innodb_data_home_dir配置的路徑末尾是否添加了斜杠。例如，修改配置為路徑末尾加斜杠可以解決問題。這可能是由于MySQL的一個bug導致的，需要檢查配置是否正確。

innodb_data_home_dir 參數未以斜杠 / 結尾，導致 InnoDB 誤將目錄路徑識別為文件名?

innodb_data_home_dir = /database/    # 添加末尾斜杠?