mysql shell 中创建 utf-8 编码数据库以及非 root 账号

• 在 mysql 的命令行中创建 utf-8 编码的数据库
• 建立一个非 root 账号并赋予权限

# database for blog project
## database name: testdjango
## user: tester
## password: tester

CREATE USER 'tester'@'localhost' IDENTIFIED BY 'tester';

DROP DATABASE IF EXISTS `mxonline`;

CREATE DATABASE `mxonline` DEFAULT CHARACTER SET utf8 DEFAULT COLLATE utf8_general_ci;

USE `mxonline`;

GRANT ALL PRIVILEGES ON mxonline.* TO 'tester'@'localhost' IDENTIFIED BY 'tester' WITH GRANT OPTION ;

FLUSH PRIVILEGES ;


SHOW DATABASES ;
SHOW TABLES ;