MySQL 8 - Unknown system variable log warnings

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

MySQL 8 - Unknown system variable log warnings

Ошибка

mysql> SET GLOBAL log_warnings=0;
ERROR 1193 (HY000): Unknown system variable 'log_warnings'

Переменная log_warnings в MySQL 8 была заменена на log_error_verbosity

The deprecated log_warnings system variable and --log-warnings server option have been removed. Use the log_error_verbosity system variable instead. (WL #9676)

то есть https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html#sysvar_log_error_verbosity

mysql> SET GLOBAL log_error_verbosity=1;
Query OK, 0 rows affected (0.01 sec)
Default Value	2
Minimum Value	1
Maximum Value	3

Уровни логирования:

1	ERROR
2	ERROR, WARNING
3	ERROR, WARNING, INFORMATION