Example:
CREATE SCHEMA `db_wordpress_02` ;

GRANT ALL PRIVILEGES ON db_wordpress_02.* to 'root'@'localhost' IDENTIFIED BY 'scr1ptlov3r';