mysql允许远程调用、数据库创建语句指定字符

1、允许任何机器以用户名root密码root访问

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'root' WITH GRANT OPTION;

flush privileges;

2、指定权限：
grant select,delete,update,create,drop on *.* to 'dev'@'%' identified by 'dev';

3、查询权限列表：
use mysql;

select * from user;

4、创建数据库指定字符为：

CREATE DATABASE IF NOT EXISTS yourdbname DEFAULT CHARSET utf8 COLLATE utf8_general_ci;