I use Ubuntu 16.04 and installed Nextcloud manually. In the backend I get the following message:
MySQL is used as database but does not support 4-byte characters. To be able to handle 4-byte characters (like emojis) without issues in filenames or comments for example it is recommended to enable the 4-byte support in MySQL. For further details read the documentation page about this.
So I checked the manual:
One of the first steps is:
If your innodb_file_format is set as ‘Antelope’ you must upgrade your file format using:
mysql> SET GLOBAL innodb_file_format=Barracuda;
But I get this error:
ERROR 1227 (42000): Access denied; you need (at least one of) the SUPER privilege(s) for this operation
There is also a note in the manual for this step:
On some shared hosts, you may not have the permissions to upgrade the InnoDB file format, meaning you are unable to use utf8mb4
Ok, but I have this problem and have no shared host, so what now?
**I use MariaDB
I forgot to write, that I use MariaDB, Note:**
All mysql statements have to be executed as privileged database user. (Using “normal” nextcloud database user will result in empty query sets due to missing privileges for INFORMATION_SCHEMA database.)