MySQL #1 创建数据库和用户并授权

直接贴~~~~~

//创建数据库并设置默认编码格式
create database demo default character set utf8 collate utf8_general_ci;

mysql> create database demo default character set utf8 collate utf8_general_ci;
Query OK, 1 row affected, 2 warnings (0.06 sec)

//创建用户，% 表示匹配所有主机，@'localhost' 只匹配本地主机
create user 'wangs'@'%' identified by 'wangs';

//授权
grant select,insert,update,delete,create,alter, on demo.* to wangs;

mysql> grant select,insert,update,delete,create on demo.* to wangs;
Query OK, 0 rows affected (0.01 sec)

//立即生效
mysql> flush privileges;
Query OK, 0 rows affected (0.02 sec)