一、环境准备:

操作系统:CentOS Linux release 7.5.1804 (Core)

mysql版本:mysql-5.7.24-linux-glibc2.12-x86_64.tar.gz

IP:172.16.8.247

二、mysql5.7二进制安装

1、安装依赖包

yum -y install libaio

2、安装mysql软件

下载软件包:

https://cdn.mysql.com//Downloads/MySQL-5.7/mysql-5.7.24-linux-glibc2.12-x86_64.tar.gz

tar -xvf mysql-5.7.24-linux-glibc2.12-x86_64.tar.gz -C ../
cd ..
mv mysql-5.7.24-linux-glibc2.12-x86_64/ mysql5.7
useradd -s /sbin/nologin -M mysql
mkdir -p /app/mysql5.7/{etc,logs,tmp}

3、初始化数据

bin/mysqld --initialize --basedir=/app/mysql5.7/ --datadir=/app/mysql5.7/data --user=mysql

# bin/mysqld --initialize --basedir=/app/mysql5.7/ --datadir=/app/mysql5.7/data --user=mysql
2018-11-25T03:03:16.299117Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2018-11-25T03:03:16.946059Z 0 [Warning] InnoDB: New log files created, LSN=45790
2018-11-25T03:03:17.033699Z 0 [Warning] InnoDB: Creating foreign key constraint system tables.
2018-11-25T03:03:17.089657Z 0 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: a7fef663-f05e-11e8-b1f5-08002728f0e4.
2018-11-25T03:03:17.090377Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2018-11-25T03:03:17.090784Z 1 [Note] A temporary password is generated for root@localhost: m:fw/7on%>Bh

4、修改配置文件

chown -R mysql .
vim /app/mysql5.7/etc/my.cnf
[mysqld]
daemonize = on
user = mysql
port = 3306
basedir = /app/mysql5.7
datadir = /app/mysql5.7/data
socket = /tmp/mysql.sock
bind-address = 0.0.0.0
pid-file = /app/mysql5.7/tmp/mysqld.pid
character-set-server = utf8
collation-server = utf8_general_ci
max_connections = 2408
log-error = /app/mysql5.7/logs/mysqld.log

5、systemd启动MYSQL服务

vim /lib/systemd/system/mysqld.service
[Unit]
Description=MySQL Server
Documentation=man:mysqld(8)
Documentation=http://dev.mysql.com/doc/refman/en/using-systemd.html
After=network.target
After=syslog.target
[Install]
WantedBy=multi-user.target
[Service]
User=mysql
Group=mysql
Type=forking
TimeoutSec=0
PermissionsStartOnly=true
ExecStart=/app/mysql5.7/bin/mysqld --defaults-file=/app/mysql5.7/etc/my.cnf
LimitNOFILE = 5000
Restart=on-failure
RestartPreventExitStartus=1
PrivateTmp=false

6、启动服务

systemctl restart mysqld
systemctl enable mysqld

7、修改mysql root密码

vim /etc/profile
export PATH=$PATH:/app/mysql5.7/bin
source /etc/profile
mysql -uroot -p
alter user 'root'@'localhost' IDENTIFIED BY 'Devops@2018';

总结

以上所述是小编给大家介绍的Centos7.5安装mysql5.7.24二进制包方式部署,希望对大家有所帮助,如果大家有任何疑问请给我留言,小编会及时回复大家的。在此也非常感谢大家对网站的支持!

华山资源网 Design By www.eoogi.com
广告合作:本站广告合作请联系QQ:858582 申请时备注:广告合作(否则不回)
免责声明:本站资源来自互联网收集,仅供用于学习和交流,请遵循相关法律法规,本站一切资源不代表本站立场,如有侵权、后门、不妥请联系本站删除!
华山资源网 Design By www.eoogi.com

稳了!魔兽国服回归的3条重磅消息!官宣时间再确认!

昨天有一位朋友在大神群里分享,自己亚服账号被封号之后居然弹出了国服的封号信息对话框。

这里面让他访问的是一个国服的战网网址,com.cn和后面的zh都非常明白地表明这就是国服战网。

而他在复制这个网址并且进行登录之后,确实是网易的网址,也就是我们熟悉的停服之后国服发布的暴雪游戏产品运营到期开放退款的说明。这是一件比较奇怪的事情,因为以前都没有出现这样的情况,现在突然提示跳转到国服战网的网址,是不是说明了简体中文客户端已经开始进行更新了呢?