下载rpm软件包(mysql-5.7.17-1)
下载地址:https://cdn.mysql.com/archives/mysql-5.7/mysql-5.7.17-1.el7.x86_64.rpm-bundle.tar
[root@mysql local]# wget https://cdn.mysql.com/archives/mysql-5.7/mysql-5.7.17-1.el7.x86_64.rpm-bundle.tar
--2021-04-06 11:29:49-- https://cdn.mysql.com/archives/mysql-5.7/mysql-5.7.17-1.el7.x86_64.rpm-bundle.tar
正在解析主机 cdn.mysql.com (cdn.mysql.com)... 23.3.109.33
正在连接 cdn.mysql.com (cdn.mysql.com)|23.3.109.33|:443... 已连接。
已发出 HTTP 请求,正在等待回应... 200 OK
长度:584130560 (557M) [application/x-tar]
正在保存至: “mysql-5.7.17-1.el7.x86_64.rpm-bundle.tar”
100%[============================================================>] 584,130,560 3.51MB/s 用时 2m 37s
2021-04-06 11:32:28 (3.54 MB/s) - 已保存 “mysql-5.7.17-1.el7.x86_64.rpm-bundle.tar” [584130560/584130560])
解压:mysql-5.7.17-1.el7.x86_64.rpm-bundle.tar
[root@mysql local]# tar -xvf mysql-5.7.17-1.el7.x86_64.rpm-bundle.tar
mysql-community-embedded-compat-5.7.17-1.el7.x86_64.rpm
mysql-community-libs-5.7.17-1.el7.x86_64.rpm
mysql-community-common-5.7.17-1.el7.x86_64.rpm
mysql-community-devel-5.7.17-1.el7.x86_64.rpm
mysql-community-client-5.7.17-1.el7.x86_64.rpm
mysql-community-server-5.7.17-1.el7.x86_64.rpm
mysql-community-libs-compat-5.7.17-1.el7.x86_64.rpm
mysql-community-server-minimal-5.7.17-1.el7.x86_64.rpm
mysql-community-embedded-devel-5.7.17-1.el7.x86_64.rpm
mysql-community-test-5.7.17-1.el7.x86_64.rpm
mysql-community-minimal-debuginfo-5.7.17-1.el7.x86_64.rpm
mysql-community-embedded-5.7.17-1.el7.x86_64.rpm
[root@mysql53 local]#
跳过依赖检测安装rpm包
[root@mysql local]# rpm -ivh mysql-community-* --nodeps --force
警告:mysql-community-client-5.7.17-1.el7.x86_64.rpm: 头V3 DSA/SHA1 Signature, 密钥 ID 5072e1f5: NOKEY
准备中... ################################# [100%]
正在升级/安装...
1:mysql-community-common-5.7.17-1.e################################# [ 8%]
2:mysql-community-libs-5.7.17-1.el7################################# [ 17%]
3:mysql-community-client-5.7.17-1.e################################# [ 25%]
4:mysql-community-server-5.7.17-1.e################################# [ 33%]
5:mysql-community-devel-5.7.17-1.el################################# [ 42%]
6:mysql-community-embedded-5.7.17-1################################# [ 50%]
7:mysql-community-embedded-devel-5.################################# [ 58%]
8:mysql-community-test-5.7.17-1.el7################################# [ 67%]
9:mysql-community-libs-compat-5.7.1################################# [ 75%]
10:mysql-community-embedded-compat-5################################# [ 83%]
11:mysql-community-server-minimal-5.警告:/etc/my.cnf 已建立为 /etc/my.cnf.rpmnew
################################# [ 92%]
12:mysql-community-minimal-debuginfo################################# [100%]
[root@mysql local]#
启动mysqld服务,设置开机自启
[root@mysql local]# systemctl restart mysqld
[root@mysql local]# systemctl enable mysqld
获取mysql初始化密码
[root@mysql local]# grep password /var/log/mysqld.log
2021-04-06T03:42:17.802484Z 1 [Note] A temporary password is generated for root@localhost: /ySFeySD%5gr
[root@mysql local]#
登录mysqld程序,修改密码
[root@mysql local]# mysql -u root -p'/ySFeySD%5gr'
mysql: [Warning] Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 4
Server version: 5.7.17
Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved.
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> show databases; #没有修改密码前无法对数据库进行操作
ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.
mysql> set global validate_password_policy=0; #只验证长度
Query OK, 0 rows affected (0.00 sec)
mysql> set global validate_password_length=5; #修改密码长度,默认值是5个字符
Query OK, 0 rows affected (0.00 sec)
mysql> set password=password('mysql');
Query OK, 0 rows affected, 1 warning (0.00 sec)
mysql> exit
Bye
验证密码是否已修改成功
[root@mysql local]# mysql -u root -p'/ySFeySD%5gr' #初始密码登录
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
[root@mysql local]# mysql -u root -p'mysql' #修改后密码登录
mysql: [Warning] Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 6
Server version: 5.7.17 MySQL Community Server (GPL)
Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved.
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> show databases; #可以查看数据库
+--------------------------------+
| Database |
+--------------------------------+
| information_schema |
| mysql |
| performance_schema |
| sys |
+--------------------------------+
4 rows in set (0.00 sec)
mysql>