MySQL安装方式(5.7版本和8.0版本)

本文详细介绍了MySQL 5.7和8.0版本的两种安装方法:RPM包安装和通用二进制格式安装,包括安装步骤、依赖处理、初始化设置、密码配置以及环境变量的调整。

摘要生成于 C知道 ,由 DeepSeek-R1 满血版支持, 前往体验 >

5.7版本安装MySQL

rpm安装mysql

1.首先检查机器里是否已经存在MySQL

[root@localhost ~]# rpm -qa | grep mysql
mysql-community-server-5.7.14-1.el7.x86_64
mysql-community-libs-5.7.14-1.el7.x86_64
mysql-community-common-5.7.14-1.el7.x86_64
mysql-community-client-5.7.14-1.el7.x86_64
[root@localhost ~]#

2.去官网下载相应的rpm包:https://dev.mysql.com/downloads/mysql/并上传

[root@localhost ~]# ls
anaconda-ks.cfg  initial-setup-ks.cfg           
mysql-5.7.14-1.el7.x86_64.rpm-bundle.tar 
[root@localhost ~]#

3.解压mysql-5.7.14-1.el7.x86_64.rpm-bundle.tar

[root@localhost ~]# tar xf mysql-5.7.14-1.el7.x86_64.rpm-bundle.tar
[root@localhost ~]# ll

解压后会得到以下rpm安装文件:
在这里插入图片描述
4.查看并卸载mariadbpostfix

[root@localhost ~]# rpm -qa | grep ^mariadb
mariadb-libs-5.5.56-2.el7.x86_64
[root@localhost ~]# rpm -e mariadb-libs
error: Failed dependencies:
        libmysqlclient.so.18()(64bit) is needed by (installed) postfix-2:2.10.1-6.el7.x86_64
        libmysqlclient.so.18(libmysqlclient_18)(64bit) is needed by (installed) postfix-2:2.10.1-6.el7.x86_                                                          64
You have new mail in /var/spool/mail/root
[root@localhost ~]# rpm -e mariadb-libs postfix
[root@localhost ~]# rpm -qa | grep ^mariadb
[root@localhost ~]# 

在这里插入图片描述
4.安装

  • 安装服务端
[root@localhost ~]# yum localinstall mysql-community-server-5.7.14-1.el7.x86_64.rpm
Loaded plugins: fastestmirror, langpacks
Examining mysql-community-server-5.7.14-1.el7.x86_64.rpm: mysql-community-server-5.7.14-1.el7.x86_64
Marking mysql-community-server-5.7.14-1.el7.x86_64.rpm to be installed
......(省略)
--> Finished Dependency Resolution
Error: Package: mysql-community-server-5.7.14-1.el7.x86_64 (/mysql-community-server-5.7.14-1.el7.x86_64)
           Requires: mysql-community-client(x86-64) >= 5.7.9
Error: Package: mysql-community-server-5.7.14-1.el7.x86_64 (/mysql-community-server-5.7.14-1.el7.x86_64)
           Requires: mysql-community-common(x86-64) = 5.7.14-1.el7
 You could try using --skip-broken to work around the problem
 You could try running: rpm -Va --nofiles --nodigest
[root@localhost ~]# 

在这里插入图片描述
根据报错信息安装所需要包

  • 安装客户端和服务端和客户端的公共文件(mysql-community-client-5.7.14-1.el7.x86_64.rpm mysql-community-common-5.7.14-1.el7.x86_64.rpm
[root@localhost ~]# yum localinstall mysql-community-server-5.7.14-1.el7.x86_64.rpm mysql-community-client-5.7.14-1.el7.x86_64.rpm mysql-community-common-5.7.14-1.el7.x86_64.rpm
Loaded plugins: fastestmirror, langpacks
Examining mysql-community-server-5.7.14-1.el7.x86_64.rpm: mysql-community-server-5.7.14-1.el7.x86_64
Marking mysql-community-server-5.7.14-1.el7.x86_64.rpm to be installed
......(省略)
--> Finished Dependency Resolution
Error: Package: mysql-community-client-5.7.14-1.el7.x86_64 (/mysql-community-client-5.7.14-1.el7.x86_64)
           Requires: mysql-community-libs(x86-64) >= 5.7.9
 You could try using --skip-broken to work around the problem
 You could try running: rpm -Va --nofiles --nodigest
[root@localhost ~]# 

在这里插入图片描述
根据报错信息安装所需要包

  • 安装客户端共享库(mysql-community-libs-5.7.14-1.el7.x86_64.rpm
[root@localhost ~]# yum localinstall mysql-community-server-5.7.14-1.el7.x86_64.rpm mysql-community-client- 5.7.14-1.el7.x86_64.rpm mysql-community-common-5.7.14-1.el7.x86_64.rpm mysql-community-libs-5.7.14-1.el7.x86_64.rpm
Loaded plugins: fastestmirror, langpacks
Examining mysql-community-server-5.7.14-1.el7.x86_64.rpm: mysql-community-server-5.7.14-1.el7.x86_64
Marking mysql-community-server-5.7.14-1.el7.x86_64.rpm to be installed
......(省略)
Installed:
  mysql-community-client.x86_64 0:5.7.14-1.el7         mysql-community-common.x86_64 0:5.7.14-1.el7
  mysql-community-libs.x86_64 0:5.7.14-1.el7           mysql-community-server.x86_64 0:5.7.14-1.el7

Complete!
[root@localhost ~]# 

安装成功!

5.epel https://mirrors.tuna.tsinghua.edu.cn/

  • 进入清华大学开源软件镜像站官网
    在这里插入图片描述
  • 复制链接 https://mirrors.tuna.tsinghua.edu.cn/epel/epel-release-latest-7.noarch.rpm
    在这里插入图片描述
[root@localhost ~]# yum install -y https://mirrors.tuna.tsinghua.edu.cn/epel/epel-release-latest-7.noarch.rpm
Loaded plugins: fastestmirror, langpacks
epel-release-latest-7.noarch.rpm                                                    |  15 kB  00:00:00
Examining /var/tmp/yum-root-qsICr2/epel-r
要在Docker上安装MySQL 5.7,可以使用以下命令创建容器: docker run --privileged=true -p 3306:3306 --name mysql -v /docker/mysql/conf:/etc/mysql/conf.d -v /docker/mysql/logs:/var/log/mysql -v /docker/mysql/data:/var/lib/mysql -e MYSQL_ROOT_PASSWORD=223345 -d mysql:5.7 该命令将创建一个名为mysql的容器,并将主机的3306端口映射到容器的3306端口。配置文件、日志文件数据文件将在主机上的/docker/mysql目录中进行持久化存储。容器将使用MySQL 5.7镜像,并设置root用户的密码为223345。 要在Docker上安装MySQL 8.0,可以使用以下命令创建容器: docker run --privileged=true -p 3307:3306 --name mysql8 -v /docker/mysql8/conf:/etc/mysql/conf.d -v /docker/mysql8/logs:/var/log/mysql -v /docker/mysql8/data:/var/lib/mysql -e MYSQL_ROOT_PASSWORD=223345 -d mysql:8.0 该命令将创建一个名为mysql8的容器,并将主机的3307端口映射到容器的3306端口。配置文件、日志文件数据文件将在主机上的/docker/mysql8目录中进行持久化存储。容器将使用MySQL 8.0镜像,并设置root用户的密码为223345。<span class="em">1</span><span class="em">2</span><span class="em">3</span> #### 引用[.reference_title] - *1* *2* [docker安装myql5.7mysql8.0](https://blog.csdn.net/weixin_65349299/article/details/125860971)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v93^chatsearchT3_2"}}] [.reference_item style="max-width: 50%"] - *3* [docker安装mysql5.78.0、redis](https://blog.csdn.net/qq_45524787/article/details/126358732)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v93^chatsearchT3_2"}}] [.reference_item style="max-width: 50%"] [ .reference_list ]
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值