MySQL在centos上的安装
创始人
2024-04-11 03:21:23
0

去mysql官网下载mysql

通过mysql官网的download界面,找到community server,然后选择对应linux版本下载对应的安装包
这里直接上链接
https://downloads.mysql.com/archives/community/
可以通过cat /etc/centos-release命令找到当前centos对应的版本

下载&安装myslq-community-server安装包

在这里插入图片描述

yum install mysql-community-server-8.0.31-1.el7.x86_64.rpm

安装后遇到以下问题:

--> Finished Dependency Resolution
Error: Package: mysql-community-server-8.0.31-1.el7.x86_64 (/mysql-community-server-8.0.31-1.el7.x86_64)Requires: mysql-community-client(x86-64) >= 8.0.11
Error: Package: mysql-community-server-8.0.31-1.el7.x86_64 (/mysql-community-server-8.0.31-1.el7.x86_64)Requires: mysql-community-icu-data-files = 8.0.31-1.el7
Error: Package: mysql-community-server-8.0.31-1.el7.x86_64 (/mysql-community-server-8.0.31-1.el7.x86_64)Requires: mysql-community-common(x86-64) = 8.0.31-1.el7

原因是因为缺少对应的依赖,对应的依赖在下载页面可以找到
在这里插入图片描述
然后下载对应的rpm文件进行安装

rpm -Uvh mysql-community-icu-data-files-8.0.30-1.el7.x86_64.rpm 
rpm -Uvh mysql-community-common-8.0.30-1.el7.x86_64.rpm 

安装这俩文件包十分顺利,但是安装第三个包时出现问题

rpm -Uvh mysql-community-client-8.0.30-1.el7.x86_64.rpm 

报错

error: Failed dependencies:mysql-community-client-plugins = 8.0.30-1.el7 is needed by mysql-community-client-8.0.30-1.el7.x86_64mysql-community-libs(x86-64) >= 8.0.11 is needed by mysql-community-client-8.0.30-1.el7.x86_64

不就是缺少依赖吗?继续找
在这里插入图片描述
找到其中一个依赖,安装,没毛病

rpm -Uvh mysql-community-client-plugins-8.0.30-1.el7.x86_64.rpm

再继续找,也找到了
在这里插入图片描述
安装

rpm -Uvh mysql-community-libs-8.0.30-1.el7.x86_64.rpm 

有毛病,遇到问题了

error: Failed dependencies:libmysqlclient.so.18()(64bit) is needed by (installed) postfix-2:2.10.1-9.el7.x86_64libmysqlclient.so.18(libmysqlclient_18)(64bit) is needed by (installed) postfix-2:2.10.1-9.el7.x86_64

遇到这个问题,是因为centos的默认数据库是 mariadb ,这两个包已经被mariadb数据库所依赖了

[root@VM-0-13-centos mysql]# rpm -qa | grep mariadb
mariadb-libs-5.5.68-1.el7.i686
mariadb-libs-5.5.68-1.el7.x86_64

强制删除mariadb数据库,释放这个包

rpm -e --nodeps mariadb-libs-5.5.68-1.el7.x86_64
rpm -e --nodeps mariadb-libs-5.5.68-1.el7.i686

再次安装剩余的包

[root@VM-0-13-centos mysql]# rpm -ivh mysql-community-libs-8.0.30-1.el7.x86_64.rpm 
warning: mysql-community-libs-8.0.30-1.el7.x86_64.rpm: Header V4 RSA/SHA256 Signature, key ID 3a79bd29: NOKEY
Preparing...                          ################################# [100%]
Updating / installing...1:mysql-community-libs-8.0.30-1.el7################################# [100%]
[root@VM-0-13-centos mysql]# rpm -Uvh mysql-community-client-8.0.30-1.el7.x86_64.rpm 
warning: mysql-community-client-8.0.30-1.el7.x86_64.rpm: Header V4 RSA/SHA256 Signature, key ID 3a79bd29: NOKEY
Preparing...                          ################################# [100%]
Updating / installing...1:mysql-community-client-8.0.30-1.e################################# [100%]

完美通过

检查mysql是否安装成功

查看当前mysql服务状态

[root@VM-0-13-centos mysql]# systemctl status mysqld.service
● mysqld.service - MySQL ServerLoaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor preset: disabled)Active: inactive (dead)Docs: man:mysqld(8)http://dev.mysql.com/doc/refman/en/using-systemd.html

当前mysql为未启动状态

启动mysql服务

[root@VM-0-13-centos mysql]# systemctl start mysqld.service

再次查看mysql状态

[root@VM-0-13-centos mysql]# systemctl status mysqld.service
● mysqld.service - MySQL ServerLoaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor preset: disabled)Active: active (running) since Tue 2022-11-22 02:10:28 CST; 4s agoDocs: man:mysqld(8)http://dev.mysql.com/doc/refman/en/using-systemd.htmlProcess: 12896 ExecStartPre=/usr/bin/mysqld_pre_systemd (code=exited, status=0/SUCCESS)Main PID: 13014 (mysqld)Status: "Server is operational"CGroup: /system.slice/mysqld.service└─13014 /usr/sbin/mysqldNov 22 02:10:20 VM-0-13-centos systemd[1]: Starting MySQL Server...
Nov 22 02:10:28 VM-0-13-centos systemd[1]: Started MySQL Server.

mysql已经是启动状态了

获取mysql初始密码

[root@VM-0-13-centos mysql]# grep "password" /var/log/mysqld.log 
2022-11-21T18:10:23.266077Z 6 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: UGWyvk3l?tWE

进入数据库&修改密码

[root@VM-0-13-centos mysql]# mysql -uroot -pUGWyvk3l?tWE
mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'xxxxxxx';
Query OK, 0 rows affected (0.02 sec)

到此,数据库就安装成功啦

相关内容

热门资讯

前端-session、jwt 目录:   (1)session (2&#x...
linux入门---制作进度条 了解缓冲区 我们首先来看看下面的操作: 我们首先创建了一个文件并在这个文件里面添加了...
关于测试,我发现了哪些新大陆 关于测试 平常也只是听说过一些关于测试的术语,但并没有使用过测试工具。偶然看到编程老师...
前缀和与对数器与二分法 1. 前缀和 假设有一个数组,我们想大量频繁的去访问L到R这个区间的和,...
nodejs:本地安装nvm实... 一、背景-使用不同版本node的原因 vue3+ts、nuxt3版本,node...
JAVA集合知识整理 Java集合知识整理 HashMap相关 HashMap的底层数据结构:jdk1.8之...
无刷直流电机介绍及单片机控制实... 无刷直流电机介绍及单片机控制实例前言基本概念优势与劣势使用寿命基本结构使用单片机控制实例电子调速器&...
fwdiary(2) dp2 1.传纸条  AcWing 275. 传纸条 - AcWing 走两条路,走一条最大的...
常用的DOS命令 常用的DOS命令 DOS(Disk Operating System,磁...
<C++> 类和对象(下) 1.const成员函数将const修饰的“成员函数”称之为const成员函数,cons...