[Mysql] Steps to create user

How to create user for mysql

• First login using root, mysql -u root -p
• Now change the database to mysql, use mysql
• Now create new user (test) using the following command ,  GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP ON TUTORIALS.* TO ‘test’@’localhost’ IDENTIFIED BY ‘test123’ ;
• So test user is created with test123 password

…………………………………………………………………………………….