Nextcloud MariaDB セットアップ

sudo apt install mariadb-client mariadb-server

$ sudo nano /etc/mysql/mariadb.conf.d/50-server.cnf
で以下のように編集します。

変更前
character-set-server = utf8mb4
collation-server = utf8mb4_gereral_ci

変更後
character-set-server = utf8
# collation-server = utf8mb4_gereral_ci

$ sudo systemctl restart mariadb
$ sudo mysql_secure_installation

$sudo mysql -u root -p
CREATE DATABASE nextcloud;
CREATE USER 'pi'@'localhost' IDENTIFIED BY 'password';
GRANT ALL PRIVILEGES ON nextcloud.* to 'pi'@'localhost';
FLUSH PRIVILEGES;
show databases;
exit

Hits: 60