mysql使用

基本使用

创建database,设置字符集

1
> create database if not exists test default charset utf8 collate utf8_general_ci;

创建用户并授权

1
2
3
4
5
> create user fengxuwang identified by '123456';

> grant all privileges on `test`.* to 'fengxuwang'@'%';

> flush privileges;