mysql-useful-commands
This is an old revision of the document!
Table of Contents
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.1503400492.txt.gz · Last modified: 2017/08/22 13:14 by baumi