artilla's blog

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';