Monday, June 24, 2019

MySQL 7.0+ install create user.

Use the following command to create user

sudo mysql --user=root mysql

Login to mysql, you will see mysql prompt

CREATE USER 'user'@'localhost' IDENTIFIED by 'some_pass';



GRANT ALL PRIVILEGES ON *.* TO 'user'@'localhost' WITH GRANT OPTION;

 FLUSH PRIVILEGES;

EXIT

No comments: