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$

 

Advertisements