Centos7.5安装mysql5.7.24二进制包方式部署
一、环境准备:
操作系统:CentOSLinuxrelease7.5.1804(Core)
mysql版本:mysql-5.7.24-linux-glibc2.12-x86_64.tar.gz
IP:172.16.8.247
二、mysql5.7二进制安装
1、安装依赖包
yum-yinstalllibaio
2、安装mysql软件
下载软件包:
https://cdn.mysql.com//Downloads/MySQL-5.7/mysql-5.7.24-linux-glibc2.12-x86_64.tar.gz
tar-xvfmysql-5.7.24-linux-glibc2.12-x86_64.tar.gz-C../ cd.. mvmysql-5.7.24-linux-glibc2.12-x86_64/mysql5.7 useradd-s/sbin/nologin-Mmysql 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.299117Z0[Warning]TIMESTAMPwithimplicitDEFAULTvalueisdeprecated.Pleaseuse--explicit_defaults_for_timestampserveroption(seedocumentationformoredetails). 2018-11-25T03:03:16.946059Z0[Warning]InnoDB:Newlogfilescreated,LSN=45790 2018-11-25T03:03:17.033699Z0[Warning]InnoDB:Creatingforeignkeyconstraintsystemtables. 2018-11-25T03:03:17.089657Z0[Warning]NoexistingUUIDhasbeenfound,soweassumethatthisisthefirsttimethatthisserverhasbeenstarted.GeneratinganewUUID:a7fef663-f05e-11e8-b1f5-08002728f0e4. 2018-11-25T03:03:17.090377Z0[Warning]Gtidtableisnotreadytobeused.Table'mysql.gtid_executed'cannotbeopened. 2018-11-25T03:03:17.090784Z1[Note]Atemporarypasswordisgeneratedforroot@localhost:m:fw/7on%>Bh
4、修改配置文件
chown-Rmysql. 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=MySQLServer 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、启动服务
systemctlrestartmysqld systemctlenablemysqld
7、修改mysqlroot密码
vim/etc/profile exportPATH=$PATH:/app/mysql5.7/bin source/etc/profile mysql-uroot-p alteruser'root'@'localhost'IDENTIFIEDBY'Devops@2018';
总结
以上所述是小编给大家介绍的Centos7.5安装mysql5.7.24二进制包方式部署,希望对大家有所帮助,如果大家有任何疑问请给我留言,小编会及时回复大家的。在此也非常感谢大家对毛票票网站的支持!