mysql create a new schema and add a new user

0. mysql -u root mysql -p

1. create database xxxx DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;

2. create user '****'@'localhost' identified by '****';

    create user '****'@'%' identified by '****';

3. grant all privileges on xxxx.* to ****@'%'

    grant all privileges on xxxx.* to ****@'localhost';