FASTPANEL - убрать ошибку mysql native password is deprecated and will be removed in a future release

Материал из Wiki - Iphoster - the best ever hosting and support. 2005 - 2024
Перейти к:навигация, поиск

FASTPANEL - убрать ошибку mysql native password is deprecated and will be removed in a future release

Как предупреждение-ошибку в логах mysql 8 версии панели FastPanel:

# tail -f /var/log/mysql/error.log
2024-06-18T13:13:01.923540Z 88 [Warning] [MY-013360] [Server] Plugin mysql_native_password reported: mysql_native_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead'


Прописать в mysqld:

# vi /etc/mysql/mysql.conf.d/mysqld.cnf
log-error-verbosity=1

и перезапустить mysql 8:

# systemctl restart mysql


Скрин конфига MySQL:
Log-error-verbosity-iphoster-1.png