Unterschiede

Hier werden die Unterschiede zwischen zwei Versionen angezeigt.

--- modul:m290:learningunits:lu06:aufgaben:a02 [2024/11/13 16:42] – cbolzern
+++ modul:m290:learningunits:lu06:aufgaben:a02 [2024/11/20 14:36] (aktuell) – cbolzern
@@ Zeile 26: / Zeile 26: @@
 ==== Task 2.1 ====
-**Create the User**: Create a user named //restrictedUser// with the password //SafePassword123// using the //mysql_native_password// plugin.
+**Create the User**: Create a user named //restrictedUser// with the password //SafePassword123// using the //caching_sha2_password// plugin.
-  CREATE USER 'restrictedUser'@'localhost' IDENTIFIED WITH mysql_native_password BY 'SafePassword123';
+  CREATE USER 'restrictedUser'@'localhost' IDENTIFIED WITH caching_sha2_password BY 'SafePassword123';
 ==== Task 2.2 ====
@@ Zeile 57: / Zeile 57: @@
 ==== Task 2.7 ====
-Finally, try to perform a CREATE TABLE or DROP TABLE operation. The attempt should result in a permission error als displayed in the image below.
+Finally, try to perform a CREATE TABLE or DROP TABLE operation. The attempt should result in a permission error as displayed in the image below.
 ==== Task 2.8 ====
-**Delete the User (optional)**: After testing, you can delete the user if they are no longer needed.
+**Delete the User (optional)**: After testing, you can delete the user if it is not needed anymore.
 ===== Solution =====