Linux下安装MySQL5.7(使用rpm安装)
- 首先在 /usr/local/目录下新建一个文件夹 mysql
- 切换到mysql目录下
**//下载安装包**
[root@localhost mysql]# wget https://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.22-1.el7.x86_64.rpm-bundle.tar//**解压在mysql文件夹内**
[root@localhost mysql]# tar -xf mysql-5.7.22-1.el7.x86_64.rpm-bundle.tar //**安装依赖包**
[root@localhost mysql]# yum -y install make gcc-c++ cmake bison-devel ncurses-devel libaio-devel net-tools**由于Centos7开始自带的数据库是mariadb,所以需要卸载系统中的mariadb组件,才能安装mysql的组件**
[root@localhost mysql]# rpm -qa | grep mariadb
mariadb-libs-5.5.68-1.el7.x86_64
[root@localhost mysql]# yum -y remove mariadb-libs//卸载
(2)安装
[root@localhost mysql]# rpm -ivh mysql-community-common-5.7.22-1.el7.x86_64.rpm
警告:mysql-community-common-5.7.22-1.el7.x86_64.rpm: 头V3 DSA/SHA1 Signature, 密钥 ID 5072e1f5: NOKEY
准备中...################################# [100%]
正在升级/安装...
1:mysql-community-common-5.7.22-1.e################################# [100%]
[root@localhost mysql]# rpm -ivh mysql-community-libs-5.7.22-1.el7.x86_64.rpm
警告:mysql-community-libs-5.7.22-1.el7.x86_64.rpm: 头V3 DSA/SHA1 Signature, 密钥 ID 5072e1f5: NOKEY
准备中...################################# [100%]
正在升级/安装...
1:mysql-community-libs-5.7.22-1.el7################################# [100%]
[root@localhost mysql]# rpm -ivh mysql-community-libs-compat-5.7.22-1.el7.x86_64.rpm
警告:mysql-community-libs-compat-5.7.22-1.el7.x86_64.rpm: 头V3 DSA/SHA1 Signature, 密钥 ID 5072e1f5: NOKEY
准备中...################################# [100%]
正在升级/安装...
1:mysql-community-libs-compat-5.7.2################################# [100%]
[root@localhost mysql]# rpm -ivh mysql-community-client-5.7.22-1.el7.x86_64.rpm
警告:mysql-community-client-5.7.22-1.el7.x86_64.rpm: 头V3 DSA/SHA1 Signature, 密钥 ID 5072e1f5: NOKEY
准备中...################################# [100%]
正在升级/安装...
1:mysql-community-client-5.7.22-1.e################################# [100%]
[root@localhost mysql]# rpm -ivh mysql-community-server-5.7.22-1.el7.x86_64.rpm
警告:mysql-community-server-5.7.22-1.el7.x86_64.rpm: 头V3 DSA/SHA1 Signature, 密钥 ID 5072e1f5: NOKEY
准备中...################################# [100%]
正在升级/安装...
1:mysql-community-server-5.7.22-1.e################################# [100%]
(3)启动
[root@localhost mysql]# systemctl start mysqld
[root@localhost mysql]# systemctl enable mysqld
[root@localhost mysql]# systemctl status mysqld
(4)查找密码并登录
[root@localhost mysql]# grep "password" /var/log/mysqld.log// 前往日志文件查找临时密码
2022-01-17T14:15:30.044799Z 1 [Note] A temporary password is generated for root@localhost: VihNdp7u+ff;
//密码用引号包住,因为有特殊符号
[root@localhost mysql]# mysql -uroot -p"VihNdp7u+ff;
"
(5)重新设置密码格式
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> set password for root@localhost=password('root');
//设置密码
Query OK, 0 rows affected, 1 warning (0.00 sec)mysql> flush privileges;
//刷新
Query OK, 0 rows affected (0.00 sec)mysql> exit//退出
Bye
(6)用新密码重新登录
[root@localhost mysql]# mysql -uroot -proot
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 3
Server version: 5.7.22 MySQL Community Server (GPL)Copyright (c) 2000, 2018, 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>
【Linux|Linux安装MySQL5.7(使用rpm安装)】至此MySQL就安装完成了
推荐阅读
- 最新推荐!Linux面试问题热门汇总
- Linux/Android NDK线程绑定
- pytest框架|软件测试面试题(写出5个Loadrunner中常用函数,并对其中2个举例说明用法)
- 网络安全全栈课程|反弹shell方法
- 读书笔记.Linux内核设计与实现.4
- Kubernetes|k8s之Prometheus-node-down解决
- 环境配置|ssh本机连接服务器失败
- 全备 + binlog 恢复线上数据
- PHP MySQL登录系统实现示例