How to add a new user in Mysql

Create a new user

CREATE USER 'gcpuser'@'localhost' IDENTIFIED BY 'password';

Grant access to a database

GRANT ALL PRIVILEGES ON * . * TO 'gcpuser'@'localhost';