一、查询以前安装的Mysql
1、rpm包安装的,可以用rpm -qa看到
命令:
rpm -qa | grep -i mysql
2、卸载以前的mysql(上面的文件一个个卸载)
命令:
yum remove mysql-community mysql-community-server mysql-community-libs mysql-community-common
yum remove mysql57-community-release-el7-8.noarch
二、安装mysql
1、官网地址
2、提取版本: mysql80-community-releasw-el9-1.noarch.rpm
三、Linux上安装mysql
1、下载
创建安装目录:
cd /usr/locale/
mkdir software
cd ./softeare
下载命令:
wget https://dev.mysql.com/get/mysql80-community-release-el7-3.noarch.rpm
2、安装mysql源:
sudo rpm -Uvh mysql80-community-release-el7-3.noarch.rpm
3、检查是否安装成功
4、安装mysql
出现:
解决:
rpm --import https://repo.mysql.com/RPM-GPG-KEY-mysql-2022
5、启动mysql
systemctl start mysqld.service
6、查看mysql状态
7、停止mysql
systemctl stop mysqld.service
四、mysql配置
1、查看mysql的初始密码
grep 'temporary password' /var/log/mysqld.log
2、修改密码,允许远程登录,刷新配置;
mysql -uroot -p
#修改密码
alter user 'root'@'localhost' identified by '你的新密码';
#允许远程登录
update user set user.Host='%' where user.User='root';
#刷新配置
flush privileges
五、设置开机自启动
systemctl enable mysqld
systemctl daemon-reload
六、关闭防火墙
# firewall防火墙
systemctl status firewalld
# 查看转态
firewall-cmd --state
# 开启
service firewalld start
# 重启
service firewalld restart
# 关闭
service firewalld stop
五、测试连接
1、查看地址:ifconfig
2、测试(密码是刚设置的密码)
大功告成。