Centos7.5安裝mysql5.7.24二進(jìn)制包方式部署
一、環(huán)境準(zhǔn)備：
操作系統(tǒng)：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二進(jìn)制安裝
1、安裝依賴(lài)包
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、初始化數(shù)據(jù)
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啟動(dòng)MYSQL服務(wù)
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、啟動(dòng)服務(wù)
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';
總結(jié)
以上所述是小編給大家介紹的Centos7.5安裝mysql5.7.24二進(jìn)制包方式部署，希望對(duì)大家有所幫助，如果大家有任何疑問(wèn)請(qǐng)給我留言，小編會(huì)及時(shí)回復(fù)大家的。在此也非常感謝大家對(duì)本站網(wǎng)站的支持！
版權(quán)聲明：本站文章來(lái)源標(biāo)注為YINGSOO的內(nèi)容版權(quán)均為本站所有，歡迎引用、轉(zhuǎn)載，請(qǐng)保持原文完整并注明來(lái)源及原文鏈接。禁止復(fù)制或仿造本網(wǎng)站，禁止在非maisonbaluchon.cn所屬的服務(wù)器上建立鏡像，否則將依法追究法律責(zé)任。本站部分內(nèi)容來(lái)源于網(wǎng)友推薦、互聯(lián)網(wǎng)收集整理而來(lái)，僅供學(xué)習(xí)參考，不代表本站立場(chǎng)，如有內(nèi)容涉嫌侵權(quán)，請(qǐng)聯(lián)系alex-e#qq.com處理。
關(guān)注官方微信