簡例 ＋ mysql create database, create user, grant privilege

//===  create utf8  database
mysql> CREATE DATABASE mydb1 CHARACTER SET utf8 COLLATE utf8_general_ci



//===  http://dev.mysql.com/doc/refman/5.1/en/create-user.html
mysql> CREATE USER   'myuser1'@'localhost'   IDENTIFIED BY 'myuser1passwd';

//===  http://dev.mysql.com/doc/refman/5.1/en/grant.html
mysql> grant all on  mydb1.*  to  'myuser1'@'localhost';
mysql> flush privileges;