mariadb

yum install mariadb* -y

systemctl restart mariadb

mysql

create user 'jack' @'%'

flush privileges;

systemctl stop firewalld

setenforce 0

客户端

yum install vim mariadb* -y

systemctl restart mariadb

systemctl enable mariadb

mysql -u jake -p 123456

create database shool;

use shool;

create table biaomiang

insert into biaoming values

update 表名 set 参数 =xx id=xx

update 表名 set age=21 id=1

update 表名 set age=22 id=2

mysqldump -h 192.168.100.100 -u jack -p 123456 数据库名 表名 > /要导入的位置

mysql

load data local infile "文件路径" into table 表名