CODE EXAMPLE FOR SQL

mysql grant access to one database

//create the user:
CREATE USER 'user'@'hostname' IDENTIFIED BY 'password';

//give it access to the database dbTest
GRANT ALL PRIVILEGES ON dbTest.* To 'user'@'hostname' ;