CREATE DATABASE IF NOT EXISTS mydb DEFAULT CHARSET utf8 COLLATE utf8_general_ci;
CREATE USER ‘root‘@‘%‘ IDENTIFIED BY ‘123456‘;
GRANT ALL PRIVILEGES ON mydb.* TO root;
flush privileges;
MYSQL
原文:http://www.cnblogs.com/chadwick/p/mysql.html