mysql-useful-commands

This is an old revision of the document!

Table of Contents

MySQL useful commands

MySQL useful commands

Create Database User and Grant all rights to a DB

CREATE USER 'username'@'localhost' IDENTIFIED BY 'password';
GRANT ALL privileges ON dbname.* TO 'username'@'localhost';
FLUSH privileges;

Set new DB user password

SET PASSWORD FOR 'user-name-here'@'hostname-name-here' = PASSWORD('new-password-here');

Update field and replace string

UPDATE TABLE SET FIELD = REPLACE(FIELD, 'old string', 'new string')

mysql-useful-commands.1503400479.txt.gz · Last modified: 2017/08/22 13:14 by baumi