centos7安装mysql-8.0.31
服务器版本 | mysql版本 |
---|---|
centos7 | mysql-8.0.31-1.el7.x86_64.rpm-bundle.tar |
先行步骤,移除Linux自带安装的mariadb数据库
检查linux是否安装了mariadb数据库,mariadb数据库是mysql的分支。是免费开源的。由于mariadb和msyql会有冲突,安装mysql之前首先要检查是否安装了mariadb并卸载
检查命令 :
yum list installed | grep mariadb
卸载命令:
# -y 参数确认删除
yum -y remove mariadb-libs.x86_64
1.下载安装包或者直接wget下载到指定目录
wget https://dev.mysql.com/get/Downloads/MySQL-8.0/mysql-8.0.31-1.el7.x86_64.rpm-bundle.tar
2.上传服务器,并解压到指定目录
#进入安装包目录
cd /home/mysql-8.0.31
#解压命令
tar -zxvf mysql-8.0.31-1.el7.x86_64.rpm-bundle.tar
3.顺序执行rpm命令
rpm -ivh mysql-community-common-8.0.31-1.el7.x86_64.rpm
rpm -ivh mysql-community-client-plugins-8.0.31-1.el7.x86_64.rpm
rpm -ivh mysql-community-libs-8.0.31-1.el7.x86_64.rpm
rpm -ivh mysql-community-client-8.0.31-1.el7.x86_64.rpm
rpm -ivh mysql-community-icu-data-files-8.0.31-1.el7.x86_64.rpm
rpm -ivh mysql-community-server-8.0.31-1.el7.x86_64.rpm
4.修改mysql
4.1 启动mysql服务
systemctl start mysqld
4.2 获取首次启动生成的随机密码
sudo grep 'temporary password' /var/log/mysqld.log
4.3 登录mysql并修改密码
mysql -uroot -p
更新密码
ALTER USER 'root'@'localhost' IDENTIFIED BY 'MyNewPwd123';
4.4 开启允许root账户远程连接
# 切换使用mysql数据库
use mysql;
# 开启远程
update user set host='%' where user='root';
# 刷新权限
flush privileges;
4.5 退出mysql
quit;
5.开启防火墙端口允许访问
#查看防火墙状态
systemctl status firewalld
#查看开放的端口
firewall-cmd --query-port=3306/tcp
#添加端口
firewall-cmd --zone=public --add-port=3306/tcp --permanent
#重载防火墙
firewall-cmd --reload
#再次查看端口是否已经开放
firewall-cmd --query-port=3306/tcp
6.设置mysql开机自启
chkconfig配置服务的方式过于繁琐,直接使用以下命令即可
systemctl enable mysqld