ABEwiki

Install mysql Server

apt install mysql-server

---

Edit /etc/mysql/mysql.conf.d/mysqld.cnf

datadir=/mnt/volume-nyc1-01/mysql

---

Edit /etc/apparmor.d/tunables/alias

alias /var/lib/mysql/ -> /mnt/volume-nyc1-01/mysql/,

systemctl restart apparmor

---

Benutzer anlegen, Rechte setzen

mysql -u root -p
CREATE USER 'benutzername'@'%' IDENTIFIED WITH mysql_native_password BY 'password';
GRANT ALL PRIVILEGES ON *.* TO 'benutzername'@'%' WITH GRANT OPTION;
FLUSH PRIVILEGES;