Differences

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

--- mysql-useful-commands [2017/08/22 13:14] – created 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>
+<code sql>
 UPDATE TABLE SET FIELD = REPLACE(FIELD, 'old string', 'new string')
+</code>
+===== Restore MySQL system database in docker environment =====
+<code>
+$ docker run --detach --rm --name mariadb-restore \
+	--env MARIADB_USER=user \
+	--env MARIADB_PASSWORD=password \
+	--env MARIADB_ROOT_PASSWORD=root \
+	--volume /srv/base-mariadb/BACKUP:/BACKUP:ro \
+	--volume $PWD/data:/var/lib/mysql \
+	mariadb:10.5
+$ docker exec -it mariadb-restore bash
+# mysql -u root -p mysql < /BACKUP/mysql.dump
+# echo "flush privileges" | mysql -u root -p
 </code>
 {{tag>kb mysql}}