centos7安装mysql8.0.32

参考链接

https://blog.csdn.net/Escorts/article/details/118941623

安装包下载链接

https://dev.mysql.com/downloads/mysql/

下载后的文件上传到服务器，通过xftp进行安装

解压文件

1
tar -xvf ../mysql-8.0.32-1.el7.x86_64.rpm-bundle.tar -C ./

删除mariadb

查看是否安装

1
rpm -qa|grep mariadb

删除命令

1
rpm -e --nodeps mariadb-libs

安装MySQL

安装顺序

1
rpm -ivh mysql-community-common-8.0.32-1.el7.x86_64.rpm
1
rpm -ivh mysql-community-client-plugins-8.0.32-1.el7.x86_64.rpm
1
rpm -ivh mysql-community-libs-8.0.32-1.el7.x86_64.rpm
1
rpm -ivh mysql-community-client-8.0.32-1.el7.x86_64.rpm
1
rpm -ivh mysql-community-icu-data-files-8.0.32-1.el7.x86_64.rpm 
1
rpm -ivh mysql-community-server-8.0.32-1.el7.x86_64.rpm

报错，依赖检测失败

1
2
3
4
5
6
7
[root@localhost mysql8]# rpm -ivh mysql-community-server-8.0.32-1.el7.x86_64.rpm 
警告：mysql-community-server-8.0.32-1.el7.x86_64.rpm: 头V4 RSA/SHA256 Signature, 密钥 ID 3a79bd29: NOKEY
错误：依赖检测失败：
	/usr/bin/perl 被 mysql-community-server-8.0.32-1.el7.x86_64 需要
	net-tools 被 mysql-community-server-8.0.32-1.el7.x86_64 需要
	perl(Getopt::Long) 被 mysql-community-server-8.0.32-1.el7.x86_64 需要
	perl(strict) 被 mysql-community-server-8.0.32-1.el7.x86_64 需要

问题解决

参考链接：

https://blog.csdn.net/YZL40514131/article/details/121548856

1
yum install net-tools
1
yum install -y perl-Module-Install.noarch

执行完成两条语句之后， rpm -ivh mysql-community-server-8.0.32-1.el7.x86_64.rpm 可以正常执行

MySQL的启动

启动服务

查看MySQL的运行状态

1
systemctl status mysqld

启动

1
systemctl start mysqld

修改初始密码

查询初始密码

1
less /var/log/mysqld.log

修改密码

1
mysqladmin -u root -p password

使mysql可远程登录

https://blog.csdn.net/zhazhagu/article/details/81064406

1
CREATE USER 'mysql'@'%' IDENTIFIED BY 'password!';
1
GRANT ALL PRIVILEGES ON *.* TO 'mysql'@'%';

刷新配置

1
FLUSH PRIVILEGES;

使用windows的窗口进行访问

1
mysql -u mysql -p -h 192.168.248.111
04_MySQL
#MySQL #linux #centos
centos7安装mysql8.0.32
http://yuanql.top/2023/03/24/04_MySQL/centos7安装mysql8.0.32/
作者
Qingli Yuan
发布于
2023年3月24日
许可协议