BIND fails to build with MYSQL support against mysql8/mysql-connector-8

Summary

BIND fails to build with MYSQL support against mysql8/mysql-connector-8

BIND version used

BIND 9.16.0 (Stable Release) id:6270e60

What is the current bug behavior?

../../contrib/dlz/drivers/dlz_mysql_driver.c: In function ‘mysql_create’:
../../contrib/dlz/drivers/dlz_mysql_driver.c:754:2: error: unknown type name ‘my_bool’; did you mean ‘bool’?
  754 |  my_bool auto_reconnect = 1;
      |  ~~~~~~
      |  bool
make[2]: *** [Makefile:638: dlz_mysql_driver.lo] Error 1

Possible fixes

Full build.log from gentoo, together with a patch...

https://bugs.gentoo.org/712692
https://712692.bugs.gentoo.org/attachment.cgi?id=619928&action=diff&format=raw&headers=1