manual:installation:known_issues

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
manual:installation:known_issues [2020/12/08 08:33]
martins-v database TLS connecti on is not supported with the 'verify_ca' option with MariaDB (ZBX-18548)
manual:installation:known_issues [2021/01/27 21:18] (current)
Line 7: Line 7:
   [Z3001] connection to database '​zabbix'​ failed: [1227] Access denied; you need (at least one of) the SUPER, SYSTEM_VARIABLES_ADMIN or SESSION_VARIABLES_ADMIN privilege(s) for this operation   [Z3001] connection to database '​zabbix'​ failed: [1227] Access denied; you need (at least one of) the SUPER, SYSTEM_VARIABLES_ADMIN or SESSION_VARIABLES_ADMIN privilege(s) for this operation
  
-That is due to MySQL 8.0.0 starting to enforce special permissions for setting session variables. However, in 8.0.18 this behaviour ​was removed: [[https://​dev.mysql.com/​doc/​refman/​8.0/​en/​server-system-variables.html|As of MySQL 8.0.18, setting the session value of this system variable is no longer a restricted operation.]]+That is due to MySQL 8.0.0 starting to enforce special permissions for setting session variables. However, in 8.0.18 this behavior ​was removed: [[https://​dev.mysql.com/​doc/​refman/​8.0/​en/​server-system-variables.html|As of MySQL 8.0.18, setting the session value of this system variable is no longer a restricted operation.]]
  
 The workaround is based on granting additional privileges to the ''​zabbix''​ user: The workaround is based on granting additional privileges to the ''​zabbix''​ user: