Unterschiede

Hier werden die Unterschiede zwischen zwei Versionen angezeigt.

--- modul:m290:learningunits:lu06:theorie:01 [2024/10/22 12:49] – vdemir
+++ modul:m290:learningunits:lu06:theorie:01 [2024/11/16 09:00] (aktuell) – kdemirci
@@ Zeile 23: / Zeile 23: @@
 To create a new user in MySQL, you use the CREATE USER statement:
-  CREATE USER 'username'@'localhost' IDENTIFIED BY 'password';
+  CREATE USER 'username'@'localhost' IDENTIFIED WITH 'caching_sha2_password' BY 'password';
 This creates a user username that can only connect from localhost (the MySQL server machine).
@@ Zeile 65: / Zeile 65: @@
 This removes both the user and their associated privileges.
+==== 6. Activating Change of Privileges After Altering Them ====
+To activate changes to privileges in MySQL after modifying them, you can use the following command:
+  FLUSH PRIVILEGES;
+This command forces MySQL to reload the privilege tables, applying any recent changes made to user privileges. Normally, after using GRANT, REVOKE, or ALTER USER, MySQL applies changes automatically, but if you've made manual adjustments directly in the mysql database tables, running FLUSH PRIVILEGES ensures that the changes take effect immediately.
+<color #ed1c24>Please note that the change will only take effect AFTER a new login. This means that you must open a new console window with your new login data in order to recognize the change in permissions.</color>
 ===== Video-Tutorials ====