mysql

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
#安装docker
docker pull mysql

#先启动
docker run --name mysql -p 4148:3306 -e MYSQL_ROOT_PASSWORD=root -d mysql

#注意:my.cnf得从docker mysql容器中复制一份到/texin/volume/mysql/conf中
docker cp mysql:/etc/mysql/my.cnf /texin/volume/mysql/conf

#成功后关闭mysql
#重新启动
#启动并挂载配置到宿主机
docker run -p 4148:3306 --name mysql \
-v /texin/volume/mysql/log:/var/log/mysql \
-v /texin/volume/mysql/data:/var/lib/mysql \
-v /texin/volume/mysql/conf/my.cnf:/etc/mysql/my.cnf \
-e MYSQL_ROOT_PASSWORD=root \
-d mysql
#进入mysql容器
docker exec -it mysql /bin/bash

#本地登录mysql
mysql -uroot -proot
#查询mysql用户
select user,host from mysql.user;
#新建用户@'%' 不限ip连接,只要本地则@'localhost'即可
create user 'weilian'@'%' identified by 'weilian2020';
#查看用户密码方式注意远程连接不支持:caching_sha2_password验证方式
#我们将他改成msyql_native_password
alter user 'weilian'@'%' identified with mysql_native_password BY 'weilian2020';
#刷新
flush privileges;
#查看用户密码方式,检查是否修改成功
select host,user,plugin,authentication_string from mysql.user;
#指定数据库texin授权用户
grant all privileges on texin.* to 'weilian'@'%';
#授予用户所有权限
grant all privileges on *.* to 'weilian'@'%';
#如果navicat还是连接失败请在挂载主机目录的my.cnf文件中加一句
default_authentication_plugin=mysql_native_password
#即可实现远程

redis

1
2
3
4
5
6
7
#安装redis默认lasted版本
docker pull redis
#启动并挂载
docker run -p 4149:6379 --name redis \
-v /texin/volume/redis/conf/redis.conf:/etc/redis/redis.conf \
-v /texin/volume/redis/data:/data \
-d redis redis-server --appendonly yes --requirepass 'weilian2020'

mongo

1
2
3
4
5
6
7
8
9
10
#安装mongo默认lasted版本
docker pull mongo
#启动并挂载
docker run \
--name mongo \
-p 4147:27017 \
-e MONGO_INITDB_ROOT_USERNAME='weilian' -e MONGO_INITDB_ROOT_PASSWORD='weilian2020' \
-v /texin/volume/mongo/data:/data/db \
-v /texin/volume/mongo/configdb:/data/configdb/ \
-d mongo

activemq

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
#搜索activemq版本列表
docker search activemq
#安装activemq
docker pull webcenter/activemq
#启动指定对外端口61617和8167
docker run -d --name activemq -p 61617:61616 -p 8162:8161 webcenter/activemq

#挂载宿主机
#第一步:用临时方式启动一个activemq 容器
docker run --user root --privileged=true --rm -ti \
-v /texin/volume/activemq/conf:/mnt/conf \
-v /texin/volume/activemq/data:/mnt/data \
webcenter/activemq /bin/sh
#第二步:将容器中的配置目录和数据目录拷贝出去并退出
chown activemq:activemq /mnt/conf
chown activemq:activemq /mnt/data
cp -a /opt/activemq/conf/* /mnt/conf/
cp -a /opt/activemq/data/* /mnt/data/
#第三步:运行activemq
docker run -d --name activemq -p 61617:61616 -p 8162:8161 \
-v /texin/volume/activemq/conf:/opt/activemq/conf \
-v /texin/volume/activemq/data:/opt/activemq/data \
-v /texin/volume/activemq/log:/var/log/activemq \
webcenter/activemq

nginx

1
2
3
4
5
6
7
8
9
10
11
12
13
#安装nginx 并配置https
docker pull nginx
#启动

docker run -p 80:80 -p 443:443 --name nginx \
-v /texin/volume/nginx/conf/nginx.conf:/etc/nginx/nginx.conf \
-v /texin/volume/front:/etc/nginx/html \
-v /texin/volume/nginx/logs:/var/log/nginx \
-v /texin/volume/nginx/conf/cert:/etc/nginx/cert \
-d nginx

#在宿主机texin/volume/nginx/conf目录下新建nginx.conf
#内容(这是最终配置) 前后端分离资源访问

nginx.conf

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
#user  nobody;
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;
charset utf-8,gbk;
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 /var/log/nginx/access.log main;

sendfile on;
#tcp_nopush on;

#keepalive_timeout 0;
keepalive_timeout 65;

#gzip on;

server {
listen 80;
listen 443 ssl;
server_name dev.ruixuelong.com;

ssl_certificate /etc/nginx/cert/4670445_dev.ruixuelong.com.pem;
ssl_certificate_key /etc/nginx/cert/4670445_dev.ruixuelong.com.key;

ssl_session_cache shared:SSL:1m;
ssl_session_timeout 5m;

ssl_ciphers ECDHE-RSA-AES128-GCM-SHA256:ECDHE:ECDH:AES:HIGH:!NULL:!aNULL:!MD5:!ADH:!RC4;
ssl_protocols TLSv1 TLSv1.1 TLSv1.2;
ssl_prefer_server_ciphers on;

charset koi8-r;

#access_log logs/host.access.log main;

location / {
root html;
try_files $uri $uri/ @router;

}

location /payment/ {
root html;
try_files $uri $uri/ /payment/@router;
#index index.html index.htm;
}

location /manage/ {
root html;
try_files $uri $uri/ /manage/@router;
#index index.html index.htm;
}


location @router {
rewrite ^.*$ /index.html last;
}

location /admin/ {
set $cors '';
if ($http_origin ~* 'https?://(localhost(:8090)?|dev\.ruixuelong\.com|ruixuelong\.com)') {
set $cors 'true';
}

if ($cors = 'true') {
add_header 'Access-Control-Allow-Origin' "$http_origin" always;
add_header 'Access-Control-Allow-Credentials' 'true' always;
add_header 'Access-Control-Allow-Methods' 'GET, POST, PUT, DELETE, OPTIONS' always;
add_header 'Access-Control-Allow-Headers' 'Accept,Authorization,Cache-Control,Content-Type,DNT,If-Modified-Since,Keep-Alive,Origin,User-Agent,X-Mx-ReqToken,X-Requested-With' always;
}

if ($request_method = 'OPTIONS') {
return 204;
}

proxy_set_header X-Forwarded-Host $host;
proxy_set_header X-Forwarded-Server $host;
proxy_set_header X-Forwarded-For $proxy_add_x_forwarded_for;
proxy_pass http://39.99.150.17:8080/admin/;
}

location /taxi/ {
set $cors '';
if ($http_origin ~* 'https?://(localhost(:8090)?|dev\.ruixuelong\.com|ruixuelong\.com)') {
set $cors 'true';
}

if ($cors = 'true') {
add_header 'Access-Control-Allow-Origin' "$http_origin" always;
add_header 'Access-Control-Allow-Credentials' 'true' always;
add_header 'Access-Control-Allow-Methods' 'GET, POST, PUT, DELETE, OPTIONS' always;
add_header 'Access-Control-Allow-Headers' 'Accept,Authorization,Cache-Control,Content-Type,DNT,If-Modified-Since,Keep-Alive,Origin,User-Agent,X-Mx-ReqToken,X-Requested-With' always;
}

if ($request_method = 'OPTIONS') {
return 204;
}

proxy_set_header X-Forwarded-Host $host;
proxy_set_header X-Forwarded-Server $host;
proxy_set_header X-Forwarded-For $proxy_add_x_forwarded_for;
proxy_pass http://39.99.150.17:8081/taxi/;
}

location /texin/ {
set $cors '';
if ($http_origin ~* 'https?://(localhost(:8090)?|dev\.ruixuelong\.com|ruixuelong\.com)') {
set $cors 'true';
}

if ($cors = 'true') {
add_header 'Access-Control-Allow-Origin' "$http_origin" always;
add_header 'Access-Control-Allow-Credentials' 'true' always;
add_header 'Access-Control-Allow-Methods' 'GET, POST, PUT, DELETE, OPTIONS' always;
add_header 'Access-Control-Allow-Headers' 'Accept,Authorization,Cache-Control,Content-Type,DNT,If-Modified-Since,Keep-Alive,Origin,User-Agent,X-Mx-ReqToken,X-Requested-With' always;
}

if ($request_method = 'OPTIONS') {
return 204;
}

proxy_set_header X-Forwarded-Host $host;
proxy_set_header X-Forwarded-Server $host;
proxy_set_header X-Forwarded-For $proxy_add_x_forwarded_for;
proxy_pass http://39.99.150.17:8082/texin/;
}

#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$ {
# root html;
# fastcgi_pass 127.0.0.1:9000;
# fastcgi_index index.php;
# fastcgi_param SCRIPT_FILENAME /scripts$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;
# }
#}

}

###注:所有端口记得要在aliyun安全规则添加规则并开放防火墙端口