Fortytwo - Answer to the Ultimate Question of Life, the Universe, and Everything

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.

~~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}}