Create a new user and grant permission to a database

CREATE USER ‘newuser’@’localhost’ IDENTIFIED BY ‘password’;
GRANT ALL PRIVILEGES ON dbTest.* To ‘user’@’localhost’ IDENTIFIED BY ‘password’;

Advertisements