毕业设计之LNP+DISCUZ +分离的数据库操作
阅读原文时间:2023年07月11日阅读:2

环境介绍:

CentOS6.9最小化安装

https://nginx.org/download/nginx-1.16.1.tar.gz

https://www.php.net/distributions/php-7.3.14.tar.gz

https://cdn.mysql.com//Downloads/MySQL-5.7/mysql-boost-5.7.29.tar.gz

nginx+php主机:192.168.111.141

mysql主机:192.168.111.151

nginx install 192.168.111.141

yum install -y gcc gcc-c++ autoconf automake zlib zlib-devel openssl openssl-devel pcre* make gd-devel libjpeg-devel
libpng-devel libxml2-devel bzip2-devel libcurl-devel wget unzip

[root@webtwo.quan.bbs ~]$cd /data/packages/
[root@webtwo.quan.bbs packages]$wget https://nginx.org/download/nginx-1.16.1.tar.gz
[root@webtwo.quan.bbs packages]$tar -xvzf nginx-1.16.1.tar.gz
[root@webtwo.quan.bbs packages]$cd nginx-1.16.1
[root@webtwo.quan.bbs nginx-1.16.1]$./configure --prefix=/usr/local/software/nginx1.16.1 \

--user=nginx \
--group=nginx \
--with-http_ssl_module \
--with-http_v2_module \
--with-http_stub_status_module \
--with-pcre
[root@webtwo.quan.bbs nginx-1.16.1]$make &&make install

  建立软连接,便于命令和软件的升级

[root@webtwo.quan.bbs nginx-1.16.1]$ ln -s /usr/local/software/nginx1.16.1 /usr/local/nginx

[root@webtwo.quan.bbs nginx-1.16.1]$ln -s /usr/local/software/nginx1.16.1/sbin/nginx /usr/local/sbin/

编写启动脚本(官网:https://www.nginx.com/resources/wiki/start/topics/examples/redhatnginxinit/

我们只需要修改几个地方

vim /etc/init.d/nginx

#!/bin/sh

nginx - this script starts and stops the nginx daemon

chkconfig: - 85 15

description: NGINX is an HTTP(S) server, HTTP(S) reverse \

proxy and IMAP/POP3 proxy server

processname: nginx

config: /usr/local/nginx/conf/nginx.conf

config: /etc/sysconfig/nginx

pidfile: /var/run/nginx.pid

Source function library.

. /etc/rc.d/init.d/functions

Source networking configuration.

. /etc/sysconfig/network

Check that networking is up.

[ "$NETWORKING" = "no" ] && exit 0

##########修改nginx执行文件的路径##########
nginx="/usr/local/nginx/sbin/nginx"

prog=$(basename $nginx)

###########修改nginx配置文件路径########
NGINX_CONF_FILE="/usr/local/nginx/conf/nginx.conf"

[ -f /etc/sysconfig/nginx ] && . /etc/sysconfig/nginx

lockfile=/var/lock/subsys/nginx

make_dirs() {
# make required directories
user=`$nginx -V 2>&1 | grep "configure arguments:.*--user=" | sed 's/[^*]*--user=\([^ ]*\).*/\1/g' -`
if [ -n "$user" ]; then
if [ -z "`grep $user /etc/passwd`" ]; then
useradd -M -s /bin/nologin $user
fi
options=`$nginx -V 2>&1 | grep 'configure arguments:'`
for opt in $options; do
if [ `echo $opt | grep '.*-temp-path'` ]; then
value=`echo $opt | cut -d "=" -f 2`
if [ ! -d "$value" ]; then
# echo "creating" $value
mkdir -p $value && chown -R $user $value
fi
fi
done
fi
}

start() {
[ -x $nginx ] || exit 5
[ -f $NGINX_CONF_FILE ] || exit 6
make_dirs
echo -n $"Starting $prog: "
daemon $nginx -c $NGINX_CONF_FILE
retval=$?
echo
[ $retval -eq 0 ] && touch $lockfile
return $retval
}

stop() {
echo -n $"Stopping $prog: "
killproc $prog -QUIT
retval=$?
echo
[ $retval -eq 0 ] && rm -f $lockfile
return $retval
}

restart() {
configtest || return $?
stop
sleep 1
start
}

reload() {
configtest || return $?
echo -n $"Reloading $prog: "
killproc $nginx -HUP
RETVAL=$?
echo
}

force_reload() {
restart
}

configtest() {
$nginx -t -c $NGINX_CONF_FILE
}

rh_status() {
status $prog
}

rh_status_q() {
rh_status >/dev/null 2>&1
}

case "$1" in
start)
rh_status_q && exit 0
$1
;;
stop)
rh_status_q || exit 0
$1
;;
restart|configtest)
$1
;;
reload)
rh_status_q || exit 7
$1
;;
force-reload)
force_reload
;;
status)
rh_status
;;
condrestart|try-restart)
rh_status_q || exit 0
;;
*)
echo $"Usage: $0 {start|stop|status|restart|condrestart|try-restart|reload|force-reload|configtest}"
exit 2
esac

设置自启动nginx

[root@webone.quan.bbs tmp]$chmod 755 /etc/init.d/nginx
[root@webone.quan.bbs tmp]$chkconfig --add nginx
[root@webone.quan.bbs tmp]$chkconfig nginx on
[root@webone.quan.bbs tmp]$service nginx start
[root@webone.quan.bbs tmp]$ps aux |grep nginx
nginx 96581 0.0 1.2 123832 12360 ? S 00:00 0:03 php-fpm: pool www
nginx 96582 0.0 0.9 121444 9624 ? S 00:00 0:03 php-fpm: pool www
root 98610 0.0 0.1 46972 1228 ? Ss 20:37 0:00 nginx: master process /usr/local/nginx/sbin/nginx -c /usr/local/nginx/conf/nginx.conf
nginx 98612 0.0 0.2 47436 2288 ? S 20:37 0:00 nginx: worker process

测试nginx是否成功:

客服端访问出现nginx首页即可

PHP install  192.168.111.141

[root@webone.quan.bbs packages]$tar -zvxf php-7.3.14.tar.gz
[root@webone.quan.bbs packages]$cd php-7.3.14

./configure --prefix=/usr/local/software/php7.3.14 \
--with-fpm-user=nginx \
--with-fpm-group=nginx \
--with-curl \
--with-freetype-dir \
--with-gd \
--with-png-dir \
--with-jpeg-dir \
--with-gettext \
--with-iconv-dir \
--with-kerberos \
--with-libdir=lib64 \
--with-libxml-dir \
--with-mysqli \
--with-openssl \
--with-pcre-regex \
--with-pdo-mysql \
--with-pdo-sqlite \
--with-pear \
--with-xmlrpc \
--with-xsl \
--with-zlib \
--with-bz2 \
--with-mhash \
--enable-fpm \
--enable-bcmath \
--enable-libxml \
--enable-inline-optimization \
--enable-mbregex \
--enable-mbstring \
--enable-opcache \
--enable-pcntl \
--enable-shmop \
--enable-soap \
--enable-sockets \
--enable-sysvsem \
--enable-sysvshm \
--enable-xml \
--enable-zip \
--enable-ctype\
--enable-fpm

编译可能出现的问题

1111

错误

checking for XSL support… yes
configure: error: xslt-config not found. Please reinstall the libxslt >= 1.1.0 distribution

解决:

yum -y install libxslt libxslt-devel

2222

错误
checking for libzip… not found
configure: error: Please reinstall the libzip distribution

解决:
这里不能这样子安装yum install -y libzip libzip-devel yum安装的版本低,不能用yum安装
下载 libzip-1.4.0.tar.gz (需要cmake 3.0以上) yum install cmake yum安装的版本低,不能用yum安装
先安装cmake高版本:卸载原有的yum -y remove cmake

下载包:
[root@webone.quan.bbs packages]$ curl -O https://cmake.org/files/v3.6/cmake-3.6.0-Linux-x86_64.tar.gz
[root@webone.quan.bbs packages]$tar -zxvf cmake-3.6.0-Linux-x86_64.tar.gz -C /usr/local/software/cmake
[root@webone.quan.bbs packages]$ln -s /usr/local/software/cmake/cmake-3.6.0-Linux-x86_64/bin/cmake /usr/bin/
注意:这个压缩包不是源码包,解压后直接用。

  2222的第二步:正式安装libzip

[root@webtwo.quan.bbs packages]$wget https://libzip.org/download/libzip-1.4.0.tar.gz
[root@webtwo.quan.bbs packages]$tar -zxvf libzip-1.4.0.tar.gz
[root@webtwo.quan.bbs packages]$cd libzip-1.4.0
[root@webtwo.quan.bbs packages]$mkdir build
[root@webtwo.quan.bbs packages]$cd build
[root@webtwo.quan.bbs packages]$cmake ..
[root@webtwo.quan.bbs packages]$make && make install

33333

错误:
error: off_t undefined; check your library configuration

解决:
[root@webtwo.quan.bbs packages]$ vim /etc/ld.so.conf
添加以下内容:
/usr/local/lib64
/usr/local/lib
/usr/lib
/usr/lib64
[root@webtwo.quan.bbs packages]$ldconfig -v 立即生效

4444

错误:
file included from /root/download/php-7.3.0/ext/zip/php_zip.h:31:0,
from /root/download/php-7.3.0/ext/zip/php_zip.c:36:
/usr/local/include/zip.h:59:21: fatal error: zipconf.h: No such file or directory
#include
^
compilation terminated.
make: *** [ext/zip/php_zip.lo] Error 1

解决:
cp /usr/local/lib/libzip/include/zipconf.h /usr/local/include/zipconf.h

编译成功后

[root@webtwo.quan.bbs packages]$make && make install

建立软连接+复制配置文件:

[root@webtwo.quan.bbs packages]$ ln -s /usr/local/software/php7.3.14 /usr/local/php
[root@webtwo.quan.bbs packages]$cp /usr/local/php/etc/php-fpm.conf.default /usr/local/php/etc/php-fpm.conf
[root@webtwo.quan.bbs packages]$cp /usr/local/php/etc/php-fpm.d/www.conf.default /usr/local/php/etc/php-fpm.d/www.conf

[root@webtwo.quan.bbs packages]$cd php-7.3.14
[root@webtwo.quan.bbs php-7.3.14]$cp php.ini-production /usr/local/php/lib/php.ini

由于编译的时候没有设置默认配置文件路径
/usr/local/php/lib 默认配置文件路径
cp php.ini-production /usr/local/php/lib/php.ini

拷贝php-fpm进程服务的配置文件和扩展配置文件

cp /usr/local/php/etc/php-fpm.conf.default /usr/local/php/etc/php-fpm.conf
cp /usr/local/php/etc/php-fpm.d/www.conf.default /usr/local/php/etc/php-fpm.d/www.conf

建立软连接 使命令支持

[root@webone.quan.bbs packages]$ ln -s /usr/local/php/bin/php /usr/bin/

加入服务,开机自启动:

[root@webone.quan.bbs packages]$cp /data/packages/php-7.3.14/sapi/fpm/init.d.php-fpm /etc/init.d/php-fpm
[root@webone.quan.bbs packages]$chmod +x /etc/init.d/php-fpm
[root@webone.quan.bbs packages]$service php-fpm start
[root@webone.quan.bbs packages]$chkconfig php-fpm on

检测:

[root@webone.quan.bbs tmp]$ps aux |grep nginx
nginx 96581 0.0 1.2 123832 12360 ? S 00:00 0:03 php-fpm: pool www
nginx 96582 0.0 0.9 121444 9624 ? S 00:00 0:03 php-fpm: pool www
root 98610 0.0 0.1 46972 1228 ? Ss 20:37 0:00 nginx: master process /usr/local/nginx/sbin/nginx -c /usr/local/nginx/conf/nginx.conf
nginx 98612 0.0 0.2 47436 2288 ? S 20:37 0:00 nginx: worker process

nginx 和php 结合:

phpinfo()出现的问题:

1111

发现Loaded Configuration File => (none) ,表明没有载入php.ini文件

使用strace 追踪:

strace /usr/local/php7/sbin/php-fpm -i 2>1.log

vim 1.log 查看php.ini

发现

[root@webone.quan.bbs tmp]$php -i |grep php.ini
Configuration File (php.ini) Path => /usr/local/software/php7.3.14/lib
Loaded Configuration File => /usr/local/software/php7.3.14/lib/php.ini

将php.ini拷贝过去就行了

Mysql install 在主机192.168.111.151上操作

yum install openssl-devel -y
yum install -y ncurses-devel
先建立文件目录
mkdir -p /usr/local/software/mysql-5.7.29
mkdir -p /data/mysql/data
mkdir -p /data/mysql/logs
mkdir -p /data/mysql/pids

[root@mysql.quan.bbs packages]$tar -zxvf mysql-boost-5.7.29.tar.gz
[root@mysql.quan.bbs packages]$cd mysql-5.7.29
[root@mysql.quan.bbs mysql-5.7.29]$cmake \

-DCMAKE_INSTALL_PREFIX=/usr/local/software/mysql-5.7.29 \
-DMYSQL_DATADIR=/data/mysql/data \
-DMYSQL_UNIX_ADDR=/data/mysql/mysql.sock \
-DMYSQL_TCP_PORT=3306 \
-DSYSCONFDIR=/usr/local/software/mysql-5.7.29/etc \
-DMYSQL_USER=mysql \
-DWITH_MYISAM_STORAGE_ENGINE=1 \
-DWITH_INNOBASE_STORAGE_ENGINE=1 \
-DWITH_ARCHIVE_STORAGE_ENGINE=1 \
-DWITH_BLACKHOLE_STORAGE_ENGINE=1 \
-DWITH_FEDERATED_STORAGE_ENGINE=1 \
-DWITH_MEMORY_STORAGE_ENGINE=1 \
-DENABLED_LOCAL_INFILE=1 \
-DWITH_EMBEDDED_SERVER=1 \
-DWITH_EDITLINE=bundled \
-DWITH_READLINE=1 \
-DENABLE_DOWNLOADS=1 \
-DWITH_PARTITION_STORAGE_ENGINE=1 \
-DEXTRA_CHARSETS=all \
-DDEFAULT_CHARSET=utf8 \
-DDEFAULT_COLLATION=utf8_general_ci \
-DWITH_DEBUG=0 \
-DENABLE_DTRACE=0 \
-DMYSQL_MAINTAINER_MODE=0 \
-DWITH_ZLIB:STRING=bundled \
-DDOWNLOAD_BOOST=1 \
-DWITH_BOOST=./boost\
-DWITH_SSL=system

编译成功后:

[root@mysql.quan.bbs mysql-5.7.29]$ make &&make install

安装成功后,一如既往的建立软连接:

ln -s /usr/local/software/mysql-5.7.29 /usr/local/mysql

编写配置文件my,cnf

注意:再mysql5.7.18之后就源码包里面就没有mysql 配置文件的模板了

官网:https://dev.mysql.com/doc/refman/5.7/en/server-configuration-defaults.html

可以yum 安装一个mysql ,将/etc/my.cnf复制来修改即可(记得卸载mysql)

vim  /usr/local/software/mysql-5.7.29/etc/my.cnf(因为编译安装的时候指定配置文件目录)

[client]
port = 3306
socket = /data/mysql/data/mysql.sock
default-character-set = utf8
[mysqld]
port = 3306
socket = /data/mysql/data/mysql.sock
basedir = /usr/local/mysql
datadir = /data/mysql/data
pid-file = /data/mysql/pids/mysql.pid
user = mysql
bind-address = 0.0.0.0
server-id = 1
init-connect = 'SET NAMES utf8'
character-set-server = utf8
#skip-name-resolve
#skip-networking
back_log = 300
max_connections = 1000
max_connect_errors = 6000
open_files_limit = 65535
table_open_cache = 128
max_allowed_packet = 4M
binlog_cache_size = 1M
max_heap_table_size = 8M
tmp_table_size = 16M
read_buffer_size = 2M
read_rnd_buffer_size = 8M
sort_buffer_size = 8M
join_buffer_size = 8M
key_buffer_size = 4M
thread_cache_size = 8
query_cache_type = 1
query_cache_size = 8M
query_cache_limit = 2M
ft_min_word_len = 4
ft_min_word_len = 4
log_bin = mysql-bin
binlog_format = mixed
expire_logs_days = 30
log_error = /data/mysql/logs/mysql-error.log
slow_query_log = 1
long_query_time = 1
slow_query_log_file = /data/mysql/logs/mysql-slow.log
performance_schema = 0
explicit_defaults_for_timestamp
#lower_case_table_names = 1
skip-external-locking
default_storage_engine = InnoDB
#default-storage-engine = MyISAM
innodb_file_per_table = 1
innodb_open_files = 500
innodb_buffer_pool_size = 64M
innodb_write_io_threads = 4
innodb_read_io_threads = 4
innodb_thread_concurrency = 0
innodb_purge_threads = 1
innodb_flush_log_at_trx_commit = 2
innodb_log_buffer_size = 2M
innodb_log_file_size = 32M
innodb_log_files_in_group = 3
innodb_max_dirty_pages_pct = 90
innodb_lock_wait_timeout = 120
bulk_insert_buffer_size = 8M
myisam_sort_buffer_size = 8M
myisam_max_sort_file_size = 10G
myisam_repair_threads = 1
interactive_timeout = 28800
wait_timeout = 28800
[mysqldump]
quick
max_allowed_packet = 16M
[myisamchk]
key_buffer_size = 8M
sort_buffer_size = 8M
read_buffer = 4M
write_buffer = 4M

加入服务,开机自启动:

[root@mysql.quan.bbs mysql-5.7.29]$
cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld
[root@mysql.quan.bbs mysql-5.7.29]$chmod +x /etc/init.d/mysqld
[root@mysql.quan.bbs mysql-5.7.29]$chkconfig --add mysqld
[root@mysql.quan.bbs mysql-5.7.29]$chkconfig mysqld on
[root@mysql.quan.bbs mysql-5.7.29]$chkconfig --list | grep mysqld
mysqld 0:off 1:off 2:on 3:on 4:on 5:on 6:off

修改数据库数据目录权限

[root@mysql.quan.bbs mysql-5.7.29]$chown -R mysql:mysql /data/mysql

数据库初始化:
[root@mysql.quan.bbs mysql-5.7.29]$/usr/local/mysql/bin/mysqld --initialize-insecure --user=mysql --basedir=/usr/local/mysql --datadir=/data/mysql/data
[root@mysql.quan.bbs mysql-5.7.29]$service mysqld start
Starting MySQL. SUCCESS!

测试
[root@mysql.quan.bbs mysql-5.7.29]$netstat -tunlp |grep mysql
tcp 0 0 0.0.0.0:3306 0.0.0.0:* LISTEN 90317/mysqld

第一次登陆,修改root密码并设计论坛所需的数据库和权限

[root@mysql.quan.bbs pids]$/usr/local/mysql/bin/mysql -u root
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.7.29-log Source distribution

Copyright (c) 2000, 2020, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| performance_schema |
| sys |
+--------------------+
4 rows in set (0.00 sec)

mysql> use mysql
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> select host,user,authentication_string from user;
+-----------+---------------+-------------------------------------------+
| host | user | authentication_string |
+-----------+---------------+-------------------------------------------+
| localhost | root | |
| localhost | mysql.session | *THISISNOTAVALIDPASSWORDTHATCANBEUSEDHERE |
| localhost | mysql.sys | *THISISNOTAVALIDPASSWORDTHATCANBEUSEDHERE |
+-----------+---------------+-------------------------------------------+
3 rows in set (0.00 sec)

mysql> UPDATE user SET authentication_string=PASSWORD('2004') WHERE user='root';
Query OK, 1 row affected, 1 warning (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 1

mysql> flush privileges;
Query OK, 0 rows affected (0.01 sec)

mysql> quit

[root@mysql.quan.bbs pids]$/usr/local/mysql/bin/mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 4
Server version: 5.7.29-log Source distribution

Copyright (c) 2000, 2020, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> create databases quanbbs;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'databases quanbbs' at line 1
mysql> create database quanbbs;
Query OK, 1 row affected (0.00 sec)

mysql> grant all on quanbbs.* to bbsquan@'%' identified by '2004quan';
Query OK, 0 rows affected, 1 warning (0.01 sec)

mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)

mysql> exit

数据库为quanbbs

用户为bbsquan

密码为2004quan

安装mysql可能出现的问题:

1111问题:

[root@ansz.quan.bbs etc]$service mysqld start
Starting MySQL… ERROR! The server quit without updating PID file (/data/mysql/pids/mysql.pid).
[root@ansz.quan.bbs etc]$service mysqld status
ERROR! MySQL is not running, but lock file (/var/lock/subsys/mysql) exists
[root@ansz.quan.bbs etc]$service mysqld stop
ERROR! MySQL server PID file could not be found!

解决:

第一步建议查看/etc/my.cnf 因为我的编译的配置文件路径不是默认路径
以防万一,把他删了

第二部:建议查看系统是否自带安装了mysql ,卸载掉即可
第三步:系统可能已经存在正在运行的mysql 相关的程序,将其关掉
[root@ansz.quan.bbs etc]$ps aux |grep mysql
root 1280 0.0 0.1 108320 1660 ? S 21:37 0:00 /bin/sh /usr/local/mysql/bin/mysqld_safe --datadir=/data/mysql/data --pid-file=/data/mysql/pids/mysql.pid
mysql 2197 0.0 4.9 929780 49432 ? Sl 21:37 0:00 /usr/local/mysql/bin/mysqld --basedir=/usr/local/mysql --datadir=/data/mysql/data --plugin-dir=/usr/local/mysql/lib/plugin --user=mysql --log-error=/var/log/mysqld.log --open-files-limit=65535 --pid-file=/data/mysql/pids/mysql.pid --socket=/data/mysql/data/mysql.sock --port=3306
root 5932 0.0 0.0 103328 892 pts/0 S+ 21:46 0:00 grep mysql
[root@ansz.quan.bbs etc]$kill -9 1280
[root@ansz.quan.bbs etc]$ps aux |grep mysql
mysql 2197 0.0 4.9 929780 49432 ? Sl 21:37 0:00 /usr/local/mysql/bin/mysqld --basedir=/usr/local/mysql --datadir=/data/mysql/data --plugin-dir=/usr/local/mysql/lib/plugin --user=mysql --log-error=/var/log/mysqld.log --open-files-limit=65535 --pid-file=/data/mysql/pids/mysql.pid --socket=/data/mysql/data/mysql.sock --port=3306
root 5934 0.0 0.0 103328 892 pts/0 S+ 21:46 0:00 grep mysql
[root@ansz.quan.bbs etc]$kill -9 2197
[root@ansz.quan.bbs etc]$ps aux |grep mysql
root 5936 0.0 0.0 103324 884 pts/0 S+ 21:46 0:00 grep mysql

kill -9表示强制杀死该进程,这个信号不能被捕获也不能被忽略!!!

22222问题:

可能编译的时候,因为有参数:-DDOWNLOAD_BOOST=1 \
所以会在线下载文件boost_1_59_0.tar.gz

而这个文件的源有时载率是很低的,根本下载不了,所以只能大家多试几次了

解决:

其实因为我下载的myql版本是自带的,所以不需要加上面的参数-DDOWNLOAD_BOOST=1
然后直接编译就行了,哈哈哈哈哈哈哈哈哈哈哈

333问题:

[root@ansz.quan.bbs mysql]$/usr/local/mysql/bin/mysqld --initialize-insecure --user=mysql --basedir=/usr/local/mysql --datadir=/data/mysql/data
2020-02-10T13:30:23.930494Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2020-02-10T13:30:24.132226Z 0 [Warning] InnoDB: New log files created, LSN=45790
2020-02-10T13:30:24.163758Z 0 [Warning] InnoDB: Creating foreign key constraint system tables.
2020-02-10T13:30:24.233165Z 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: 7e1aeab8-4c09-11ea-b242-000c2914182e.
2020-02-10T13:30:24.235679Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2020-02-10T13:30:24.577125Z 0 [Warning] CA certificate ca.pem is self signed.
2020-02-10T13:30:24.608491Z 1 [Warning] root@localhost is created with an empty password ! Please consider switching off the --initialize-insecure option.

解决:

此处是因为我的配置文件建立的路径错误,导致初始化出现警告
但是是成功初始化的,因为i我的/etc/my.cnf是存在的,所以只警告

将/etc/my.cnf删除在,建立对的配置文件
注意:将数据库相关目录进行清空在初始化
本案例中包括/data/mysql/data 的文件
/data/mysql/logs的文件
/data/mysql/pids的文件

discuz install 192.168.111.141

wget https://files.gitee.com/group1/M00/0A/98/wKgCNF3jszaAR3zfALQPsgJPd6k089.zip?token=ee59878992389b345910fdafae2c1ad2&ts=1581158202&attname=Discuz_X3.4_SC_UTF8%E3%80%9020191201%E3%80%91.zip&disposition=attachment

建立网址目录
[apps@webone.quan.bbs etc]$cd /usr/local/nginx/html/
[apps@webone.quan.bbs html]$mkdir bbs

解压:
[root@webone.quan.bbs Discuz]$unzip Discuz_X3.4_SC_UTF8【20191201】.zip

将upload目录下的所有文件上传到bbs中

[root@webone.quan.bbs packages]$
cp -r /data/packages/Discuz/upload/* /usr/local/nginx/html/bbs/

修改nginx配置文件:

user nginx nginx;
worker_processes 1;

#error_log logs/error.log;
#error_log logs/error.log notice;
#error_log logs/error.log info;

#pid logs/nginx.pid;

events {
worker_connections 1024;
}

http {
include mime.types;
default_type application/octet-stream;

#log\_format  main  '$remote\_addr - $remote\_user \[$time\_local\] "$request" '  
#                  '$status $body\_bytes\_sent "$http\_referer" '  
#                  '"$http\_user\_agent" "$http\_x\_forwarded\_for"';

#access\_log  logs/access.log  main;

sendfile        on;  
#tcp\_nopush     on;

#keepalive\_timeout  0;  
keepalive\_timeout  65;

#gzip  on;

server {  
    listen       80;  
    server\_name  localhost;

    #charset koi8-r;

    #access\_log  logs/host.access.log  main;  
    ####修改这里,原来的location 可以不要了  
    index  index.html index.htm index.php;  
root        /usr/local/nginx/html/bbs;  
    #error\_page  404              /404.html;

    # redirect server error pages to the static page /50x.html  
    #  
    error\_page   500 502 503 504  /50x.html;  
    location = /50x.html {  
        root   html;  
    }

    # proxy the PHP scripts to Apache listening on 127.0.0.1:80  
    #  
    #location ~ \\.php$ {  
    #    proxy\_pass   http://127.0.0.1;  
    #}

    # pass the PHP scripts to FastCGI server listening on 127.0.0.1:9000  
    #  
    location ~ \\.php$ {  
        fastcgi\_pass   127.0.0.1:9000;  
        fastcgi\_index  index.php;  
        ####修改这里  
        fastcgi\_param  SCRIPT\_FILENAME   /usr/local/nginx/html/bbs/$fastcgi\_script\_name;  
        include        fastcgi\_params;  
    }

    # deny access to .htaccess files, if Apache's document root  
    # concurs with nginx's one  
    #  
    #location ~ /\\.ht {  
    #    deny  all;  
    #}  
}

# another virtual host using mix of IP-, name-, and port-based configuration  
#  
#server {  
#    listen       8000;  
#    listen       somename:8080;  
#    server\_name  somename  alias  another.alias;

#    location / {  
#        root   html;  
#        index  index.html index.htm;  
#    }  
#}

# HTTPS server  
#  
#server {  
#    listen       443 ssl;  
#    server\_name  localhost;

#    ssl\_certificate      cert.pem;  
#    ssl\_certificate\_key  cert.key;

#    ssl\_session\_cache    shared:SSL:1m;  
#    ssl\_session\_timeout  5m;

#    ssl\_ciphers  HIGH:!aNULL:!MD5;  
#    ssl\_prefer\_server\_ciphers  on;

#    location / {  
#        root   html;  
#        index  index.html index.htm;  
#    }  
#}

}

重启生效:

service nginx restart

总体测试

访问http://192.168.111.141/进行可视化安装即可

数据库配置阶段(需结合刚才数据库设置填写)

如下:

管理密码QQQQ2004

最后成功啦: