1、查看、卸载自带的 mariadb

rpm -qa | grep mariadb
mariadb-libs-5.5.60-1.el7_5.x86_64

卸载 mariadb

rpm -e --nodeps mariadb-libs-5.5.60-1.el7_5.x86_64

2、安装依赖关系

#有yum源用yum安装
yum -y install net-tools openssl openssl-devel libaio libaio-devel perl perl-devel perl-JSON.noarch autoconf
#没有yum自己上传依赖包
cd yilai
rpm -ivh net-tools-2.0-0.25.20131004git.el7.x86_64.rpm
rpm -ivh *.rpm

3、解压安装mysql

tar xvf mysql-5.7.27-1.el7.x86_64.rpm-bundle.tar

安装mysql

rpm -ivh mysql-community-common-5.7.27-1.el7.x86_64.rpm
rpm -ivh mysql-community-libs-5.7.27-1.el7.x86_64.rpm
rpm -ivh mysql-community-client-5.7.27-1.el7.x86_64.rpm
rpm -ivh mysql-community-server-5.7.27-1.el7.x86_64.rpm

4、查看安装情况

rpm -qa | grep mysql

5、初始化数据库

mysqld --initialize --console

6、为数据库赋权

chown -R mysql:mysql /var/lib/mysql/

7、数据库起停

#启动
systemctl start mysqld
#关闭
systemctl stop mysqld

8、将mysql加入自启

systemctl enable mysqld

9、查看初始密码

cat /var/log/mysqld.log | grep 'temporary password'
2020-08-11T09:12:53.829088Z 6 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: FJSah4o+wpU)

10、登录数据库

mysql -uroot -pFJSah4o+wpU)

11、修改初始密码

#修改在‘localhost’登录的root密码为Aa111111
ALTER USER 'root'@'localhost' IDENTIFIED BY 'Aa111111';
#新建在‘localhost’登录的新用户ceshi的密码为Aa111111
CREATE USER 'ceshi'@'localhost' IDENTIFIED BY 'Aa111111';
#新建在任意位置登录的新用户ceshi的密码为Aa111111
CREATE USER 'ceshi'@'%' IDENTIFIED BY 'Aa111111';
#新建在‘127.0.0.1’登录的新用户ceshi的密码为Aa111111
CREATE USER 'ceshi'@'127.0.0.1' IDENTIFIED BY 'Aa111111';

12、创建数据库heat

create database heat;

13、赋权给用户ceshi，使之可以在任意位置登录，并且拥有heat数据库的全部权限

GRANT ALL ON heat.* TO 'ceshi'@'%';

14、刷新权限

flush privileges;

15、导入数据库

mysql -uceshi -p heat < /root/heat_20200811.sql