1.准备环境:
yum update -y
yum install -y libaio
yum install -y net-tools
yum install openssl-devel.x86_64 openssl.x86_64 -y
yum -y install autoconf
yum install perl.x86_64 perl-devel.x86_64 -y
yum install perl-JSON.noarch -y
yum install perl-Test-Simple -y
2.解压压缩包:
tar -xvf mysql-8.0.39-1.el7.x86_64.rpm-bundle.tar
3.安装mysql
rpm -ivh mysql-community-common-8.0.39-1.el7.x86_64.rpm
rpm -ivh mysql-community-client-plugins-8.0.39-1.el7.x86_64.rpm
rpm -ivh mysql-community-libs-8.0.39-1.el7.x86_64.rpm
rpm -ivh mysql-community-client-8.0.39-1.el7.x86_64.rpm
rpm -ivh mysql-community-icu-data-files-8.0.39-1.el7.x86_64.rpm
rpm -ivh mysql-community-server-8.0.39-1.el7.x86_64.rpm
rpm -ivh mysql-community-libs-compat-8.0.39-1.el7.x86_64.rpm
rpm -ivh mysql-community-embedded-compat-8.0.39-1.el7.x86_64.rpm
rpm -ivh mysql-community-devel-8.0.39-1.el7.x86_64.rpm
4.编辑mysql设置文件
不要修改原有数据目录,会导致数据目录一直表现被证书占用
[mysqld]
# 默认使用“mysql_native_password”插件认证
default_authentication_plugin=mysql_native_password
# 指定 MySQL 数据库的默认字符集
character-set-server=utf8mb4
# 设置client毗连mysql时的字符集,防止乱码
init_connect='SET NAMES utf8mb4'
# 是否对sql语句大小写敏感，1表示不敏感
lower_case_table_names = 1
5.授权设置文件:
chown -R 600 /etc/my.cnf
chmod -R 777 mysql
6.启动mysql:
sudo systemctl set-environment MYSQLD_OPTS="--skip-grant-tables" 设置免密登录,但是如果设置完密码肯定要重新设置去掉,否则外网访问不了
sudo systemctl set-environment MYSQLD_OPTS=""
#启动服务
systemctl start mysqld
#查看版本信息
mysql -V
#查看状态
systemctl status mysqld
##开机启动
systemctl enable mysqld
systemctl daemon-reload
免责声明：如果侵犯了您的权益，请联系站长，我们会及时删除侵权内容，谢谢合作！更多信息从访问主页：qidao123.com:ToB企服之家，中国第一个企服评测及商务社交产业平台。 |
