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:
Post a Comment