失眠网,内容丰富有趣,生活中的好帮手!
失眠网 > mysql安装mysql-5.7.35-1.el7.x86_64.rpm-bundle.tar 问题及其他ip访问mysql

mysql安装mysql-5.7.35-1.el7.x86_64.rpm-bundle.tar 问题及其他ip访问mysql

时间:2023-08-12 10:31:26

相关推荐

mysql安装mysql-5.7.35-1.el7.x86_64.rpm-bundle.tar 问题及其他ip访问mysql

参考文档:centos7通过rpm-bundle方式安装mysql5.7.35 - Shapley - 博客园

下载 mysql包后,

1. 解压

tar -xvf mysql-5.7.35-1.el7.x86_64.rpm-bundle.tar

2. 安装顺序

rpm -ivh mysql-community-common-5.7.35-1.el7.x86_64.rpmrpm -ivh mysql-community-libs-5.7.35-1.el7.x86_64.rpm rpm -ivh mysql-community-libs-compat-5.7.35-1.el7.x86_64.rpmrpm -ivh mysql-community-client-5.7.35-1.el7.x86_64.rpmrpm -ivh mysql-community-devel-5.7.35-1.el7.x86_64.rpmrpm -ivh mysql-community-server-5.7.35-1.el7.x86_64.rpm

3. 问题file /usr/share/mysql/czech/errmsg.sys from install of mysql-community-common-5.7.35-1.el7.x86_64 conflicts with file from package mariadb-libs-1:5.5.68-1.el7.x86_64

[root@localhost packages]# rpm -ivh mysql-community-common-5.7.35-1.el7.x86_64.rpm 警告:mysql-community-common-5.7.35-1.el7.x86_64.rpm: 头V3 DSA/SHA256 Signature, 密钥 ID 5072e1f5: NOKEY准备中...################################# [100%]file /usr/share/mysql/czech/errmsg.sys from install of mysql-community-common-5.7.35-1.el7.x86_64 conflicts with file from package mariadb-libs-1:5.5.68-1.el7.x86_64file /usr/share/mysql/danish/errmsg.sys from install of mysql-community-common-5.7.35-1.el7.x86_64 conflicts with file from package mariadb-libs-1:5.5.68-1.el7.x86_64file /usr/share/mysql/dutch/errmsg.sys from install of mysql-community-common-5.7.35-1.el7.x86_64 conflicts with file from package mariadb-libs-1:5.5.68-1.el7.x86_64file /usr/share/mysql/english/errmsg.sys from install of mysql-community-common-5.7.35-1.el7.x86_64 conflicts with file from package mariadb-libs-1:5.5.68-1.el7.x86_64file /usr/share/mysql/estonian/errmsg.sys from install of mysql-community-common-5.7.35-1.el7.x86_64 conflicts with file from package mariadb-libs-1:5.5.68-1.el7.x86_64file /usr/share/mysql/french/errmsg.sys from install of mysql-community-common-5.7.35-1.el7.x86_64 conflicts with file from package mariadb-libs-1:5.5.68-1.el7.x86_64file /usr/share/mysql/german/errmsg.sys from install of mysql-community-common-5.7.35-1.el7.x86_64 conflicts with file from package mariadb-libs-1:5.5.68-1.el7.x86_64file /usr/share/mysql/greek/errmsg.sys from install of mysql-community-common-5.7.35-1.el7.x86_64 conflicts with file from package mariadb-libs-1:5.5.68-1.el7.x86_64file /usr/share/mysql/hungarian/errmsg.sys from install of mysql-community-common-5.7.35-1.el7.x86_64 conflicts with file from package mariadb-libs-1:5.5.68-1.el7.x86_64file /usr/share/mysql/italian/errmsg.sys from install of mysql-community-common-5.7.35-1.el7.x86_64 conflicts with file from package mariadb-libs-1:5.5.68-1.el7.x86_64file /usr/share/mysql/japanese/errmsg.sys from install of mysql-community-common-5.7.35-1.el7.x86_64 conflicts with file from package mariadb-libs-1:5.5.68-1.el7.x86_64file /usr/share/mysql/korean/errmsg.sys from install of mysql-community-common-5.7.35-1.el7.x86_64 conflicts with file from package mariadb-libs-1:5.5.68-1.el7.x86_64file /usr/share/mysql/norwegian-ny/errmsg.sys from install of mysql-community-common-5.7.35-1.el7.x86_64 conflicts with file from package mariadb-libs-1:5.5.68-1.el7.x86_64file /usr/share/mysql/norwegian/errmsg.sys from install of mysql-community-common-5.7.35-1.el7.x86_64 conflicts with file from package mariadb-libs-1:5.5.68-1.el7.x86_64file /usr/share/mysql/polish/errmsg.sys from install of mysql-community-common-5.7.35-1.el7.x86_64 conflicts with file from package mariadb-libs-1:5.5.68-1.el7.x86_64file /usr/share/mysql/portuguese/errmsg.sys from install of mysql-community-common-5.7.35-1.el7.x86_64 conflicts with file from package mariadb-libs-1:5.5.68-1.el7.x86_64file /usr/share/mysql/romanian/errmsg.sys from install of mysql-community-common-5.7.35-1.el7.x86_64 conflicts with file from package mariadb-libs-1:5.5.68-1.el7.x86_64file /usr/share/mysql/russian/errmsg.sys from install of mysql-community-common-5.7.35-1.el7.x86_64 conflicts with file from package mariadb-libs-1:5.5.68-1.el7.x86_64file /usr/share/mysql/serbian/errmsg.sys from install of mysql-community-common-5.7.35-1.el7.x86_64 conflicts with file from package mariadb-libs-1:5.5.68-1.el7.x86_64file /usr/share/mysql/slovak/errmsg.sys from install of mysql-community-common-5.7.35-1.el7.x86_64 conflicts with file from package mariadb-libs-1:5.5.68-1.el7.x86_64file /usr/share/mysql/spanish/errmsg.sys from install of mysql-community-common-5.7.35-1.el7.x86_64 conflicts with file from package mariadb-libs-1:5.5.68-1.el7.x86_64file /usr/share/mysql/swedish/errmsg.sys from install of mysql-community-common-5.7.35-1.el7.x86_64 conflicts with file from package mariadb-libs-1:5.5.68-1.el7.x86_64file /usr/share/mysql/ukrainian/errmsg.sys from install of mysql-community-common-5.7.35-1.el7.x86_64 conflicts with file from package mariadb-libs-1:5.5.68-1.el7.x86_64file /usr/share/mysql/charsets/Index.xml from install of mysql-community-common-5.7.35-1.el7.x86_64 conflicts with file from package mariadb-libs-1:5.5.68-1.el7.x86_64file /usr/share/mysql/charsets/armscii8.xml from install of mysql-community-common-5.7.35-1.el7.x86_64 conflicts with file from package mariadb-libs-1:5.5.68-1.el7.x86_64file /usr/share/mysql/charsets/ascii.xml from install of mysql-community-common-5.7.35-1.el7.x86_64 conflicts with file from package mariadb-libs-1:5.5.68-1.el7.x86_64file /usr/share/mysql/charsets/cp1250.xml from install of mysql-community-common-5.7.35-1.el7.x86_64 conflicts with file from package mariadb-libs-1:5.5.68-1.el7.x86_64file /usr/share/mysql/charsets/cp1251.xml from install of mysql-community-common-5.7.35-1.el7.x86_64 conflicts with file from package mariadb-libs-1:5.5.68-1.el7.x86_64file /usr/share/mysql/charsets/cp1256.xml from install of mysql-community-common-5.7.35-1.el7.x86_64 conflicts with file from package mariadb-libs-1:5.5.68-1.el7.x86_64file /usr/share/mysql/charsets/cp1257.xml from install of mysql-community-common-5.7.35-1.el7.x86_64 conflicts with file from package mariadb-libs-1:5.5.68-1.el7.x86_64file /usr/share/mysql/charsets/cp850.xml from install of mysql-community-common-5.7.35-1.el7.x86_64 conflicts with file from package mariadb-libs-1:5.5.68-1.el7.x86_64file /usr/share/mysql/charsets/cp852.xml from install of mysql-community-common-5.7.35-1.el7.x86_64 conflicts with file from package mariadb-libs-1:5.5.68-1.el7.x86_64file /usr/share/mysql/charsets/cp866.xml from install of mysql-community-common-5.7.35-1.el7.x86_64 conflicts with file from package mariadb-libs-1:5.5.68-1.el7.x86_64file /usr/share/mysql/charsets/dec8.xml from install of mysql-community-common-5.7.35-1.el7.x86_64 conflicts with file from package mariadb-libs-1:5.5.68-1.el7.x86_64file /usr/share/mysql/charsets/geostd8.xml from install of mysql-community-common-5.7.35-1.el7.x86_64 conflicts with file from package mariadb-libs-1:5.5.68-1.el7.x86_64file /usr/share/mysql/charsets/greek.xml from install of mysql-community-common-5.7.35-1.el7.x86_64 conflicts with file from package mariadb-libs-1:5.5.68-1.el7.x86_64file /usr/share/mysql/charsets/hebrew.xml from install of mysql-community-common-5.7.35-1.el7.x86_64 conflicts with file from package mariadb-libs-1:5.5.68-1.el7.x86_64file /usr/share/mysql/charsets/hp8.xml from install of mysql-community-common-5.7.35-1.el7.x86_64 conflicts with file from package mariadb-libs-1:5.5.68-1.el7.x86_64file /usr/share/mysql/charsets/keybcs2.xml from install of mysql-community-common-5.7.35-1.el7.x86_64 conflicts with file from package mariadb-libs-1:5.5.68-1.el7.x86_64file /usr/share/mysql/charsets/koi8r.xml from install of mysql-community-common-5.7.35-1.el7.x86_64 conflicts with file from package mariadb-libs-1:5.5.68-1.el7.x86_64file /usr/share/mysql/charsets/koi8u.xml from install of mysql-community-common-5.7.35-1.el7.x86_64 conflicts with file from package mariadb-libs-1:5.5.68-1.el7.x86_64file /usr/share/mysql/charsets/latin1.xml from install of mysql-community-common-5.7.35-1.el7.x86_64 conflicts with file from package mariadb-libs-1:5.5.68-1.el7.x86_64file /usr/share/mysql/charsets/latin2.xml from install of mysql-community-common-5.7.35-1.el7.x86_64 conflicts with file from package mariadb-libs-1:5.5.68-1.el7.x86_64file /usr/share/mysql/charsets/latin5.xml from install of mysql-community-common-5.7.35-1.el7.x86_64 conflicts with file from package mariadb-libs-1:5.5.68-1.el7.x86_64file /usr/share/mysql/charsets/latin7.xml from install of mysql-community-common-5.7.35-1.el7.x86_64 conflicts with file from package mariadb-libs-1:5.5.68-1.el7.x86_64file /usr/share/mysql/charsets/macce.xml from install of mysql-community-common-5.7.35-1.el7.x86_64 conflicts with file from package mariadb-libs-1:5.5.68-1.el7.x86_64file /usr/share/mysql/charsets/macroman.xml from install of mysql-community-common-5.7.35-1.el7.x86_64 conflicts with file from package mariadb-libs-1:5.5.68-1.el7.x86_64file /usr/share/mysql/charsets/swe7.xml from install of mysql-community-common-5.7.35-1.el7.x86_64 conflicts with file from package mariadb-libs-1:5.5.68-1.el7.x86_64[root@localhost packages]#

解决方法,卸载mariadb

需要卸载mariadb-libs-1:5.5.68-1.el7.x86_64, MySQL 与mariadb 冲突;

卸载

yum remove mariadb-libs-1:5.5.68-1.el7.x86_64

然后 依次安装;

[root@localhost packages]# rpm -ivh mysql-community-common-5.7.35-1.el7.x86_64.rpm 警告:mysql-community-common-5.7.35-1.el7.x86_64.rpm: 头V3 DSA/SHA256 Signature, 密钥 ID 5072e1f5: NOKEY准备中...################################# [100%]正在升级/安装...1:mysql-community-common-5.7.35-1.e################################# [100%][root@localhost packages]# [root@localhost packages]# [root@localhost packages]# [root@localhost packages]# rpm -ivh mysql-community-libs-5.7.35-1.el7.x86_64.rpm 警告:mysql-community-libs-5.7.35-1.el7.x86_64.rpm: 头V3 DSA/SHA256 Signature, 密钥 ID 5072e1f5: NOKEY准备中...################################# [100%]正在升级/安装...1:mysql-community-libs-5.7.35-1.el7################################# [100%][root@localhost packages]# [root@localhost packages]# rpm -ivh mysql-community-libs-compat-5.7.35-1.el7.x86_64.rpm 警告:mysql-community-libs-compat-5.7.35-1.el7.x86_64.rpm: 头V3 DSA/SHA256 Signature, 密钥 ID 5072e1f5: NOKEY准备中...################################# [100%]正在升级/安装...1:mysql-community-libs-compat-5.7.3################################# [100%][root@localhost packages]# [root@localhost packages]# [root@localhost packages]# rpm -ivh mysql-community-client-5.7.35-1.el7.x86_64.rpm 警告:mysql-community-client-5.7.35-1.el7.x86_64.rpm: 头V3 DSA/SHA256 Signature, 密钥 ID 5072e1f5: NOKEY准备中...################################# [100%]正在升级/安装...1:mysql-community-client-5.7.35-1.e################################# [100%][root@localhost packages]# [root@localhost packages]# rpm -ivh mysql-community-devel-5.7.35-1.el7.x86_64.rpm 警告:mysql-community-devel-5.7.35-1.el7.x86_64.rpm: 头V3 DSA/SHA256 Signature, 密钥 ID 5072e1f5: NOKEY准备中...################################# [100%]正在升级/安装...1:mysql-community-devel-5.7.35-1.el################################# [100%][root@localhost packages]# [root@localhost packages]# rpm -ivh mysql-community-server-5.7.35-1.el7.x86_64.rpm 警告:mysql-community-server-5.7.35-1.el7.x86_64.rpm: 头V3 DSA/SHA256 Signature, 密钥 ID 5072e1f5: NOKEY准备中...################################# [100%]正在升级/安装...1:mysql-community-server-5.7.35-1.e################################# [100%][root@localhost packages]#

如果安装:rpm -ivh mysql-community-server-5.7.35-1.el7.x86_64.rpm 报错:

[root@C0509116252 mysql-5.7.35]# rpm -ivh mysql-community-server-5.7.35-1.el7.x86_64.rpm

warning: mysql-community-server-5.7.35-1.el7.x86_64.rpm: Header V3 DSA/SHA256 Signature, key ID 5072e1f5: NOKEY

error: Failed dependencies:

/usr/bin/perl is needed by mysql-community-server-5.7.35-1.el7.x86_64

libaio.so.1()(64bit) is needed by mysql-community-server-5.7.35-1.el7.x86_64

libaio.so.1(LIBAIO_0.1)(64bit) is needed by mysql-community-server-5.7.35-1.el7.x86_64

libaio.so.1(LIBAIO_0.4)(64bit) is needed by mysql-community-server-5.7.35-1.el7.x86_64

perl(Getopt::Long) is needed by mysql-community-server-5.7.35-1.el7.x86_64

perl(strict) is needed by mysql-community-server-5.7.35-1.el7.x86_64

[root@C0509116252 mysql-5.7.35]#

那么

yum install libaio

yum install perl

查看mysqld状态

systemctl status mysqld.service

启动mysql

systemctl start mysqld.service

第一次登陆查看密码

grep 'temporary password' /var/log/mysqld.log

密码为:WbpvVLfMr5<Y

登录msyql

mysql -u root -p

首次登录查看 提示修改密码;

set password for root@localhost = password('NewPassword..');

###注 ,mysql密码,要 大小写+数字+特殊字符

my.conf 配置文件位置 /etc/my.conf

==============================

========================

开启防火墙端口 3306

firewall-cmd --zone=public --add-port=3306/tcp --permanent

查看防火墙状态

systemctl status firewalld.service

设置 ,其他指定 ip 访问mysql

数据库实例名 如: zabbix_server

用户名,随意些,如果未创建则,自动创建;如果已有 则 不变;

grant all privileges on 数据库实例名.* to 用户名@"192.168.40.202" identified by"密码";

让全部ip ,访问 全部 mysql

grant all privileges on *.* to 用户名@"%" identified by"密码";

如果觉得《mysql安装mysql-5.7.35-1.el7.x86_64.rpm-bundle.tar 问题及其他ip访问mysql》对你有帮助,请点赞、收藏,并留下你的观点哦!

本内容不代表本网观点和政治立场,如有侵犯你的权益请联系我们处理。
网友评论
网友评论仅供其表达个人看法,并不表明网站立场。