ABEwiki

Dies ist eine alte Version des Dokuments!

---

/etc/apparmor.d/tunables/alias

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

systemctl restart apparmor

---

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

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

---

Benutzer anlegen, Rechte setzen

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