Answers for "mysql access user"

mysql user access to database

GRANT ALL PRIVILEGES ON dbTest.* To 'user'@'hostname' IDENTIFIED BY 'password';

mysql user

CREATE USER 'pdam'@'localhost' IDENTIFIED BY 'pdamP@ssw0rd'; # create user
GRANT ALL PRIVILEGES ON `pdam_db`.* TO 'pdam'@'localhost'; # set db access
FLUSH PRIVILEGES; # Reload