Differences

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

--- mysql-useful-commands [2023/11/04 17:50] – [Restore MySQL system database in docker environment] baumi
+++ mysql-useful-commands [2024/09/06 18:20] (current) – baumi
@@ Line 4: / Line 4: @@
 ~~
 ====== MySQL useful commands ======
-===== Create Database User and Grant all rights to a DB =====
+===== User & Permissions =====
+==== 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;
 </code>
-===== Set new DB user password =====
+==== Set new DB user password ====
 <code sql>
 SET PASSWORD FOR 'user-name-here'@'hostname-name-here' = PASSWORD('new-password-here');
 </code>
+=== Delete Database User ===
 ===== Update field and replace string =====
 <code sql>