# php -v
PHP Warning: PHP Startup: Unable to load dynamic library 'zlib.so' (tried: /usr/lib64/php/modules/zlib.so (/usr/lib64/php/modules/zlib.so: cannot open shared object file: No such file or directory), /usr/lib64/php/modules/zlib.so.so (/usr/lib64/php/modules/zlib.so.so: cannot open shared object file: No such file or directory)) in Unknown on line 0
PHP Warning: PHP Startup: Unable to load dynamic library 'php_zlib.dll' (tried: /usr/lib64/php/modules/php_zlib.dll (/usr/lib64/php/modules/php_zlib.dll: cannot open shared object file: No such file or directory), /usr/lib64/php/modules/php_zlib.dll.so (/usr/lib64/php/modules/php_zlib.dll.so: cannot open shared object file: No such file or directory)) in Unknown on line 0
PHP Warning: Module 'mcrypt' already loaded in Unknown on line 0
PHP 7.2.4 (cli) (built: Mar 27 2018 17:23:35) ( NTS )
Copyright (c) 1997-2018 The PHP Group
Zend Engine v3.2.0, Copyright (c) 1998-2018 Zend Technologies
with Zend OPcache v7.2.4, Copyright (c) 1999-2018, by Zend Technologies

@msg7086

@http://104.131.43.152/info.php

麻烦您看下我服务器的 php 安装信息，里面没有 mcrypt 和 zlib

yum install zlib

yum install zlib-devel
2 个命令输入后，
Package zlib-1.2.7-17.el7.x86_64 already installed and latest version
Nothing to do
Package zlib-devel-1.2.7-17.el7.x86_64 already installed and latest version
Nothing to do

@msg7086

PHP 的 zlib 扩展？没理解这句话，

@msg7086 请问能否直接告诉我如何正确配置？

# whereis zlib
zlib: /usr/include/zlib.h /usr/share/man/man3/zlib.3.gz

@zhazi thanks

输入 sudo journalctl -xe -u mariadb.service
查看信息
然后输入：
/usr/bin/mysql_secure_installation
按照提示 输入 enter
然后输入 4 个 y
然后 sudo systemctl status mysqld
active 的状态
sudo systemctl start mysqld
成功

谢谢各位

/usr/local/openresty/nginx/logs/error.log

https://i.imgur.com/undefined.png

@LGB

https://i.imgur.com/e4TYUED.png

/etc/my.cnf 的配置截图如上



https://i.imgur.com/AjMPULz.png
/var/log/mysqld.log 的配置截图如上

@wwqgtxx @neighbads @defunct9

https://i.imgur.com/bR8SH2X.png
截图在这里，麻烦看下，谢谢 @wwqgtxx @neighbads @defunct9

sudo journalctl -u mysqld
-- Logs begin at Wed 2018-04-11 00:59:13 UTC, end at Sun 2018-04-15 10:56:42 UTC. --
Apr 15 09:58:20 newoneacreland systemd[1]: Starting MySQL Community Server...
Apr 15 09:58:21 newoneacreland mysqld_safe[31839]: 180415 09:58:21 mysqld_safe Logging to '/var/log/mysqld.log'.
Apr 15 09:58:22 newoneacreland mysqld_safe[31839]: 180415 09:58:22 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
Apr 15 10:08:21 newoneacreland systemd[1]: mysqld.service start-post operation timed out. Stopping.
Apr 15 10:08:21 newoneacreland systemd[1]: Failed to start MySQL Community Server.
Apr 15 10:08:21 newoneacreland systemd[1]: Unit mysqld.service entered failed state.
Apr 15 10:08:21 newoneacreland systemd[1]: mysqld.service failed.
Apr 15 10:08:22 newoneacreland systemd[1]: mysqld.service holdoff time over, scheduling restart.
Apr 15 10:08:22 newoneacreland systemd[1]: Starting MySQL Community Server...
Apr 15 10:08:22 newoneacreland mysqld_safe[2173]: 180415 10:08:22 mysqld_safe Logging to '/var/log/mysqld.log'.
Apr 15 10:08:23 newoneacreland mysqld_safe[2173]: 180415 10:08:23 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
Apr 15 10:18:22 newoneacreland systemd[1]: mysqld.service start-post operation timed out. Stopping.
Apr 15 10:18:22 newoneacreland systemd[1]: Failed to start MySQL Community Server.
Apr 15 10:18:22 newoneacreland systemd[1]: Unit mysqld.service entered failed state.
Apr 15 10:18:22 newoneacreland systemd[1]: mysqld.service failed.
Apr 15 10:18:23 newoneacreland systemd[1]: mysqld.service holdoff time over, scheduling restart.
Apr 15 10:18:23 newoneacreland systemd[1]: Starting MySQL Community Server...
Apr 15 10:18:24 newoneacreland mysqld_safe[4906]: 180415 10:18:24 mysqld_safe Logging to '/var/log/mysqld.log'.
Apr 15 10:18:24 newoneacreland mysqld_safe[4906]: 180415 10:18:24 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
Apr 15 10:28:23 newoneacreland systemd[1]: mysqld.service start-post operation timed out. Stopping.
Apr 15 10:28:23 newoneacreland systemd[1]: Failed to start MySQL Community Server.
Apr 15 10:28:23 newoneacreland systemd[1]: Unit mysqld.service entered failed state.
Apr 15 10:28:23 newoneacreland systemd[1]: mysqld.service failed.
Apr 15 10:28:24 newoneacreland systemd[1]: mysqld.service holdoff time over, scheduling restart.
Apr 15 10:28:24 newoneacreland systemd[1]: Starting MySQL Community Server...
Apr 15 10:28:24 newoneacreland mysqld_safe[7562]: 180415 10:28:24 mysqld_safe Logging to '/var/log/mysqld.log'.
Apr 15 10:28:25 newoneacreland mysqld_safe[7562]: 180415 10:28:25 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
lines 1-28...skipping...
-- Logs begin at Wed 2018-04-11 00:59:13 UTC, end at Sun 2018-04-15 10:56:42 UTC. --
Apr 15 09:58:20 newoneacreland systemd[1]: Starting MySQL Community Server...
Apr 15 09:58:21 newoneacreland mysqld_safe[31839]: 180415 09:58:21 mysqld_safe Logging to '/var/log/mysqld.log'.
Apr 15 09:58:22 newoneacreland mysqld_safe[31839]: 180415 09:58:22 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
Apr 15 10:08:21 newoneacreland systemd[1]: mysqld.service start-post operation timed out. Stopping

@wwqgtxx

／ var/log/mysqld.log 的日志
@neighbads 不知道你指的是不是这个？



180415 10:39:22 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
180415 10:49:22 mysqld_safe Logging to '/var/log/mysqld.log'.
180415 10:49:22 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
180415 10:49:22 [Note] /usr/sbin/mysqld (mysqld 5.5.59) starting as process 13415 ...
180415 10:49:22 [Note] Plugin 'FEDERATED' is disabled.
180415 10:49:22 InnoDB: The InnoDB memory heap is disabled
180415 10:49:22 InnoDB: Mutexes and rw_locks use GCC atomic builtins
180415 10:49:22 InnoDB: Compressed tables use zlib 1.2.3
180415 10:49:22 InnoDB: Using Linux native AIO
180415 10:49:22 InnoDB: Initializing buffer pool, size = 128.0M
180415 10:49:22 InnoDB: Completed initialization of buffer pool
180415 10:49:22 InnoDB: highest supported file format is Barracuda.
180415 10:49:22 InnoDB: Waiting for the background threads to start
180415 10:49:23 InnoDB: 5.5.59 started; log sequence number 1597945
180415 10:49:23 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
180415 10:49:23 [Note] - '0.0.0.0' resolves to '0.0.0.0';
180415 10:49:23 [Note] Server socket created on IP: '0.0.0.0'.
180415 10:49:23 [ERROR] Incorrect definition of table mysql.event: expected column 'sql_mode' at position 14 to have type set('REAL_AS_FLOAT','PIPES_AS_CONCAT','ANSI_QUOTES','IGNORE_SPACE','NOT_USED','ONLY_FULL_GROUP_BY','NO_UNSIGNED_SUBTRACTION','NO_DIR_IN_CREATE','POSTGRESQL','ORACLE','MSSQL','DB2','MAXDB','NO_KEY_OPTIONS','NO_TABLE_OPTIONS','NO_FIELD_OPTIONS','MYSQL323','MYSQL40','ANSI','NO_AUTO_VALUE_ON_ZERO','NO_BACKSLASH_ESCAPES','STRICT_TRANS_TABLES','STRICT_ALL_TABLES','NO_ZERO_IN_DATE','NO_ZERO_DATE','INVALID_DATES','ERROR_FOR_DIVISION_BY_ZERO','TRADITIONAL','NO_AUTO_CREATE_USER','HIGH_NOT_PRECEDENCE','NO_ENGINE_SUBSTITUTION','PAD_CHAR_TO_FULL_LENGTH'), found type set('REAL_AS_FLOAT','PIPES_AS_CONCAT','ANSI_QUOTES','IGNORE_SPACE','IGNORE_BAD_TABLE_OPTIONS','ONLY_FULL_GROUP_BY','NO_UNSIGNED_SUBTRACTION','NO_DIR_IN_CREATE','POSTGRESQL','ORACLE','MSSQL','DB2','MAXDB','NO_KEY_OPTIONS','NO_TABLE_OPTIONS','NO_FIELD_OPTIONS','MYSQL323','MYSQL40','ANSI','NO_AUTO_VALUE_ON_ZERO','NO_BACKSLASH_ESCAPES','STRICT_TRANS_TABLES','STRICT_A
180415 10:49:23 [ERROR] Event Scheduler: An error occurred when initializing system tables. Disabling the Event Scheduler.
180415 10:49:23 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.5.59' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server (GPL)

@neighbads 请问日志目录？

http://104.131.43.152/info.php 目前这个显示正常了，http://104.131.43.152/phpmyadmin 还是无法显示入口

@explore365 2 位能否看下我在 sf 里面发的截图配置？谢谢。https://segmentfault.com/q/1010000014312298

@julyclyde 请问如何配置 www 服务器？
@explore365 nginx 里面如何添加 php 的配置？在 nginx.conf 里面添加吗？