Create a new user and give him access a database in mysql

//
create database UserDB;
//under mysql, use the following to create User1 with password User1Pass in localhost
CREATE USER 'User1'@'localhost' IDENTIFIED BY 'User1Pass';
//Giving User1 to access database UserDB with permission of
//SELECT,INSERT,UPDATE,DELETE,CREATE,INDEX
GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,INDEX ON UserDB.* TO 'User1'@'localhost'
;
test under command prompt:
mysql -h localhost -u User1 -p
under mysql:
show databases;