测试环境
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 解压缩并安装
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 -u root -p
alter user 'root'@'localhost' identified by '你的密码';
flush privileges;
select user,host from mysql.user;
mkdir /mysql_data
cd /mysql_data
mkdir data log binlog
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
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系:hwhale#tublm.com(使用前将#替换为@)