MySQL is used as database but does not support 4-byte characters

Nextcloud version: 16.0.4
Operating system and version: Ubuntu 18.04
Apache or nginx version: Apache/2.4.29 (Ubuntu)
PHP version: 7.2.19-0ubuntu
MySQL Version: mysql Ver 15.1 Distrib 10.1.41-MariaDB, for debian-linux-gnu (x86_64) using readline 5.2

The issue you are facing:

I’m unable to resolve the issue where the Overview settings page states: MySQL is used as database but does not support 4-byte characters.

I’ve followed the steps listed HERE but I can’t get step 4 or 5 to run. The shell responds with Could not open input file: occ

Either give the full path to occ (which is inside the nextcloud folder) or cd to your nextcloud folder before issuing the occ commands.

tried the absolute path to occ e.g. /var/www/nextcloud/occ ?