lnmp

分离部署lnmp

服务器类型	地址ip	应用	操作系统
nginx	172.16.195.118	nginx	centos7/redhat7
mysql	172.16.195.119	mysql	centos7/redhat7
php	172.16.195.120	php	centos7/redhat7

安装mysql

    安装依赖包
            [root@mysql ~]# yum -y install ncurses-devel openssl-devel openssl cmake mariadb-devel
已加载插件：product-id, search-disabled-repos, subscription-manager
This system is not registered with an entitlement server. You can us
创建用户和组
[root@mysql ~]# groupadd -r -g 306 mysql
[root@mysql ~]# useradd -M -s /sbin/nologin -g 306 -u 306 mysql

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

[root@mysql ~]# cd /usr/src/
    wget https://downloads.mysql.com/archives/get/file/mysql-5.7.22-linux-glibc2.12-x86_64.tar.gz

解压软件至/usr/local/

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

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

[root@mysql local]# chown -R mysql.mysql /usr/local/mysql
[root@mysql local]# ll /usr/local/mysql -d
lrwxrwxrwx. 1 mysql mysql 36 8月   8 20:52 /usr/local/mysql -> mysql-5.7.22-linux-glibc2.12-x86_64/ 

添加环境变量

 [root@mysql local]# echo 'export PATH=/usr/local/mysql/bin:$PATH' > /etc/profile.d/mysql.sh
[root@mysql local]# . /etc/profile.d/mysql.sh
[root@mysql local]# echo $PATH
/usr/local/mysql/bin:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/root/bin

建立数据存放目录

[root@mysql local]# mkdir /opt/data
[root@mysql local]# chown -R mysql.mysql /opt/data/
[root@mysql local]#  ll /opt/
总用量 0
drwxr-xr-x. 2 mysql mysql 6 8月   8 20:53 data 

初始化数据库

[root@mysql local]# /usr/local/mysql/bin/mysqld --initialize --user=mysql --datadir=/opt/data/
2019-08-08T12:54:23.084494Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2019-08-08T12:54:23.293206Z 0 [Warning] InnoDB: New log files created, LSN=45790
2019-08-08T12:54:23.381855Z 0 [Warning] InnoDB: Creating foreign