linux centos 安装 mysql5.7

linux centos 7.9 安装 mysql5.7
韩老师的视频环境是 7.6 略有不同
https://www.bilibili.com/video/BV1Sv411r7vd?p=89

mysql 用户名 root 密码 root

安装mysql 过程–图片

安装mysql 过程

1. 新建文件夹 /opt/mysql ,cd 进入
2. 运行 wget https://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.33-1.el7.x86_64.rpm-bundle.tar
   下载 MySQL 安装包
3. 解压文件 tar -xvf mysql-5.7.33-1.el7.x86_64.rpm-bundle.tar
4. centos 7.9 自带一个类MySQL 数据库 mariadb 会跟mysql 冲突，所以要先删除
   4.1 rpm -qa | grep mari
   4.2 rpm -e --nodeps mariadb-libs
   4.2 rpm -e --nodeps marisa
5. 真正安装mysql ,依次运行
   rpm -ivh mysql-community-common-5.7.33-1.el7.x86_64.rpm
   rpm -ivh mysql-community-libs-5.7.33-1.el7.x86_64.rpm
   rpm -ivh mysql-community-client-5.7.33-1.el7.x86_64.rpm
   rpm -ivh mysql-community-server-5.7.33-1.el7.x86_64.rpm
6. 启动mysql
   systemctl start mysqld.service — 启动mysql
   systemctl status mysqld -----查看mysql 是否启动
7. 设置密码
   [root@shell38 mysql]# grep “password” /var/log/mysqld.log
   2021-03-21T10:23:11.725146Z 1 [Note] A temporary password is generated for root@localhost: h2r+N6ywImRa
   ----root 默认密码是 h2r+N6ywImRa (注意此处是password , 不是 passwd )
8. 进入mysql重新设置密码
   mysql -u root -p —输入 h2r+N6ywImRa
9. 设置密码策略为0
   set global validate_password_policy=0;
10. 设置新密码(太短了不可以)
    set password for ‘root’@‘localhost’=password(‘root198621’);
    https://blog.csdn.net/wei198621/article/details/115265837
    27号重新设置，将其置为 root
11. 使设置密码生效 flush privileges;

执行步骤详情

1. 新建文件夹 /opt/mysql ,cd 进入
[root@shell38 opt]# ll
[root@shell38 opt]# mkdir mysql
2. 运行   wget https://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.33-1.el7.x86_64.rpm-bundle.tar 
   下载 MySQL 安装包
[root@shell38 mysql]# wget https://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.33-1.el7.x86_64.rpm-bundle.tar
[root@shell38 mysql]# ll
total 530372
-rw-r--r--. 1 root root 543098880 Dec 10 21:26 mysql-5.7.33-1.el7.x86_64.rpm-bundle.tar
[root@shell38 mysql]# pwd
/opt/mysql
------------------04  解压  
[root@shell38 mysql]# ll
total 530372
-rw-r--r--. 1 root root 543098880 Dec 10 21:26 mysql-5.7.33-1.el7.x86_64.rpm-bundle.tar
[root@shell38 mysql]# pwd
/opt/mysql

3.  解压文件
[root@shell38 mysql]# tar -xvf mysql-5.7.33-1.el7.x86_64.rpm-bundle.tar    ---- 注意是 tar 所以 用的-xvf  如果是tar.gz  解压用-zxvf   
mysql-community-client-5.7.33-1.el7.x86_64.rpm
mysql-community-common-5.7.33-1.el7.x86_64.rpm
mysql-community-devel-5.7.33-1.el7.x86_64.rpm
mysql-community-embedded-5.7.33-1.el7.x86_64.rpm
mysql-community-embedded-compat-5.7.33-1.el7.x86_64.rpm
mysql-community-embedded-devel-5.7.33-1.el7.x86_64.rpm
mysql-community-libs-5.7.33-1.el7.x86_64.rpm
mysql-community-libs-compat-5.7.33-1.el7.x86_64.rpm
mysql-community-server-5.7.33-1.el7.x86_64.rpm
mysql-community-test-5.7.33-1.el7.x86_64.rpm
[root@shell38 mysql]# 
4.   centos 7.9 自带一个类MySQL 数据库 mariadb 会跟mysql 冲突，所以要先删除
------------------删除多余的 mariadb 
[root@shell38 mysql]# rpm -qa |grep mari
marisa-0.2.4-4.el7.x86_64
mariadb-libs-5.5.68-1.el7.x86_6
----------------分别删除 上面两个maria包 
[root@shell38 mysql]# rpm -e --nodeps mariadb-libs    
[root@shell38 mysql]# rpm -e --nodeps marisa
[root@shell38 mysql]# rpm -qa |grep mari   ---查询没有了 
[root@shell38 mysql]# 


5.  真正安装mysql ,依次运行
rpm -ivh mysql-community-common-5.7.33-1.el7.x86_64.rpm
rpm -ivh mysql-community-libs-5.7.33-1.el7.x86_64.rpm  
rpm -ivh mysql-community-client-5.7.33-1.el7.x86_64.rpm 
rpm -ivh mysql-community-server-5.7.33-1.el7.x86_64.rpm 
[root@shell38 mysql]# pwd
/opt/mysql

6. 启动mysql
[root@shell38 mysql]# systemctl start mysqld.service
[root@shell38 mysql]# systemctl status mysqld
● mysqld.service - MySQL Server
   Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor preset: disabled)
   Active: active (running) since Sun 2021-03-21 03:23:15 PDT; 11s ago
  ....

Mar 21 03:23:02 shell38 systemd[1]: Starting MySQL Server...
Mar 21 03:23:15 shell38 systemd[1]: Started MySQL Server.

7.  设置密码
[root@shell38 mysql]# grep "password" /var/log/mysqld.log 
2021-03-21T10:23:11.725146Z 1 [Note] A temporary password is generated for root@localhost: h2r+N6ywImRa
----root 默认密码是 h2r+N6ywImRa   (注意此处是password , 不是 passwd )

8. 进入mysql重新设置密码
[root@shell38 mysql]# mysql -u root -p
Enter password:  -------root 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.7.33

Copyright (c) 2000, 2021, Oracle and/or its affiliates.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> 

9. 设置密码策略为0 
mysql> set global validate_password_policy=0;
Query OK, 0 rows affected (0.00 sec)

10. 设置新密码  
mysql> set password for 'root'@'localhost' =password('root');------密码太简单不可以
ERROR 1819 (HY000): Your password does not satisfy the current policy requirements
mysql> set password for 'root'@'localhost'=password('root198621');-----ok  
Query OK, 0 rows affected, 1 warning (0.00 sec)

11.  使设置密码生效  flush privileges;  

 mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)

12. 退出登录后测试数据库是否可用 
mysql> quit
Bye
[root@shell38 mysql]# mysql -u root -p
Enter password:root

13. 新增数据库，表，记录测试
mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| sys                |
+--------------------+
4 rows in set (0.00 sec)

mysql> create database leodb;
Query OK, 1 row affected (0.00 sec)

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| leodb              |------------------新增的 
| mysql              |
| performance_schema |
| sys                |
+--------------------+
5 rows in set (0.01 sec)

mysql> use leodb;-------------------使用leodb
Database changed
mysql> create table myorder(id int,name varchar(32));
Query OK, 0 rows affected (0.10 sec)

mysql> select * from myorder ;
Empty set (0.00 sec)

mysql> insert into myorder value(100,'dog');
Query OK, 1 row affected (0.00 sec)

mysql> select * from myorder ;
+------+------+
| id   | name |
+------+------+
|  100 | dog  |
+------+------+
1 row in set (0.00 sec)

mysql> 

备注

下载地址：
https://dev.mysql.com/downloads/mysql/5.7.html