docker 搭建 lnmp 实践
centos7 下 docker 的安装
sudo yum install -y yum-utils device-mapper-persistent-data lvm2
sudo yum-config-manager --add-repo https://download.docker.com/linux/centos/docker-ce.repo
sudo yum install docker-ce -y
项目介绍
docker 环境搭建相关代码
git clone https://gitee.com/lvye1221/docker-deploy
【参考资料】docker compose php+mysql+nginx 连载，包含3篇
https://blog.csdn.net/tang05709/article/details/77996246
操作命令：
// 安装库依赖
docker-compose build
// 将会在后台启动并运行所有的容器
docker-compose up -d
// 启动服务器
docker-compose upmysql
让装好的 mysql 支持远程连接
host为 % 表示不限制ip localhost表示本机使用 plugin非mysql_native_password 则需要修改密码
// 进入 mysql 容器 的命令行
docker exec -it docker_mysql_1 bash
mysql -uroot -p123456
mysql> ALTER user 'root'@'%' IDENTIFIED WITH mysql_native_password BY '123456';
Query OK, 0 rows affected (0.03 sec)
mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.00 sec)
参考网址： docker安装mysql遇到的问题
https://blog.csdn.net/zhaokejin521/article/details/80468908
docker 2.0 内存配置
docker_mysql_1 exited with code 137
问题
https://www.petefreitag.com/item/848.cfm
【解决办法】 设置 Linux 交换分区
详细参照此文档：
https://blog.csdn.net/zstack_org/article/details/53258588
fallocate -l 2G /swapfile
ls -lh /swapfile
chmod 600 /swapfile
mkswap /swapfile
swapon /swapfile
vi /etc/fstab
/swapfile swap swap sw 0 0
ERROR 1045 (28000): Access denied for user ‘root’@’localhost’ (using password: YES)
单独测试 mysql
docker search mysql
docker pull mysql:5.6
docker images |grep mysql
docker run -p 3306:3306 --name mymysql -v $PWD/conf:/etc/mysql/conf.d -v $PWD/logs:/logs -v $PWD/data:/var/lib/mysql -e MYSQL_ROOT_PASSWORD=123456 -d mysql:5.6
docker exec -it mymysql bash
安装vi
apt-get update
apt-get install -y vi
apt-get install -y vim
No input file specified.
<?php
echo phpinfo();
docker pull mysql
docker run -d -p 127.0.0.1:3306:3306 –name mysql -v ./testdb:/var/lib/mysql -e MYSQL_ROOT_PASSWORD=”111111” mysql:latest
docker run –name docker_mysql -p 3306:3306 -e MYSQL_ROOT_PASSWORD=123456 -d docker.io/mysql restart=always
1 FastCGI sent in stderr: “Unable to open primary script: /code/t.php (Operation not permitted)”
1 FastCGI sent in stderr: “Unable to open primary script: (Operation not permitted)”
web_1 | 2018/08/13 08:28:36 [error] 6#6: *2 FastCGI sent in stderr: “Unable to open primary script: /code/t.php (Operation not permitted)” while reading response header from upstream, client: 183.214.113.54, server: localhost, request: “GET /t.php HTTP/1.1”, upstream: “fastcgi://172.19.0.2:9000”, host: “hope1995.me:8080”
[error] 6#6: *2 FastCGI sent in stderr: Unable to open primary script: (Operation not permitted)
【解决办法】删除 htdocs 目录下的 .user.ini 文件
连接 mysql 数据库
主机名，是写 docker-compse 中定义的镜像名字 mysql
用户名的权限要给够
docker-compose 密码加密16位改为41位
mysql
select host,user,password from mysql.user;
SET PASSWORD FOR 'root'@'%' = PASSWORD('123456');
---------
set @@session.old_passwords=0;
FLUSH PRIVILEGES;
mysql> select password(“123456”);
+——————————————-+
| password(“123456”) |
+——————————————-+
| *6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9 |
+——————————————-+
1 row in set (0.00 sec)
