MySQL 8 - как отключить WarningS

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

MySQL 8 - как отключить WarningS

# 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'


отключить варнинги под root:

# mysql
mysql> SET GLOBAL log_error_verbosity=1;

Проверка переменной:

mysql> SHOW VARIABLES LIKE '%log_error_verbosity%';
+---------------------+-------+
| Variable_name       | Value |
+---------------------+-------+
| log_error_verbosity | 1     |
+---------------------+-------+

Возможные уровни логирования:

log_error_verbosity Value	Permitted Message Priorities
1	ERROR
2	ERROR, WARNING
3	ERROR, WARNING, INFORMATION


Links:

https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html#sysvar_log_error_verbosity