Differences

This shows you the differences between two versions of the page.

--- mysql-useful-commands [2024/09/06 18:18] – baumi
+++ mysql-useful-commands [2024/09/06 18:20] (current) – baumi
@@ Line 4: / Line 4: @@
 ~~
 ====== MySQL useful commands ======
+===== User & Permissions =====
-==== Create Database User and Grant all rights to a DB ====
+==== Create Database User ====
 <code sql>
 CREATE USER 'username'@'localhost' IDENTIFIED BY 'password';
+</code>
+==== Delete Database User ====
+<code sql>
+DROP USER 'username'@'localhost';
+</code>
+==== Grant Permissions ====
+<code sql>
 GRANT ALL privileges ON dbname.* TO 'username'@'localhost';
 FLUSH privileges;
@@ Line 15: / Line 22: @@
 SET PASSWORD FOR 'user-name-here'@'hostname-name-here' = PASSWORD('new-password-here');
 </code>
+=== Delete Database User ===
 ===== Update field and replace string =====
 <code sql>