测试环境
CentOS Linux release 7.9.2009 (Core)
1.准备工作
下载离线安装包:
1.1 浏览器打开地址:https://dev.mysql.com/downloads/mysql/
1.2 选择对应平台:
我这里选择操作系统为Red Hat Enterprise Linux / Oracle Linux
,系统版本选择Red Hat Enterprise Linux 7 / Oracle Linux 7 (x86, 64-bit)
1.3 将下载好的软件包上传到服务器
本次测试下载得到的包名称为
mysql-8.0.29-1.el7.x86_64.rpm-bundle.tar
2.安装过程
2.1 解压缩并安装
# 如果以前安装过mysql或者Mariadb,执行这句:
rm -rf /var/lib/mysql/*
#解压缩
tar --no-same-owner -xvf mysql-8.0.29-1.el7.x86_64.rpm-bundle.tar
rpm -Uvh *.rpm --nodeps --force
3.启动服务并验证
systemctl start mysqld
systemctl status mysqld
4. 注册为服务
systemctl enable mysqld
systemctl daemon-reload
5. 配置MySQL
修改root密码
# 获取临时密码
cat /var/log/mysqld.log |grep 'temporary password'
# 登录mysql
mysql -u root -p
#修改root密码
#注意密码强度,太弱会执行失败
alter user 'root'@'localhost' identified by '你的密码';
flush privileges;
select user,host from mysql.user;
# 设置文件夹
mkdir /mysql_data
cd /mysql_data
mkdir data log binlog
# 打开mysql配置文件进行修改
vi /etc/my.cnf
修改后如下:
[mysqld]
port=3306
character_set_server=utf8
init_connect='SET NAMES utf8'
datadir=/mysql_data/data
socket=/var/lib/mysql/mysql.sock
symbolic-links=0
log-error=/mysql_data/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
server-id=1
log-bin=/mysql_data/binlog/bin-log
max_allowed_packet=10485760
max_connections=1000
default-time-zone = '+08:00'
cp -r /var/lib/mysql/* /mysql_data/data
chown -R mysql:mysql /mysql_data
systemctl restart mysqld
systemctl status mysqld