创建数据库:
create database sanlai;
调用数据库
use sanlai;
导入数据
source /var/tmp/sql/20200702/data/culture.sql;
查看用户表
select user,host from mysql.user;
创建用户并授权
GRANT all privileges ON sanlai.* TO 'sanlai'@'10.3.0.%' identified by 'sanlai@yqxc';
配置生效
flush privileges;