~~META:
date created = 2017-03-09 09:00
&date modified = 2017-03-09 09:00
~~
====== MySQL useful commands ======
===== 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 ====
<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>
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}}