创建数据库
create database [数据库名称] default character set utf8 collate utf8_general_ci;
mysql> CREATE DATABASE test DEFAULT CHARACTER SET utf8 collate utf8_general_ci
创建用户
create user ‘[用户名称]’@’%’ identified by ‘[用户密码]’;
创建用户。’localhost’,代表只能本地访问,例如root账户默认为‘localhost‘。
mysql> CREATE USER 'finley'@'localhost' IDENTIFIED BY 'some_pass';
创建用户。’%’:所有远程主机访问。
mysql> CREATE USER