Niweera
5/25/2019 - 7:56 PM

Create a MySQL user in CLI

Saved from https://stackoverflow.com/questions/1720244/create-new-user-in-mysql-and-give-it-full-access-to-one-database

mysql.txt
content_copyfile_download
CREATE USER 'user'@'hostname';
GRANT ALL PRIVILEGES ON dbTest.* To 'user'@'hostname' IDENTIFIED BY 'password';