yum -y install wget

wget https://dev.mysql.com/get/mysql57-community-release-el7-8.noarch.rpm

rpm -ivh mysql57-community-release-el7-8.noarch.rpm

cd /etc/yum.repos.d/

systemctl start mysqld

mysqladmin -uroot -p password

mysql -uroot -p

show databases;

create database test;

use test;

create table user(id int,name varchar(20));

desc user;

insert into user values(1,'zhangsan',19);

insert into user values(1,'huu',12),(2,'ws',18);

show tables;

select * from user;

rename table Contact to Contact_new

drop database location

drop table Contact

mysqladmin -uroot -p password

mysqladmin -uroot -p

show databases;

create datebase test;

use test;

create table user(id int,name varchar(20),age int);

desc user;

insert into user values(1,'zhangshan',19);

insert into user values(2,'lisi',17),(3,'wangwu',23);

select * form user;

show tables;

drop table user

delete from user where name='lisi';

grant all on bbs.* tobbs@localhost identified by '333';

grant all on bbs.* to bbs@'%' identified by '333';

select host,user from mysql.user;

select * form bbs.user

1. mkdir /{sh,backup} 
2. cd/sh
3. vi backup.sh

1. 
#!/bin/bash
2. 
3. /usr/local/mysql/bin/mysqldump -uroot -p123.com --all-databases > /backup/mysql_$(date +%F).sql

crontab -e

crontab -l

crontab -r