yum list |grep mysql
yum list |grep mariadb
rpm -e mariadb-libs --nodeps 不考虑依赖关系卸载
cd /etc/yum.repos.d/
ll
cd /usr/local/src
yum -y install lrzsz
rz上传mysql80-community-release-el7-3.noarch.rpm
rpm -ivh mysql80-community-release-el7-3.noarch.rpm
rpm -ql mysql80-community-release
cd /etc/yum.repos.d/
ll
更改下载版本0 表示不下载 1 表示下载
vim mysql-community.repo
[# Enable to use MySQL 5.7
[mysql57-community]
..
enabled=1
gpgcheck=1
..
[mysql80-community]
name=MySQL 8.0 Community Server
..
enabled=0
gpgcheck=1
这里因为我们使用5.7版本，所有将5.7改为1，将8.0禁用，默认为8.0
安装mysql
yum list |grep mysql 找到mysql-community-server.
安装
yum -y install mysql-community-server.x86_64
rpm -qa |grep mariadb 过滤查看是否还有mariadb
systemctl start mysqld
ss -antlp |grep mysql 会看到mysql已经打开
id mysql
grep password /var/log/mysqld.log 查看mysql初始密码
2021-09-30T08:49:47.412467Z 1 [Note] A temporary password is generated for root@localhost: CsWg=Y(BW7?: 这是密码
mysql -uroot -p 登录mysql
alter user root@localhost identified by '@1006Gjx';
修改密码为：@1006Gjx
show databases; 查看库
create database mytest; 创建一个库，名字为mytest
show databases; 已经有了
use mytest; 使用mytest库
show tables; 查看表
create table test(id int,name varchar(20)); 创建表
desc test; 查看创建的表
insert into test values(1,"a");
insert into test values(2,"b"); 添加1，a/2,b 到表内
select * from test; 查看一下
update test set name="c" where id=2; 将b修改为c
select * from test; 查看一下
delete from test where id=2 删除id=2
drop table test; 删除表
drop database mytest; 删除库
