Techie Hints

A place where to find tech solution

MySQL User creation & Grant permission

  1. CREATE USER ‘techiehints’@’localhost’ IDENTIFIED BY ‘PassWord123$’
  2. CREATE DATABASE data_tracker;

3. GRANT ALL ON data_tracker.* TO ‘techiehints’@’localhost’ IDENTIFIED BY ‘PassWord123$’;
FLUSH PRIVILEGES;

Test it by login

mysql -utechiehints -pPassWord123$

 

%d bloggers like this: