NGINX + PHP + MYSQL + REDIS

docker run \
 -v /appserver/nginx/vhosts_dir:/usr/local/nginx/vhosts_dir:rw \
 -v /appserver/mysql/datadir:/usr/local/mysql/datadir:rw \
 -p 80:80 \
 -p 443:443 \
 -d qwerty199369/nginx-php-mysql-redis:1.1.3

RELOAD NGINX

docker exec -d CONTAINER /usr/local/nginx/sbin/nginx -s reload

CERTBOT

./certbot-auto -n --config /usr/local/nginx/vhosts_dir/certbot/xxx.conf certonly

ENABLE PUBLIC ACCESS OF MYSQL

sed -r -i -e "s/127.0.0.1/0.0.0.0/g" /etc/my.cnf
/usr/local/mysql/support-files/mysql.server restart

/usr/local/mysql/bin/mysql -uroot -p
use mysql;
update `user` set `Host` = '%' where `User` = 'root' and `Host` = 'localhost';
flush privileges;

UPGRADE MYSQL

touch /usr/local/mysql/log_error_file.log
chown -R mysql:appserver /usr/local/mysql
/usr/local/mysql/support-files/mysql.server start

# or you can do it via `docker_run.sh`

ENABLE PUBLIC ACCESS OF REDIS

sed -r -i -e "s/127.0.0.1/0.0.0.0/g" /usr/local/redis/conf_file.conf
/usr/local/redis/bin/redis-cli shutdown
/usr/local/redis/bin/redis-server /usr/local/redis/conf_file.conf

COMPOSER

/usr/local/php/bin/php composer.phar update --prefer-dist --no-dev --optimize-autoloader -vvv

INIT MYSQL SERVER

chown -R mysql:appserver     /usr/local/mysql

# only for initializing data directory
/usr/local/mysql/bin/mysqld --defaults-file=/etc/my.cnf             \
--initialize-insecure                                               \
--user=mysql                                                        \
--basedir=/usr/local/mysql                                          \
--datadir=/usr/local/mysql/datadir

/usr/local/mysql/support-files/mysql.server start

chmod 777 /tmp/mysql.sock

# only for set new password of mysql
/usr/local/mysql/bin/mysqladmin -uroot password

ENABLE MYSQL QUERY LOG

SET global log_output = 'file';
SET global general_log = 1;
SET global general_log_file = '/usr/local/nginx/vhosts_dir/PATH/query.log';

REFERENCE

• Initializing the Data Directory Manually Using mysqld