在 CentOS7 中快速安装 MySQL 5.7

素颜马尾好姑娘i 2023-07-13 03:56 8阅读 0赞

# 一、卸载CentOS7自带的mariadb数据库 #

[root@hadoop00 ~]# rpm -qa |grep mariadb
    mariadb-libs-5.5.44-2.el7.centos.x86_64
    [root@hadoop00 ~]# rpm -e --nodeps mariadb-libs-5.5.44-2.el7.centos.x86_64
    [root@hadoop00 ~]# rpm -qa |grep mariadb

# 二、获取MySQL安装包 #

> MySQL5.7安装包下载：[大数据技术系列\_mysql-5.7.24-安装包.zip][mysql-5.7.24-_.zip]。

# 三、解压，并上传安装文件到/opt/mysql目录 #

[root@hadoop00 mysql]# ll
    total 200092
    -rw-r--r-- 1 root root  25398288 Mar 10 13:00 mysql-community-client-5.7.24-1.el7.x86_64.rpm
    -rw-r--r-- 1 root root    280896 Mar 10 13:00 mysql-community-common-5.7.24-1.el7.x86_64.rpm
    -rw-r--r-- 1 root root   3840412 Mar 10 13:00 mysql-community-devel-5.7.24-1.el7.x86_64.rpm
    -rw-r--r-- 1 root root   2272368 Mar 10 13:00 mysql-community-libs-5.7.24-1.el7.x86_64.rpm
    -rw-r--r-- 1 root root 173096508 Mar 10 13:00 mysql-community-server-5.7.24-1.el7.x86_64.rpm

# 四、依次执行命令，安装mysql数据库相关组件 #

[root@hadoop00 mysql]# rpm -ivh mysql-community-common-5.7.24-1.el7.x86_64.rpm 
    warning: mysql-community-common-5.7.24-1.el7.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY
    Preparing...                          ################################# [100%]
    Updating / installing...
       1:mysql-community-common-5.7.24-1.e################################# [100%]
    [root@hadoop00 mysql]# rpm -ivh mysql-community-libs-5.7.24-1.el7.x86_64.rpm 
    warning: mysql-community-libs-5.7.24-1.el7.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY
    Preparing...                          ################################# [100%]
    Updating / installing...
       1:mysql-community-libs-5.7.24-1.el7################################# [100%]
    [root@hadoop00 mysql]# rpm -ivh mysql-community-client-5.7.24-1.el7.x86_64.rpm 
    warning: mysql-community-client-5.7.24-1.el7.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY
    Preparing...                          ################################# [100%]
    Updating / installing...
       1:mysql-community-client-5.7.24-1.e################################# [100%]
    [root@hadoop00 mysql]# rpm -ivh mysql-community-server-5.7.24-1.el7.x86_64.rpm 
    warning: mysql-community-server-5.7.24-1.el7.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY
    Preparing...                          ################################# [100%]
    Updating / installing...
       1:mysql-community-server-5.7.24-1.e################################# [100%]
      
     //安装Hive环境，必须安装这个组件
    [root@hadoop00 mysql]# rpm -ivh mysql-community-devel-5.7.24-1.el7.x86_64.rpm 
    warning: mysql-community-devel-5.7.24-1.el7.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY
    Preparing...                          ################################# [100%]
    Updating / installing...
       1:mysql-community-devel-5.7.24-1.el################################# [100%]
    [root@hadoop00 mysql]#

# 五、启动mysql数据库 #

[root@hadoop00 mysql]# service mysqld start
    Redirecting to /bin/systemctl start  mysqld.service

# 六、查看数据库运行状态 #

[root@hadoop00 mysql]# service mysqld status
    Redirecting to /bin/systemctl status  mysqld.service
    ● mysqld.service - MySQL Server
       Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor preset: disabled)
       Active: active (running) since Tue 2020-03-10 13:10:55 CST; 1s ago
         Docs: man:mysqld(8)
               http://dev.mysql.com/doc/refman/en/using-systemd.html
      Process: 4829 ExecStart=/usr/sbin/mysqld --daemonize --pid-file=/var/run/mysqld/mysqld.pid $MYSQLD_OPTS (code=exited, status=0/SUCCESS)
      Process: 4752 ExecStartPre=/usr/bin/mysqld_pre_systemd (code=exited, status=0/SUCCESS)
     Main PID: 4833 (mysqld)
       CGroup: /system.slice/mysqld.service
               └─4833 /usr/sbin/mysqld --daemonize --pid-file=/var/run/mysqld/mysqld.pid
    
    Mar 10 13:10:49 hadoop00 systemd[1]: Starting MySQL Server...
    Mar 10 13:10:55 hadoop00 systemd[1]: Started MySQL Server.

# 七、查看初始密码 #

[root@hadoop00 mysql]# more /var/log/mysqld.log |grep password
    2020-03-10T05:10:52.278504Z 1 [Note] A temporary password is generated for root@localhost: d(gMqWh#r60r

# 八、使用初始密码登陆 #

[root@hadoop00 mysql]# mysql -uroot -p
    Enter password:

# 九、切换数据库，提示第一次登陆需要修改密码 #

mysql> use mysql;
    ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.

# 十、修改密码发现有强密码要求 #

mysql>alter user 'root'@'localhost' identified by '123456';
    ERROR 1819 (HY000): Your password does not satisfy the current policy requirements

# 十一、去除强密码配置，默认值是1，即是MEDIUM模式，临时修改 #

mysql> set global validate_password_policy=0;
    Query OK, 0 rows affected (0.00 sec)

# 十二、设置密码最短长度，临时修改 #

mysql> set global validate_password_length=1;
    Query OK, 0 rows affected (0.00 sec)

# 十三、设置新密码 #

mysql> alter user 'root'@'localhost' identified by '123456';
    Query OK, 0 rows affected (0.00 sec)