Mysql enable 4 bit characters but cant find the file to edit

ℹ️ Support
1

hi all,

im looking at this page to re-configure my mysql to enable 4 bit characters -

https://docs.nextcloud.com/server/15/admin_manual/configuration_database/mysql_4byte_support.html

but i dont know what config file to edit (i have mysql 5.5 )

any help would be much appreciated

thanks,
rob

2

looking into /etc ls -l /etc/mysql* you should find a my.cnf

in case there is no [mysqld] section in there. grep -r '\[mysqld\]' /etc/mysql

3

nice one

the file to edit was

vi /etc/my.cnf

then i had to go in mysql to change some details

mysql -u root -p

then cd to my nextcloud dir to edit the php stuff

cd /var/www/html/nextcloud/

sudo -u apache php occ “commands_go_here”

then restart mariadb and httpd