Unterschiede

Hier werden die Unterschiede zwischen zwei Versionen angezeigt.

--- mysql [2025/11/20 19:53] – berti
+++ mysql [2025/11/27 19:01] (aktuell) – berti
@@ Zeile 1: / Zeile 1: @@
-/etc/apparmor.d/tunables/alias
+Install mysql Server
-  alias /var/lib/mysql/ -> /mnt/volume-nyc1-01/mysql/,
+  apt install mysql-server
-systemctl restart apparmor
 ----
-/etc/mysql/mysql.conf.d/mysqld.cnf
+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'@'localhost' IDENTIFIED BY 'passwort';
+  CREATE USER 'benutzername'@'%' IDENTIFIED WITH mysql_native_password BY 'password';
-  oder CREATE USER 'benutzername'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password';
+  GRANT ALL PRIVILEGES ON *.* TO 'benutzername'@'%' WITH GRANT OPTION;
-  GRANT ALL PRIVILEGES ON *.* TO 'benutzername'@'localhost';
   FLUSH PRIVILEGES;