Create new user with rights only for specific DB in Mysql

# Log-in to Mysql from terminal
# Set proper value in ( DB_NAME, NEW_DB_USER_NAME, PASSWORD_FOR_NEW_USER )

-> GRANT ALL PRIVILEGES ON DB_NAME.* To 'NEW_DB_USER_NAME'@'localhost' IDENTIFIED BY 'PASSWORD_FOR_NEW_USER';
-> FLUSH PRIVILEGES;

# If you want to delete user

-> DROP USER ‘demo’@‘localhost’;