*、mysql中创建的是数据库的概念而非表空间,切记切记切记
CREATE DATABASE 的语法: CREATE {DATABASE | SCHEMA} [IF NOT EXISTS] db_name [create_specification [, create_specification] ...] create_specification: [DEFAULT] CHARACTER SET charset_name | [DEFAULT] COLLATE collation_name eg: CREATE DATABASE db_name DEFAULT CHARACTER SET utf8
*、mysql修改数据库默认编码
ALTER DATABASE db_name DEFAULT CHARACTER SET utf8 [COLLATE utf8_general_ci]
*、mysql为某用户赋予权限
GRANT all privileges ON 数据库名.* TO 数据库名@['localhost'|'%'] IDENTIFIED BY '密码';