mysql创建库和用户

1、创建库
root用户登录
1)mysql -u root -p
2) use mysql
3)create schema db1 default character set utf8 collate utf8_general_ci;–创建数据库
2、创建用户
select host,user from user;
CREATE USER ‘username’@‘host’ IDENTIFIED BY ‘password’;
mysql> flush privileges; ----flush
3、授权
GRANT privileges ON databasename.tablename TO ‘username’@‘host’
4、创建表

mysql -u user -p
use db1
source D:\XX.sql