两台主机搭建lnmp服务

两台主机搭建lnmp服务

lnmp服务

准备环境

主机ip	安装软件
192,168,233,10	mysql php zabbix
192.168.233.20	nginx

1.在主机192,168,233,10上源码安装mysql php

[root@localhost ~]# yum -y install ncurses-devel openssl-devel openssl cmake mariadb-devel

//创建用户和组

[root@localhost src]# groupadd -r -g 306 mysql
[root@localhost src]# useradd -M -s /sbin/nologin -g 306 -u 306 mysql

//解压软件至/usr/local/

[root@localhost src]# ls
debug  kernels  mysql-5.7.22-linux-glibc2.12-x86_64.tar.gz
[root@localhost src]# tar xf mysql-5.7.22-linux-glibc2.12-x86_64.tar.gz -C /usr/local/
[root@localhost ~]# ls /usr/local/
bin  games    lib    libexec                              sbin   src
etc  include  lib64  mysql-5.7.22-linux-glibc2.12-x86_64  share

//下载二进制格式的mysql软件包

[root@localhost ~]# cd /usr/local
[root@localhost local]# ln -sv mysql-5.7.23-linux-glibc2.12-x86_64/ mysql
‘mysql’ -> ‘mysql-5.7.23-linux-glibc2.12-x86_64/’
[root@localhost local]# ll
total 0
drwxr-xr-x. 13 root root 152 Feb 20 01:39 apache
drwxr-xr-x.  6 root root  58 Feb 20 01:27 apr
drwxr-xr-x.  5 root root  43 Feb 20 01:29 apr-util
drwxr-xr-x.  2 root root   6 Mar 10  2016 bin
drwxr-xr-x.  2 root root   6 Mar 10  2016 etc
drwxr-xr-x.  2 root root   6 Mar 10  2016 games
drwxr-xr-x.  2 root root   6 Mar 10  2016 include
drwxr-xr-x.  2 root root   6 Mar 10  2016 lib
drwxr-xr-x.  2 root root   6 Mar 10  2016 lib64
drwxr-xr-x.  2 root root   6 Mar 10  2016 libexec
lrwxrwxrwx.  1 root root  36 Feb 20 01:48 mysql -> mysql-5.7.23-linux-glibc2.12-x86_64/
drwxr-xr-x.  9 root root 129 Feb 20 01:47 mysql-5.7.23-linux-glibc2.12-x86_64
drwxr-xr-x.  2 root root   6 Mar 10  2016 sbin
drwxr-xr-x.  5 root root  49 Feb 18 03:59 share
drwxr-xr-x.  2 root root   6 Mar 10  2016 src

//修改目录/usr/local/mysql的属主属组

[root@localhost local]# chown -R mysql.mysql /usr/local/mysql
[root@localhost local]# ll /usr/local/mysql -d
lrwxrwxrwx. 1 mysql mysql 36 Feb 20 01:48 /usr/local/mysql -> mysql-5.7.23-linux-glibc2.12-x86_64/

//添加环境变量

[root@localhost ~]# ls /usr/local/mysql
bin  COPYING  docs  include  lib  man  README  share  support-files
[root@localhost ~]# echo 'export PATH=/usr/local/mysql/bin:$PATH' > /etc/profile.d/mysql.sh
[root@localhost ~]# . /etc/profile.d/mysql.sh
[root@localhost ~]# echo $PATH
/usr/local/mysql/bin:/usr/local/apache/bin:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/root/bin

//建立数据存放目录

[root@localhost ~]# mkdir /opt/data
[root@localhost ~]# chown -R mysql.mysql /opt/data/
[root@localhost ~]# ll /opt/
total 0
drwxr-xr-x. 2 mysql mysql 6 Feb 20 02:04 data

//初始化数据库

[root@localhost ~]# /usr/local/mysql/bin/mysqld --initialize --user=mysql --datadir=/opt/data/
2019-02-20T07:05:14.920035Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2019-02-20T07:05:19.027724Z 0 [Warning] InnoDB: New log files created, LSN=45790
2019-02-20T07:05:20.108182Z 0 [Warning] InnoDB: Creating foreign key constraint system tables.
2019-02-20T07:05:20.536652Z 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: e2955a52-34dd-11e9-a0fd-000c29c6e1a8.
2019-02-20T07:05:20.537729Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2019-02-20T07:05:20.538850Z 1 [Note] A temporary password is generated for root@localhost: BcJ5cCpyrr;t

//请注意，这个命令的最后会生成一个临时密码，此处密码是BcJ5cCpyrr;t
//再次注意，这个密码是随机的，你的不会跟我一样，一定要记住这个密码，因为一会登录时会用到

//配置mysql

[root@localhost ~]# ln -s