Differences

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

--- mysql-useful-commands [2023/10/17 08:41] – [Update field and replace string] 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>
@@ Line 29: / Line 40: @@
 	mariadb:10.5
-$ docker exec -it mariadb-restore
+$ docker exec -it mariadb-restore bash
-# mysql -u root -p myql < /BACKUP/mysql.dump
+# mysql -u root -p mysql < /BACKUP/mysql.dump
 # echo "flush privileges" | mysql -u root -p
 </code>
 {{tag>kb mysql}}