centos7安装mysql5.7.41

参考链接

https://blog.csdn.net/wudinaniya/article/details/81094578

安装包下载链接

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

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

解压文件

tar -xvf ../mysql-5.7.41-1.el7.x86_64.rpm-bundle.tar

删除mariadb

原因

查看是否安装

rpm -qa|grep mariadb

删除命令

rpm -e --nodeps mariadb-libs

安装MySQL

安装顺序

rpm -ivh mysql-community-common-5.7.41-1.el7.x86_64.rpm 

rpm -ivh mysql-community-libs-5.7.41-1.el7.x86_64.rpm 

rpm -ivh mysql-community-client-5.7.41-1.el7.x86_64.rpm

rpm -ivh mysql-community-server-5.7.41-1.el7.x86_64.rpm 

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

问题解决

参考链接：

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

yum install net-tools

yum install -y perl-Module-Install.noarch

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

MySQL的启动

查看MySQL的运行状态

systemctl status mysqld

启动

systemctl start mysqld

查看mysql进程

ps -ef|grep mysql  

查看3306端口

netstat -anop|grep 3306

修改初始密码

查看初始密码

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

进入mysql

mysql -uroot -p

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

使mysql可远程登录

grant all privileges on *.* to root@'%' identified by 'neuNEU210!';

新建用户mysql，通过mysql用户远程访问

CREATE USER 'mysql'@'%' IDENTIFIED BY 'neuNEU210!';

grant all privileges on *.* to mysql@'%' identified by 'neuNEU210!';

刷新权限，使设置生效， OK。

FLUSH PRIVILEGES;

查看用户连接方式：

select user,host from user;

使用windows的窗口进行访问

mysql -u mysql -p -h 192.168.248.110