#创建初始数据库
mysql -uroot -p
mysql> show databases; #查看默认数据库
mysql> create database test character set utf8 collate utf8_bin; #我们的电脑自带的编码就是utf8,如下图
mysql> create user test@localhost identified by 'password'; (密码可以自行修改)
mysql> grant all privileges on test.* to test@localhost;
mysql> flush privileges; 更新
mysql> quit;