環境
- ArchLinux on Proxmox(i7-6700の2core)
- MEM 6GB
- BungeeCord 3GB割り当て
- paper-1.16.5-775 2GB割り当て
- MysqlPlayerDataBridge v3.36.1
- WarpSystem v5.0.2
最初からやってたこと
yay -S mariadb mysql_install_db --user=mysql --basedir=/usr --datadir=/var/lib/mysql sudo systemctl enable mariadb --now
足りてなかったこと
sudo vim /etc/mysql/my.cnf
[client] default-character-set = utf8mb4 [mysqld] collation_server = utf8mb4_unicode_ci character_set_server = utf8mb4 [mysql] default-character-set = utf8mb4
sudo systemctl restart mariadb mysql_secure_installation mysql -u root -p
DBにrootでログインしてから
CREATE USER admin@'%' IDENTIFIED BY 'cheesecake'; CREATE DATABASE mydatabase; GRANT SELECT,INSERT,UPDATE,DELETE ON mydatabase.* TO admin@'%';