Zabbix 3.4 Frontend Dashboard Errors in Query - MySQL 8.0.11

[zabbixadmin_newbie]

Hi everyone. I am very new to Zabbix. I have installed Zabbix 3.4 on my CentOS 7. After I logged in to my browser to access the GUI, I get a lot of errors shown on my dashboard. Can someone please help me with this issue?

The errors shown under 'Host Status' and 'System Status':
...

[michael496]

When I click on the "Latest Data" tab I receive the following error:

Error in query [SELECT DISTINCT i.*, ia.applicationid FROM items i,items_applications ia WHERE (ia.applicationid IN (236,237,238,239,240,241,242,243,244,245,246,247)) AND i.itemid=ia.itemid AND i.lastvalue IS...