-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy path20171026005253_all_v1.sql
556 lines (511 loc) · 255 KB
/
20171026005253_all_v1.sql
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
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
--
-- MySQL database dump
-- Created by DbManage class, Power By yanue.
-- http://yanue.net
--
-- 主机: localhost
-- 生成日期: 2017 年 10 月 26 日 00:52
-- MySQL版本: 5.6.35
-- PHP 版本: 5.6.30
--
-- 数据库: `blog`
--
-- -------------------------------------------------------
--
-- 表的结构blog_about
--
DROP TABLE IF EXISTS `blog_about`;
CREATE TABLE `blog_about` (
`ab_id` int(11) NOT NULL AUTO_INCREMENT,
`ab_title` varchar(50) NOT NULL DEFAULT '',
`ab_image` varchar(255) NOT NULL DEFAULT '',
`ab_content` text,
PRIMARY KEY (`ab_id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
--
-- 转存表中的数据 blog_about
--
INSERT INTO `blog_about` VALUES('1','冒蓝光的哒哒哒。。。。','/uploads/about/t4.jpg','<p>Vivamus interdum diam diam, non faucibus tortor consequat vitae. Proin sit amet augue sed massa pellentesque viverra. Suspendisse iaculis purus eget est pretium aliquam ut sed diam. Nullam non magna lobortis, faucibus erat eu, consequat justo. Suspendisse commodo nibh odio, vel elementum nulla luctus sit amet.\r\n\r\nNulla in tempor lectus. Etiam ac mauris lacinia nulla ultricies porta sit amet eleifend ligula. Quisque tincidunt vitae turpis at efficitur. Pellentesque habitant morbi tristique senectus et netus et malesuada fames ac turpis egestas. Donec sagittis, magna a sagittis dapibus, ipsum metus interdum lectus, quis feugiat leo ipsum nec diam.sdfad dasf asdaf sdf </p>');
--
-- 表的结构blog_admin
--
DROP TABLE IF EXISTS `blog_admin`;
CREATE TABLE `blog_admin` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user_name` varchar(40) NOT NULL DEFAULT '',
`user_pwd` varchar(255) NOT NULL DEFAULT '',
`user_ip` int(11) NOT NULL,
`login_time` datetime NOT NULL,
`create_time` datetime NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
--
-- 转存表中的数据 blog_admin
--
INSERT INTO `blog_admin` VALUES('1','admin','eyJpdiI6IllYcGVMTzJnVTdNYks3TDZGdEgybEE9PSIsInZhbHVlIjoiSnVHMzJNYml1UStcL096YmI2eEpCQ3F0OGRmYnhvbXV3elFBSU5YaWEwdjA9IiwibWFjIjoiYzdmZWM1NzQwYTZiZTZjOWE1OTMxMjYwOTVjYWZiY2U3Mjg2MmI3OWIzYzdhOGQ0YTQ2MDVjZGFhNzEzMjM3MSJ9','0','0000-00-00 00:00:00','0000-00-00 00:00:00');
--
-- 表的结构blog_article
--
DROP TABLE IF EXISTS `blog_article`;
CREATE TABLE `blog_article` (
`art_id` int(11) NOT NULL AUTO_INCREMENT,
`art_title` varchar(100) DEFAULT '',
`art_keywords` varchar(100) DEFAULT '',
`art_discription` varchar(100) DEFAULT '',
`art_view` int(11) DEFAULT NULL,
`art_time` datetime DEFAULT NULL,
`art_image` varchar(255) DEFAULT '',
`art_editor` varchar(100) DEFAULT '',
`art_content` longtext,
`cate_id` int(11) DEFAULT NULL,
PRIMARY KEY (`art_id`)
) ENGINE=MyISAM AUTO_INCREMENT=18 DEFAULT CHARSET=utf8;
--
-- 转存表中的数据 blog_article
--
INSERT INTO `blog_article` VALUES('13','sfdgs d啥地方告诉大哥','防守打法','放到','14','2017-07-14 11:37:03','uploads/20170714113636579.jpg','','<p><br/></p><p><img src=\"/ueditor/php/upload/image/20170714/1500004962828189.jpg\" title=\"1500004962828189.jpg\" alt=\"Anivia_Splash_2.jpg\"/>多个</p><p><img src=\"/ueditor/php/upload/image/20170714/1500004976726763.jpg\" title=\"1500004976726763.jpg\" alt=\"Ashe_Splash_Centered_0.jpg\"/>二手房给个<img src=\"/ueditor/php/upload/image/20170714/1500008445182239.jpg\" title=\"1500008445182239.jpg\" alt=\"Anivia_Splash_5.jpg\"/></p>','29');
INSERT INTO `blog_article` VALUES('12','12312','111111111111111111111111111111','11111111111','1','2017-07-14 11:19:28','uploads/20170714111920326.jpg','11111','<p>1111111111111111111111111111111111111111111111111111111111111111111111111111111111111</p>','29');
INSERT INTO `blog_article` VALUES('14','3453445','234','234234','7','2017-07-14 14:09:53','uploads/20170714140427559.jpg','2342','<h1><span style=\"color:#010101;font-family:����;font-size:24px\"><span style=\"font-size:22pt\"><strong>PHP高端技术之服务器架构（2）</strong></span></span></h1><h1><span style=\"color:#010101;font-family:宋体;font-size:24px\"><span style=\"font-size:22pt\"><strong>一、</strong></span></span><span style=\"color:#010101;font-family:Calibri;font-size:24px\"><span style=\"font-size:22pt\"><strong>memcache</strong></span></span><span style=\"color:#010101;font-family:宋体;font-size:24px\"><span style=\"font-size:22pt\"><strong>（</strong></span></span><span style=\"color:#FF0000;font-family:Calibri;font-size:24px\"><span style=\"font-size:22pt\"><strong>LAMP</strong></span></span><span style=\"color:#010101;font-family:宋体;font-size:24px\"><span style=\"font-size:22pt\"><strong>）</strong></span></span></h1><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">需要获取主机的</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">ip</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">地址，然后在远程终端上进行连接。</span></span></p><p></p><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">进入软件包的存放目录：</span></span></p><p><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">#cd /usr/local/src/tar</span></span></p><p></p><h2><span style=\"color:#010101;font-family:���� Light;font-size:18px\"><span style=\"font-size:16pt\"><strong>1、安装memcached（服务端）</strong></span></span></h2><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\"><strong>①文件区分</strong></span></span></p><p></p><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\"><strong>②安装</strong></span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\"><strong>libevent</strong></span></span></p><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">由于</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">memchache</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">需要依赖</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">libevent</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">，因此在执行第三步之前，先安装好</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">libevent</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">。</span></span></p><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">将</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">libevent</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">进行解压缩：</span></span></p><p><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">#tar -zxvf libevent-release-2.1.6-beta.tar.gz</span></span></p><p></p><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">进入软件包：</span></span></p><p><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\"># cd ./libevent-release-2.1.6-beta</span></span></p><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">运行</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">autogen.sh</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">（自动生成，生成需要的</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">configure</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">）</span></span></p><p><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">#./autogen.sh</span></span></p><p></p><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">执行安装：</span></span></p><p><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">#./configure --prefix=/usr/local/libevent</span></span></p><p><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">#make && make install</span></span></p><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">最后看到的界面：</span></span></p><p></p><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\"><strong>③安装</strong></span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\"><strong>memcached</strong></span></span></p><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">在安装完成</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">libevent</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">之后需要回到软件包的存放目录：</span></span></p><p><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">#cd ..</span></span></p><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">解压软件包：</span></span></p><p></p><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">进入压缩包解压目录：</span></span></p><p><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\"># cd ./memcached-1.4.31</span></span></p><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">运行</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">autogen.sh</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">生成</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">configure</span></span></p><p><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">#./autogen.sh</span></span></p><p></p><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">安装：</span></span></p><p><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">#./configure --prefix=/usr/local/memcache --with-libevent=/usr/local/libevent</span></span></p><p><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">#make && make install</span></span></p><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">最后看到的界面：</span></span></p><p></p><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\"><strong>④目录结构</strong></span></span></p><p></p><p><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">Bin</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">目录：二进制文件的存放目录；</span></span></p><p><img src=\"http://www.lixiaohui.com/resources/org/ueditor/themes/default/images/spacer.gif\" alt=\"graphic\" height=\"52\" width=\"689\"/></p><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\"><strong>⑤启动</strong></span></span></p><p><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">#/usr/local/memcache/bin/memcached -d -m 5122 -l 127.0.0.1 -p 11211 -u root</span></span></p><p><img src=\"http://www.lixiaohui.com/resources/org/ueditor/themes/default/images/spacer.gif\" alt=\"graphic\" height=\"45\" width=\"692\"/></p><p><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">-d</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">：以守护进程的形式启动；</span></span></p><p><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">-m</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">：表示分配的空间大小，单位是</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">mb</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">；</span></span></p><p><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">-l</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">：指定主机的地址；</span></span></p><p><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">-p</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">：</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">port</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">，表示指定的端口号</span></span></p><p><span style=\"color:#FF0000;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\"><strong>关于端口号的说明：端口号一般不管是什么软件都有一个默认的端口号，如果想改是可以改的，但是端口号有范围，取值范围是</strong></span></span><span style=\"color:#FF0000;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\"><strong>1-65535</strong></span></span><span style=\"color:#FF0000;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\"><strong>，</strong></span></span><span style=\"color:#FF0000;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\"><strong>65535</strong></span></span><span style=\"color:#FF0000;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\"><strong>是</strong></span></span><span style=\"color:#FF0000;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\"><strong>16</strong></span></span><span style=\"color:#FF0000;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\"><strong>位二进制最大数。</strong></span></span></p><p><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">-u</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">：以具体的身份执行</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">memchache</span></span></p><h2><span style=\"color:#010101;font-family:���� Light;font-size:18px\"><span style=\"font-size:16pt\"><strong>2、安装memcache扩展</strong></span></span></h2><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\"><strong>①安装</strong></span></span></p><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">解压：</span></span></p><p><span style=\"color:#FF0000;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\"><strong>先回到软件包的存放目录</strong></span></span></p><p><span style=\"color:#FF0000;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">#cd /usr/local/src/tar</span></span></p><p><span style=\"color:#FF0000;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\"># tar -zxvf memcache-3.0.8.tgz</span></span></p><p><span style=\"color:#FF0000;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\"><strong>挂载：让当前扩展获取</strong></span></span><span style=\"color:#FF0000;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\"><strong>php</strong></span></span><span style=\"color:#FF0000;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\"><strong>的版本号和</strong></span></span><span style=\"color:#FF0000;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\"><strong>php</strong></span></span><span style=\"color:#FF0000;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\"><strong>扩展编译时间</strong></span></span></p><p><span style=\"color:#FF0000;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\"><strong># cd ./memcache-3.0.8</strong></span></span></p><p><span style=\"color:#FF0000;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\"><strong>#/usr/local/php/bin/phpize</strong></span></span></p><p></p><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">安装：</span></span></p><p><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">#./configure --with-php-config=/usr/local/php/bin/php-config</span></span></p><p><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">#make && make install</span></span></p><p></p><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">检查扩展生成情况</span></span></p><p></p><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\"><strong>②修改</strong></span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\"><strong>php</strong></span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\"><strong>配置文件，整合到</strong></span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\"><strong>php</strong></span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\"><strong>中去</strong></span></span></p><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">需要去修改</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">php</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">的配置文件，在配置中添加新的扩展启动代码，然后保存退出：</span></span></p><p><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">#vim /usr/local/php/lib/php.ini</span></span></p><p></p><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">在更改配置文件之后重启启动</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">apache</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">，如果之前没有启动则启动即可。</span></span></p><p><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\"># /usr/local/http2/bin/apachectl start </span></span> <span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">或者</span></span> <span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">restart</span></span></p><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\"><strong>③打印</strong></span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\"><strong>phpinfo</strong></span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\"><strong>进行验证</strong></span></span><strong style=\"font-size: 16pt; color: rgb(1, 1, 1); font-family: "���� Light";\">3、在php中使用memcache</strong></p><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">需要在</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">apache</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">的站点中创建</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">php</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">测试文件，来测试下</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">memcache</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">的使用：</span></span></p><p><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">#vim /usr/local/http2/htdocs/memchache.php</span></span></p><p></p><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">测试结果：</span></span></p><p></p><h1><span style=\"color:#010101;font-family:宋体;font-size:24px\"><span style=\"font-size:22pt\"><strong>二、运维中常见的概念性词语</strong></span></span></h1><h2><span style=\"color:#FF0000;font-family:���� Light;font-size:18px\"><span style=\"font-size:16pt\"><strong>1、web服务器</strong></span></span></h2><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">常见的</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">web</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">服务器有</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">apache</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">、</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">nginx</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">、</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">lighttpd</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">、</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">iis</span></span></p><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">四大服务器：</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">apache</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">、</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">nginx</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">、</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">lighttpd</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">、</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">iis</span></span></p><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">三大服务器：</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">apache</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">、</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">nginx</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">、</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">lighttpd</span></span></p><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">①</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">apache</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">：是由</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">apache</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">基金会出资研发的服务器软件，是目前最受欢迎使用量最多的一个</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">web</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">服务器之一；</span></span></p><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">②</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">nginx</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">：是俄罗斯一家网站自己使用</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">web</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">服务器，后来由于效果比较好，得到开源。目前国内也有部分良心企业，例如阿里，在</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">nginx</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">的基础上进一步进行优化，衍生出一些</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">nginx</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">的分支版本，如：</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">tengine</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">（</span></span><a href=\"http://tengine.taobao.org/\"><span style=\"color:#0563C1;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\"><span style=\"text-decoration:underline;\">http://tengine.taobao.org/</span></span></span></a><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">）；</span></span></p><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">③</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">lighttpd</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">：是德国人开发一款轻量级服务器软件，在某些方面性能要比</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">nginx</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">和</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">apache</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">要好；</span></span></p><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">④</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">iis</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">：全称</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">internet information service</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">，是微软公司集成在</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">windows</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">操作系统（办公系统、服务器系统）中的一个服务器软件。</span></span></p><p></p><h2><span style=\"color:#FF0000;font-family:���� Light;font-size:18px\"><span style=\"font-size:16pt\"><strong>2、负载均衡（集群）</strong></span></span></h2><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">负载均衡就是一个请求流量分发过程。将多个服务器组成一个集群，指定一个主服务器，用来接受用户的访问请求（不处理），然后在其后指定多个从服务器，当主服务器获取到请求之后会将这些请求按照一定的权重比例分派给从服务器处理，相当于将并发转移给从服务器：</span></span></p><p></p><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">例如：如果有</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">1000</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">人同时访问主服务器（</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">1000</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">并发），但是后面有</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">10</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">个从服务器，相当于么个服务器能够获得</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">100</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">个人的并发数。就能解决高并发的问题。</span></span></p><h2><span style=\"color:#010101;font-family:���� Light;font-size:18px\"><span style=\"font-size:16pt\"><strong>3、数据库服务器</strong></span></span></h2><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">在以后实际开发的时候并不会像现在的学习环境下，将</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">web</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">服务器和数据库安装在一起，一般都会将数据库单独的安装在一个服务器上。这个服务器称之为数据库服务器。</span></span></p><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">常见的有：</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">mysql</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">服务器、</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">mssql</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">服务器、</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">oracle</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">服务器。</span></span></p><h2><span style=\"color:#010101;font-family:���� Light;font-size:18px\"><span style=\"font-size:16pt\"><strong>4、静态资源服务器</strong></span></span></h2><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">静态资源一般是指：</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">css</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">、</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">js</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">、图片等不会经常变动的文件。</span></span></p><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">在开发的也是会单独的存放的。</span></span></p><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">好处：</span></span></p><p><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\"> </span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">①物以类聚，在管理的时候比较方便；</span></span></p><p><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\"> </span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\"><strong>②如果配合</strong></span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\"><strong>CDN</strong></span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\"><strong>使用，则会造成很大的经济效益，可以每年省下很多开支；</strong></span></span></p><h2><span style=\"color:#FF0000;font-family:���� Light;font-size:18px\"><span style=\"font-size:16pt\"><strong>5、cdn</strong></span></span></h2><p><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">CDN</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">（</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">Content Delivery Network</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">）内容分发网络，其侧重点是缓存。其能够长期缓存网站的静态文件。</span></span></p><p></p><p><span style=\"color:#FF0000;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\"><strong>优点：</strong></span></span></p><p><span style=\"color:#FF0000;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\"><strong> </strong></span></span><span style=\"color:#FF0000;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\"><strong>①能缓存静态文件，节省带宽的开支；</strong></span></span></p><p><span style=\"color:#FF0000;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\"><strong> </strong></span></span><span style=\"color:#FF0000;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\"><strong>②能够掩盖服务器端的真实</strong></span></span><span style=\"color:#FF0000;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\"><strong>ip</strong></span></span><span style=\"color:#FF0000;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\"><strong>地址，能够有效的提高安全性；</strong></span></span></p><p><span style=\"color:#FF0000;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\"><strong> </strong></span></span><span style=\"color:#FF0000;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\"><strong>③能够在大并发的情况将一些请求转嫁给</strong></span></span><span style=\"color:#FF0000;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\"><strong>CDN</strong></span></span><span style=\"color:#FF0000;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\"><strong>节点，减轻本身</strong></span></span><span style=\"color:#FF0000;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\"><strong>web’</strong></span></span><span style=\"color:#FF0000;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\"><strong>服务器的压力；</strong></span></span></p><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">因此大公司或者大并发的网站一般都会使用</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">CDN</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">网络。目前主流的配置形式是直接购买</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">ISP</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">的服务器。</span></span></p><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt; background:#ffff00\"><strong>技巧：如何去判断一个网站是否使用了</strong></span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt; background:#ffff00\"><strong>CDN</strong></span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt; background:#ffff00\"><strong>？</strong></span></span></p><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">如果没用</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">CDN</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">的话，是用户直接访问</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">web</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">服务器，服务器</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">ip</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">地址应该是固定不变的，如果使用了</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">CDN</span></span><strong>需要关闭当前</strong><span style=\"color: rgb(1, 1, 1); font-family: Calibri; font-size: 12px;\"><span style=\"font-size:10pt\"><strong>lnmp</strong></span></span><span style=\"color: rgb(1, 1, 1); font-family: 宋体; font-size: 12px;\"><span style=\"font-size:10pt\"><strong>，然后克隆</strong></span></span><span style=\"color: rgb(1, 1, 1); font-family: Calibri; font-size: 12px;\"><span style=\"font-size:10pt\"><strong>2</strong></span></span><span style=\"color: rgb(1, 1, 1); font-family: 宋体; font-size: 12px;\"><span style=\"font-size:10pt\"><strong>个新的</strong></span></span></p><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">①获取三个主机的</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">ip</span></span></p><p><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">192.168.64.143</span></span></p><p><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">192.168.64.148</span></span></p><p><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">192.168.64.149</span></span></p><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">②开启三个</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">linux</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">的需要开启的程序（</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">nginx</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">，</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">php-fpm</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">）</span></span><span style=\"color: rgb(255, 0, 0); font-family: "���� Light"; font-size: 16pt;\"><strong>3、配置nginx负载均衡（</strong></span><span style=\"color: rgb(255, 0, 0); font-family: "���� Light"; font-size: 16pt; background: rgb(0, 255, 0);\"><strong>分流</strong></span><span style=\"color: rgb(255, 0, 0); font-family: "���� Light"; font-size: 16pt;\"><strong>）</strong></span></p><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">在做负载均衡的时候得有一个主的代理服务器，至少</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">2</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">个从服务器，因此一共需要三个服务器。需要从下面三个</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">ip</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">中确定服务器的身份，选择一个作为主服务器：</span></span></p><p><span style=\"color:#FF0000;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\"><strong>192.168.64.143</strong></span></span><span style=\"color:#FF0000;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\"><strong>（主）</strong></span></span></p><p><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">192.168.64.148</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">（从）</span></span></p><p><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">192.168.64.149</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">（从）</span></span></p><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\"><strong>①配置（</strong></span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\"><strong>nginx</strong></span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\"><strong>的负载均衡中，配置是针对主服务器配置）</strong></span></span></p><p><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">Nginx</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">负载均衡的配置代码：</span></span></p><p><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt; background:#ffff00\">upstream</span></span> <span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt; background:#ffff00\">主机头</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt; background:#ffff00\">{</span></span></p><p><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt; background:#ffff00\"> server</span></span> <span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt; background:#ffff00\">服务器</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt; background:#ffff00\">1ip</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt; background:#ffff00\">地址</span></span> <span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt; background:#ffff00\">weight=1 max_fails=3 fail_timeout=20s;</span></span></p><p><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt; background:#ffff00\"> server</span></span> <span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt; background:#ffff00\">服务器</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt; background:#ffff00\">2ip</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt; background:#ffff00\">地址</span></span> <span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt; background:#ffff00\">weight=1 max_fails=3 fail_timeout=20s;</span></span></p><p><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt; background:#ffff00\">}</span></span></p><p><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt; background:#ffff00\">location /{</span></span></p><p><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt; background:#ffff00\"> proxy_pass http://</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt; background:#ffff00\">主机头</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt; background:#ffff00\">;</span></span></p><p><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt; background:#ffff00\">}</span></span></p><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">使用</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">filezilla+sublime</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">打开主服务器的</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">nginx</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">的配置文件：</span></span></p><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">需要将上面的第一段配置添加到</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">server</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">段前面：</span></span></p><p></p><p><span style=\"color:#FF0000;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\"><strong>Weight</strong></span></span><span style=\"color:#FF0000;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\"><strong>：权重，主服务器给从服务器分派请求的权重比例，如果都是</strong></span></span><span style=\"color:#FF0000;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\"><strong>1</strong></span></span><span style=\"color:#FF0000;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\"><strong>则表示给每个服务器轮询分派；</strong></span></span></p><p><span style=\"color:#FF0000;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\"><strong>Max_fails</strong></span></span><span style=\"color:#FF0000;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\"><strong>：最大的失败次数，当主服务器分派的时候如果失败的次数达到该项指定值，则在一段时间内就不会再给这个服务器进行分派请求；</strong></span></span></p><p><span style=\"color:#FF0000;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\"><strong>Fail_timeoit</strong></span></span><span style=\"color:#FF0000;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\"><strong>：最大是等待时间，当主服务器分派的请求超过指定的时间如果得不到处理，则不会再给这个服务器分派请求，时间单位默认是秒；</strong></span></span></p><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">将第二段的配置替换掉原先</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">server</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">里面的</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">location</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">：</span></span></p><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\"><strong>替换的原因就是因为主服务器本身不解析</strong></span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\"><strong>php</strong></span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\"><strong>文件的，只是有一个分派请求的功能，如果保留了之前的</strong></span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\"><strong>location</strong></span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\"><strong>段，则会解析</strong></span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\"><strong>php</strong></span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\"><strong>文件，这个有悖于负载均衡的定义</strong></span><span style=\"font-size:10pt\">。</span></span></p><p></p><p><span style=\"color:#FF0000;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\"><strong>注意：配置完成之后记得把配置上传回服务器。</strong></span></span></p><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\"><strong>②启动</strong></span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\"><strong>/</strong></span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\"><strong>重新加载配置文件</strong></span></span></p><p><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">#/usr/local/nginx/sbin/nginx -s reload</span></span></p><p></p><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\"><strong>③测试</strong></span></span></p><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">分别在另外</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">2</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">个从服务器中的首页文件中打印输出各自的</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">ip</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">地址：</span></span></p><p></p><p></p><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">最后通过</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">windows</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">下的浏览器来输入</span></span><a href=\"http://shop.itcast.biz/\"><span style=\"color:#0563C1;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\"><span style=\"text-decoration:underline;\">http://shop.itcast.biz</span></span></span></a><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">进行访问，如果一次输出</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">192.168.64.148</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">，再刷新的时候输出</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">192.168.64.149</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">的话，则说明负载均衡配置成功。</span></span><strong style=\"font-size: 16pt; color: rgb(255, 0, 0); font-family: "���� Light";\">4、mysql的主从复制</strong></p><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">典型的应用：数据库的自动备份。</span></span></p><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt; background:#ffff00\"><strong>主从复制的操作本质就是备份还原的操作，与正常</strong></span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt; background:#ffff00\"><strong>mysql</strong></span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt; background:#ffff00\"><strong>备份差异就是这个操作是自动化，并且跨服服务器</strong></span><span style=\"font-size:10pt\">。</span></span></p><p></p><p><span style=\"color:#FF0000;font-family:微软雅黑;font-size:12px\"><span style=\"font-size:10pt\"><strong>主从复制的原理：可以类比于sql语句的导出和导入</strong></span></span><span style=\"color:#010101;font-family:微软雅黑;font-size:12px\"><span style=\"font-size:10pt\">。</span></span></p><p><span style=\"color:#010101;font-family:微软雅黑;font-size:12px\"><span style=\"font-size:10pt\">确认身份：</span></span></p><p><span style=\"color:#010101;font-family:���ź�;font-size:12px\"><span style=\"font-size:10pt\">192.168.64.143 主</span></span></p><p><span style=\"color:#010101;font-family:���ź�;font-size:12px\"><span style=\"font-size:10pt\">192.168.64.148 从</span></span></p><h3><span style=\"color:#010101;font-family:���� Light;font-size:18px\"><span style=\"font-size:16pt\"><strong>1、开启二进制日志文件</strong></span></span></h3><p><span style=\"color:#0000FF;font-family:微软雅黑;font-size:12px\"><span style=\"font-size:10pt\">①设置主数据库的配置</span></span></p><p><span style=\"color:#0000FF;font-family:微软雅黑;font-size:12px\"><span style=\"font-size:10pt\">修改数据库的配置文件my.cnf（/etc/my.cnf）</span></span></p><p><span style=\"color:#0000FF;font-family:���ź�;font-size:12px\"><span style=\"font-size:10pt\">#vim /etc/my.cnf</span></span></p><p></p><p><span style=\"color:#0000FF;font-family:微软雅黑;font-size:12px\"><span style=\"font-size:10pt\">②设置从数据库的配置</span></span></p><p><span style=\"color:#0000FF;font-family:微软雅黑;font-size:12px\"><span style=\"font-size:10pt\">修改数据库的配置子文件my.cnf（/etc/my.cnf）</span></span></p><p><span style=\"color:#0000FF;font-family:���ź�;font-size:12px\"><span style=\"font-size:10pt\">#vim /etc/my.cnf</span></span></p><p></p><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">主要得保证两个</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">mysql</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">的</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">server-id</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">序号不一样。</span></span></p><p><span style=\"color:#FF0000;font-family:微软雅黑;font-size:12px\"><span style=\"font-size:10pt\"><strong>修改完成之后，启动/重启mysql服务</strong></span></span><span style=\"color:#010101;font-family:微软雅黑;font-size:12px\"><span style=\"font-size:10pt\">。</span></span></p><p><span style=\"color:#010101;font-family:微软雅黑;font-size:12px\"><span style=\"font-size:10pt\">在各自服务器上运行启动的命令：</span></span></p><p><span style=\"color:#010101;font-family:���ź�;font-size:12px\"><span style=\"font-size:10pt\">#/usr/local/mysql/bin/mysqld_safe --user=mysql &</span></span></p><h3><span style=\"color:#010101;font-family:���� Light;font-size:18px\"><span style=\"font-size:16pt\"><strong>2、主服务器开启同步账号</strong></span></span></h3><p><span style=\"color:#010101;font-family:���ź�;font-size:12px\"><span style=\"font-size:10pt\">grant作用：创建一个有自动复制功能的账号(主从</span></span><span style=\"color:#FF0000;font-family:微软雅黑;font-size:12px\"><span style=\"font-size:10pt\">复制)</span></span> <span style=\"color:#010101;font-family:���ź�;font-size:12px\"><span style=\"font-size:10pt\">，允许复制*.* 全部数据库/全部数据表 ，账号名字是slave,允许其在%任何主机进行复制，复制数据的时候需要使用密码123456</span></span></p><p><span style=\"color:#010101;font-family:微软雅黑;font-size:12px\"><span style=\"font-size:10pt\">如果需要让从数据库去主数据库上获取数据，则要提供给从数据库一帐号。</span></span></p><p><span style=\"color:#010101;font-family:微软雅黑;font-size:12px\"><span style=\"font-size:10pt; background:#ffff00\">在</span></span><span style=\"color:#FF0000;font-family:微软雅黑;font-size:12px\"><span style=\"font-size:10pt; background:#ffff00\">主服务器</span></span><span style=\"color:#010101;font-family:微软雅黑;font-size:12px\"><span style=\"font-size:10pt; background:#ffff00\">上的mysql命令行中执行</span></span></p><p><span style=\"color:#FF0000;font-family:���ź�;font-size:12px\"><span style=\"font-size:10pt\">mysql</span></span> <span style=\"color:#0000FF;font-family:���ź�;font-size:12px\"><span style=\"font-size:10pt\">> grant replication</span> <span style=\"font-size:10pt; background:#ffff00\">slave</span> <span style=\"font-size:10pt\">on *.* to 'slave'@'%' identified by</span> <span style=\"font-size:10pt; background:#ffff00\">'123456'</span><span style=\"font-size:10pt\">;</span></span></p><p><span style=\"color:#FF0000;font-family:���ź�;font-size:12px\"><span style=\"font-size:10pt\">mysql</span></span> <span style=\"color:#0000FF;font-family:���ź�;font-size:12px\"><span style=\"font-size:10pt\">></span></span><span style=\"color:#FF0000;font-family:���ź�;font-size:12px\"><span style=\"font-size:10pt\">flush privileges;</span></span></p><p></p><h3><span style=\"color:#010101;font-family:���� Light;font-size:18px\"><span style=\"font-size:16pt\"><strong>3、查看同步状态，在主</strong></span></span><span style=\"color:#0000FF;font-family:���� Light;font-size:18px\"><span style=\"font-size:16pt\"><strong>mysql</strong></span></span></h3><p><span style=\"color:#010101;font-family:���ź�;font-size:12px\"><span style=\"font-size:10pt\">mysql>show master status;</span></span></p><p></p><p><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">File</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">：就是指二进制文件的名称；</span></span></p><p><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">Position</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">：位置，二进制文件的位置；</span></span></p><h3><span style=\"color:#010101;font-family:���� Light;font-size:18px\"><span style=\"font-size:16pt\"><strong>4、从mysql与主mysql进行连接</strong></span></span></h3><p><span style=\"color:#010101;font-family:微软雅黑;font-size:12px\"><span style=\"font-size:10pt; background:#ffff00\">在从服务器上执行</span></span></p><p><span style=\"color:#010101;font-family:微软雅黑;font-size:12px\"><span style=\"font-size:10pt\">如果之前从服务有启动，先停止slave服务，slave stop</span></span></p><p><span style=\"color:#0000FF;font-family:���ź�;font-size:12px\"><span style=\"font-size:10pt\">Mysql > change master to master_host='</span><span style=\"font-size:10pt; background:#ffff00\">主mysql服务器的ip地址</span><span style=\"font-size:10pt\">',master_user=</span><span style=\"font-size:10pt; background:#ffff00\">'slave'</span><span style=\"font-size:10pt\">,master_password=</span><span style=\"font-size:10pt; background:#ffff00\">'123456'</span><span style=\"font-size:10pt\">,master_log_file='</span><span style=\"font-size:10pt; background:#ffff00\">二进制文件名</span><span style=\"font-size:10pt\">',master_log_pos=</span><span style=\"font-size:10pt; background:#ffff00\">二进制文件位置地址</span><span style=\"font-size:10pt\">;</span></span></p><p><span style=\"color:#010101;font-family:微软雅黑;font-size:12px\"><span style=\"font-size:10pt\">将上述的命令按照当前的环境需求，进行变更，最后的sql应该是：</span></span></p><p><span style=\"color:#0000FF;font-family:���ź�;font-size:12px\"><span style=\"font-size:10pt\">change master to master_host='192.168.64.143',master_user=</span><span style=\"font-size:10pt; background:#ffff00\">'slave'</span><span style=\"font-size:10pt\">,master_password=</span><span style=\"font-size:10pt; background:#ffff00\">'123456'</span><span style=\"font-size:10pt\">,master_log_file='</span></span> <span style=\"color:#0000FF;font-family:���ź�;font-size:12px\"><span style=\"font-size:10pt\">mysql-bin.000006',master_log_pos=325;</span></span><span style=\"color: rgb(1, 1, 1); font-family: "���� Light"; font-size: 18px;\"><span style=\"font-size:16pt\"><strong>5、启动</strong></span></span><span style=\"color: rgb(0, 0, 255); font-family: "等线 Light"; font-size: 18px;\"><span style=\"font-size:16pt\"><strong>从服务器</strong></span></span><span style=\"color: rgb(1, 1, 1); font-family: "等线 Light"; font-size: 18px;\"><span style=\"font-size:16pt\"><strong>的复制功能</strong></span></span></p><p><span style=\"color:#010101;font-family:微软雅黑;font-size:12px\"><span style=\"font-size:10pt; background:#ffff00\">从服务器执行</span></span></p><p><span style=\"color:#0000FF;font-family:微软雅黑;font-size:12px\"><span style=\"font-size:10pt\">直接执行 slave start</span></span><img src=\"http://www.lixiaohui.com/resources/org/ueditor/themes/default/images/spacer.gif\" alt=\"graphic\" height=\"74\" width=\"516\"/></p><h3><span style=\"color:#010101;font-family:���� Light;font-size:18px\"><span style=\"font-size:16pt\"><strong>6、验证</strong></span></span><span style=\"color:#0000FF;font-family:等线 Light;font-size:18px\"><span style=\"font-size:16pt\"><strong>从服务器</strong></span></span><span style=\"color:#010101;font-family:等线 Light;font-size:18px\"><span style=\"font-size:16pt\"><strong>是否同步成功</strong></span></span></h3><p><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">mysql>show slave status \\G;</span></span></p><p></p><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">如果看到</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">2</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">个</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">yes</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">表示成功。</span></span></p><h3><span style=\"color:#010101;font-family:���� Light;font-size:18px\"><span style=\"font-size:16pt\"><strong>7、测试</strong></span></span></h3><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">可以在主数据库中新建一个数据库，然后在从数据库中</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">show</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">一下，如果显示有，则表示成功。</span></span></p><h2><span style=\"color:#FF0000;font-family:���� Light;font-size:18px\"><span style=\"font-size:16pt\"><strong>5、LNMPA（</strong></span></span><span style=\"color:#010101;font-family:���� Light;font-size:18px\"><span style=\"font-size:16pt; background:#ff0000\"><strong>lamp</strong></span><span style=\"font-size:16pt\"><strong>服务器）</strong></span></span></h2><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">架构：由于每个服务器软件有各自的优点，所以遵循“取其精华，去其糟粕”原则将每个服务器的特长发挥出来，组成了新的架构称之为</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">LNMPA</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">。</span></span></p><p><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">Nginx</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">：由于</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">nginx</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">对静态页面的处理效率很好，所以</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">nginx</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">在这个架构下专门负责处理静态；</span></span></p><p><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">Apache</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">：对于动态页面处理比较好，所以其负责处理动态页面。</span></span></p><p></p><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">开启</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">LAMP</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">架构服务器。开启之后获取</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">ip</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">地址，连接终端。</span></span></p><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\"><strong>①配置</strong></span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\"><strong>nginx</strong></span></span></p><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">安装</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">nginx</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">：去软件包的目录，执行脚本文件</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">install_nginx.sh</span></span></p><p></p><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">在安装完成之后的界面：</span></span></p><p></p><p><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">location ~ .php$ {</span></span></p><p><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\"> #</span></span> <span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">向后端服务器发起请求时添加指定的</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">header</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">头信息</span></span></p><p><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\"> proxy_set_header Host $http_host;</span></span></p><p><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\"> #</span></span> <span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">向后端服务器发送真实</span></span> <span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">IP</span></span></p><p><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\"> proxy_set_header X-Real-IP $remote_addr;</span></span></p><p><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\"> #</span></span> <span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">让后端如</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">php</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">能直接通过变量获取真实</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">IP</span></span></p><p><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\"> proxy_set_header X-Forwarded-For $proxy_add_x_forwarded_for;</span></span></p><p><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\"> proxy_pass http://127.0.0.1:8080;</span></span></p><p><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">}</span></span></p><p><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\"># nginx</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">找不到文件时，转发请求给后端</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">Apache</span></span></p><p><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">location @proxy {</span></span></p><p><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\"> proxy_set_header Host $http_host;</span></span></p><p><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\"> proxy_set_header X-Real-IP $remote_addr;</span></span></p><p><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\"> proxy_set_header X-Forwarded-For $proxy_add_x_forwarded_for;</span></span></p><p><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\"> proxy_pass http://127.0.0.1:8080;</span></span></p><p><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">}</span></span></p><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">将上述的配置放到</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">nginx.conf</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">中：</span></span></p><p></p><p></p><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\"><strong>②修改</strong></span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\"><strong>apache</strong></span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\"><strong>端口</strong></span></span></p><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">修改</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">apache</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">的端口号为</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">8080</span></span></p><p><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\"># vim /usr/local/http2/conf/httpd.conf</span></span></p><p></p><p></p><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\"><strong>③设置</strong></span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\"><strong>apache</strong></span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\"><strong>站点根目录</strong></span></span></p><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">由于当前的架构是服务于一个站点，因此需要将</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">2</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">个服务器软件的站点目录进行合并：</span></span></p><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">选择</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">nginx</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">的站点作为默认站点：</span></span></p><p><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\"># vim /usr/local/http2/conf/httpd.conf</span></span></p><p></p><p></p><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\"><strong>④启动</strong></span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\"><strong>apache</strong></span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\"><strong>、</strong></span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\"><strong>nginx</strong></span></span></p><p></p><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\"><strong>⑤测试访问</strong></span></span></p><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">在</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">nginx</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">的站点目录下创建</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">php</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">文件，测试结果：</span></span></p><p><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">#vim /usr/local/nginx/html/php54.php</span></span></p><p></p><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">通过</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">windows</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">服务器进行浏览器测试：</span></span></p><p></p><p><br/></p>','29');
INSERT INTO `blog_article` VALUES('15','PHP高端技术之服务器架构','PHP高端技术之服务器架构','PHP高端技术之服务器架构','15','2017-07-14 15:35:32','uploads/20170714153528224.jpg','123','<h1><span style=\"color:#010101;font-family:����;font-size:24px\"><span style=\"font-size:22pt\"><strong>PHP高端技术之服务器架构（1）</strong></span></span></h1><h1><span style=\"color:#010101;font-family:宋体;font-size:24px\"><span style=\"font-size:22pt\"><strong>一、准备工作</strong></span></span></h1><h2><span style=\"color:#010101;font-family:���� Light;font-size:18px\"><span style=\"font-size:16pt\"><strong>1、linux系统安装</strong></span></span></h2><p><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">Linux</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">常见的安装方式有</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">2</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">个：</span></span></p><p><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\"> </span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">①真机安装</span></span></p><p><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\"> </span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">②虚拟机安装</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\"> </span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">（可以使用虚拟软件，</span></span><span style=\"color:#FF0000;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">VM</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">、</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">VBox</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">）</span></span></p><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">注意事项：</span></span></p><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">①在进行到网络配置的页面，不要去修改主机的名称，如果修改了后期会引起</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">apache</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">启动不了；</span></span></p><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">②配置网络的时候默认开启“网卡自动连接”，以后虚拟机在开机之后会自动获取</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">ip</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">地址；</span></span></p><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">③在安装软件的时候，选择“现在自定义”、“开发”、“开发工具”，一定得把“开发工具”前面的复选框给勾选上；</span></span></p><h2><span style=\"color:#010101;font-family:���� Light;font-size:18px\"><span style=\"font-size:16pt\"><strong>2、上传所需软件</strong></span></span></h2><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">上传之前需要先获取虚拟机的</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">ip</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">地址：</span></span></p><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">在</span></span><span style=\"color:#FF0000;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">centos6.x</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">版本的系统中，获取</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">ip</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">的命令是：</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\"><strong>#ifconfig</strong></span></span></p><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">在</span></span><span style=\"color:#FF0000;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">centos7.x</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">版本的系统中，获取</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">ip</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">的命令是：</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\"><strong>#ip addr</strong></span></span></p><p><img src=\"http://www.lixiaohui.com/resources/org/ueditor/themes/default/images/spacer.gif\" alt=\"graphic\" height=\"91\" width=\"463\"/></p><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">文件上传可以使用</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">filezilla</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">进行上传</span></span></p><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">上传保存目录必须是</span></span><span style=\"color:#FF0000;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\"><strong>/usr/local/src</strong></span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">目录。</span></span></p><p><img src=\"http://www.lixiaohui.com/resources/org/ueditor/themes/default/images/spacer.gif\" alt=\"graphic\" height=\"112\" width=\"692\"/></p><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">将需要的文件：</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">tar.tar.gz</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">上传到指定的目录：</span></span></p><p><img src=\"http://www.lixiaohui.com/resources/org/ueditor/themes/default/images/spacer.gif\" alt=\"graphic\" height=\"229\" width=\"385\"/></p><h2><span style=\"color:#010101;font-family:���� Light;font-size:18px\"><span style=\"font-size:16pt\"><strong>3、实用功能设置（建议）</strong></span></span></h2><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\"><strong>①设置</strong></span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\"><strong>vim</strong></span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\"><strong>让其默认的显示号行。</strong></span></span></p><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">设置方法：修改</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">vim</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">的配置文件，</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">vim</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">在</span></span><span style=\"color:#FF0000;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">每个用户自己的家目录中</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">存在一个配置文件（如果没有可以自己创建）文件名：</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">.vimrc</span></span></p><p><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">#cd ~</span></span></p><p><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">#vim .vimrc</span></span></p><p><img src=\"http://www.lixiaohui.com/resources/org/ueditor/themes/default/images/spacer.gif\" alt=\"graphic\" height=\"85\" width=\"311\"/></p><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">保存退出</span></span></p><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\"><strong>②设置清屏快捷键。</strong></span></span></p><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">清屏命令：</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">#clear</span></span></p><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">在开发的时候一般会把输入比较麻烦的命令做快捷键的设置。</span></span></p><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">需要去配置快捷键的配置文件，存在于每个用户的家目录下，文件名叫做</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">.bashrc</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">。</span></span></p><p><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">#vim .bashrc</span></span></p><p><img src=\"http://www.lixiaohui.com/resources/org/ueditor/themes/default/images/spacer.gif\" alt=\"graphic\" height=\"199\" width=\"525\"/></p><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">在其中新增代码：</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">alias cls=’clear’</span></span></p><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">在设置完成别名操作之后需要当前用户重新去登录，才会生效。</span></span></p><h2><span style=\"color:#010101;font-family:���� Light;font-size:18px\"><span style=\"font-size:16pt\"><strong>4、系统克隆备份</strong></span></span></h2><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">很有必要性。防止系统在后期使用的时候崩溃。</span></span></p><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">备份的时候需要关闭虚拟机中的操作系统。</span></span></p><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">选择“管理”、“克隆”：</span></span></p><p><img src=\"http://www.lixiaohui.com/resources/org/ueditor/themes/default/images/spacer.gif\" alt=\"graphic\" height=\"228\" width=\"574\"/></p><p><img src=\"http://www.lixiaohui.com/resources/org/ueditor/themes/default/images/spacer.gif\" alt=\"graphic\" height=\"280\" width=\"589\"/></p><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">在进度条走完之后关闭对话框即可。</span></span></p><h1><span style=\"color:#010101;font-family:宋体;font-size:24px\"><span style=\"font-size:22pt\"><strong>二、</strong></span></span><span style=\"color:#010101;font-family:Calibri;font-size:24px\"><span style=\"font-size:22pt\"><strong>lamp</strong></span></span><span style=\"color:#010101;font-family:宋体;font-size:24px\"><span style=\"font-size:22pt\"><strong>环境安装</strong></span></span></h1><h2><span style=\"color:#010101;font-family:���� Light;font-size:18px\"><span style=\"font-size:16pt\"><strong>1、安装前的说明</strong></span></span></h2><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\"><strong>①查看新开主机的</strong></span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\"><strong>ip</strong></span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\"><strong>地址，使用远程终端连接操作</strong></span></span></p><p><img src=\"http://www.lixiaohui.com/resources/org/ueditor/themes/default/images/spacer.gif\" alt=\"graphic\" height=\"124\" width=\"533\"/></p><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">后期的终端软件以putty为例。</span></span></p><p><img src=\"http://www.lixiaohui.com/resources/org/ueditor/themes/default/images/spacer.gif\" alt=\"graphic\" height=\"105\" width=\"466\"/></p><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\"><strong>②在</strong></span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\"><strong>linux</strong></span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\"><strong>下解压缩的命令</strong></span></span></p><p><span style=\"color:#FF0000;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\"><strong>在</strong></span></span><span style=\"color:#FF0000;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\"><strong>linux</strong></span></span><span style=\"color:#FF0000;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\"><strong>下常见的压缩文件后缀有</strong></span></span><span style=\"color:#FF0000;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\"><strong>tar.gz</strong></span></span><span style=\"color:#FF0000;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\"><strong>、</strong></span></span><span style=\"color:#FF0000;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\"><strong>bz2</strong></span></span></p><p><span style=\"color:#FF0000;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\"><strong>解压</strong></span></span><span style=\"color:#FF0000;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\"><strong>tar.gz</strong></span></span><span style=\"color:#FF0000;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\"><strong>后缀的命令：</strong></span></span><span style=\"color:#FF0000;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\"><strong>#tar -zxvf</strong></span></span> <span style=\"color:#FF0000;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\"><strong>需要解压的文件</strong></span></span></p><p><span style=\"color:#FF0000;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\"><strong>解压</strong></span></span><span style=\"color:#FF0000;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\"><strong>bz2</strong></span></span><span style=\"color:#FF0000;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\"><strong>后缀的命令：</strong></span></span><span style=\"color:#FF0000;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\"><strong>#tar -jxvf</strong></span></span> <span style=\"color:#FF0000;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\"><strong>需要解压的文件</strong></span></span></p><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\"><strong>③</strong></span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\"><strong>shell</strong></span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\"><strong>脚本</strong></span></span></p><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">面试：你会不会写</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">shell</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">脚本？</span></span></p><p><span style=\"color:#FF0000;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\"><strong>就是将</strong></span></span><span style=\"color:#FF0000;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\"><strong>linux</strong></span></span><span style=\"color:#FF0000;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\"><strong>下每一个单独的命令写到一个文件中去，这个文件我们称之为</strong></span></span><span style=\"color:#FF0000;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\"><strong>shell</strong></span></span><span style=\"color:#FF0000;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\"><strong>脚本</strong></span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">。</span></span></p><p><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">Shell</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">脚本常用后缀有</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">.sh</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">。</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">shell</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">在</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">windows</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">下也存在应用，在</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">windows</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">下称之为批处理，常见后缀是</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">.bat</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">。</span></span></p><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">使用</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">shell</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">脚本的好处就是可以节省在安装过程中的时间。</span></span></p><p><img src=\"http://www.lixiaohui.com/resources/org/ueditor/themes/default/images/spacer.gif\" alt=\"graphic\" height=\"213\" width=\"482\"/></p><h2><span style=\"color:#010101;font-family:���� Light;font-size:18px\"><span style=\"font-size:16pt\"><strong>2、安装基础扩展库</strong></span></span></h2><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\"><strong>脚本文件名：</strong></span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\"><strong>install_base.sh</strong></span></span></p><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">在后期运行</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">apache</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">和</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">php</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">的时候需要一些基础软件的支持，例如使用</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">php</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">就会用到</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">GD</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">库，使用</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">apache</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">就得使用</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">zlib</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">库，因此先得安装好对应的库和扩展。</span></span></p><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">解压程序集合压缩包：</span></span></p><p><img src=\"http://www.lixiaohui.com/resources/org/ueditor/themes/default/images/spacer.gif\" alt=\"graphic\" height=\"105\" width=\"582\"/></p><p><img src=\"http://www.lixiaohui.com/resources/org/ueditor/themes/default/images/spacer.gif\" alt=\"graphic\" height=\"89\" width=\"686\"/></p><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">安装需要执行脚本文件：</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">install_base.sh</span></span></p><p><img src=\"http://www.lixiaohui.com/resources/org/ueditor/themes/default/images/spacer.gif\" alt=\"graphic\" height=\"64\" width=\"685\"/></p><p><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">#./install_base.sh</span></span></p><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">安装完成之后看到的界面：</span></span></p><p><img src=\"http://www.lixiaohui.com/resources/org/ueditor/themes/default/images/spacer.gif\" alt=\"graphic\" height=\"107\" width=\"689\"/></p><h2><span style=\"color:#010101;font-family:���� Light;font-size:18px\"><span style=\"font-size:16pt\"><strong>3、安装Apache</strong></span></span></h2><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\"><strong>脚本文件名：</strong></span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\"><strong>install_apache.sh</strong></span></span></p><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">由于当前的操作系统已经安装好了</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">apache</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">，所以需要先进行卸载操作。</span></span></p><p><img src=\"http://www.lixiaohui.com/resources/org/ueditor/themes/default/images/spacer.gif\" alt=\"graphic\" height=\"120\" width=\"683\"/></p><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">删除命令：</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\"><strong>#rpm -e</strong></span></span> <span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\"><strong>需要删除的软件完整名称</strong></span></span> <span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\"><strong>[--nodeps]</strong></span></span></p><p><span style=\"color:#FF0000;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\"><strong>#rpm -e httpd-2.2.15-39.el6.centos.i686 --nodeps</strong></span></span></p><p><img src=\"http://www.lixiaohui.com/resources/org/ueditor/themes/default/images/spacer.gif\" alt=\"graphic\" height=\"75\" width=\"690\"/></p><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\"><strong>①安装</strong></span></span></p><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">需要执行安装的脚本文件：</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">install_apache.sh</span></span></p><p><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">#./install_apache.sh</span></span></p><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">安装完成之后看到的界面：</span></span></p><p><img src=\"http://www.lixiaohui.com/resources/org/ueditor/themes/default/images/spacer.gif\" alt=\"graphic\" height=\"86\" width=\"692\"/></p><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\"><strong>②配置</strong></span></span></p><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">需要修改</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">apache</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">的配置文件</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">httpd.conf</span></span></p><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">位置：</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">/usr/local/http2/conf/httpd.conf</span></span></p><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">大概位置是</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">httpd.conf</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">的</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">148</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">行左右。需要去掉</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">ServerName</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">前面的注释符。</span></span></p><p><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\"><strong>#vim</strong></span> <span style=\"font-size:10pt; background:#ffff00\"><strong>+148</strong></span> <span style=\"font-size:10pt\"><strong>/usr/local/http2/conf/httpd.conf</strong></span></span></p><p><img src=\"http://www.lixiaohui.com/resources/org/ueditor/themes/default/images/spacer.gif\" alt=\"graphic\" height=\"85\" width=\"535\"/></p><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\"><strong>③关闭</strong></span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\"><strong>/</strong></span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\"><strong>卸载防火墙</strong></span></span></p><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">在学习环境下可以不用考虑防火墙，直接卸载防止影响后续的操作。</span></span></p><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">先关闭防火墙的服务：</span></span></p><p><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\"><strong>#service iptables stop</strong></span></span></p><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">通过查询的命令查询防火墙软件的完整名称，然后再删除防火墙：</span></span></p><p><img src=\"http://www.lixiaohui.com/resources/org/ueditor/themes/default/images/spacer.gif\" alt=\"graphic\" height=\"107\" width=\"688\"/></p><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\"><strong>注意：如果防火墙服务没有在停止之后直接删除的，则需要在删除完成之后重新启动下</strong></span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\"><strong>linux</strong></span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\"><strong>操作系统。</strong></span></span></p><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\"><strong>④启动</strong></span></span></p><p><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">Apache</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">安装完成之后其二进制文件名叫做：</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">apachectl</span></span></p><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">启动</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">/</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">关闭</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">/</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">重启：</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">apachectl start/stop/restart</span></span></p><p><span style=\"color:#FF0000;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\"><strong>#/usr/local/http2/bin/apachectl start</strong></span></span></p><p><img src=\"http://www.lixiaohui.com/resources/org/ueditor/themes/default/images/spacer.gif\" alt=\"graphic\" height=\"33\" width=\"691\"/></p><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\"><strong>⑤测试</strong></span></span></p><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\"><strong>测试方式</strong></span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\"><strong>1</strong></span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\"><strong>：可以通过查看进程的命令</strong></span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\"><strong>ps</strong></span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\"><strong>命令来测试</strong></span></span></p><p><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">#ps –A|grep httpd</span></span></p><p><img src=\"http://www.lixiaohui.com/resources/org/ueditor/themes/default/images/spacer.gif\" alt=\"graphic\" height=\"299\" width=\"644\"/></p><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\"><strong>测试方式</strong></span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\"><strong>2</strong></span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\"><strong>：通过浏览器访问</strong></span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\"><strong>ip</strong></span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\"><strong>地址来测试</strong></span></span></p><p><img src=\"http://www.lixiaohui.com/resources/org/ueditor/themes/default/images/spacer.gif\" alt=\"graphic\" height=\"140\" width=\"453\"/></p><h2><span style=\"color:#010101;font-family:���� Light;font-size:18px\"><span style=\"font-size:16pt\"><strong>4、安装php</strong></span></span></h2><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\"><strong>脚本文件名：</strong></span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\"><strong>install_php-apache.sh</strong></span></span></p><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\"><strong>①安装</strong></span></span></p><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">进入脚本目录</span></span></p><p><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">#cd /usr/local/src/tar</span></span></p><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">需要在目录执行</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">install_php-apache.sh</span></span></p><p><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">#./install_php-apache.sh</span></span></p><p><img src=\"http://www.lixiaohui.com/resources/org/ueditor/themes/default/images/spacer.gif\" alt=\"graphic\" height=\"47\" width=\"690\"/></p><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">安装完成看到的界面：</span></span></p><p><img src=\"http://www.lixiaohui.com/resources/org/ueditor/themes/default/images/spacer.gif\" alt=\"graphic\" height=\"73\" width=\"687\"/></p><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\"><strong>②配置</strong></span></span></p><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">第一步：产生</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">php</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">配置文件（</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">php.ini</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">）</span></span></p><p><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">#cp ./php-5.3.6/php.ini-development /usr/local/php/lib/php.ini</span></span></p><p><img src=\"http://www.lixiaohui.com/resources/org/ueditor/themes/default/images/spacer.gif\" alt=\"graphic\" height=\"56\" width=\"686\"/></p><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">第二步：修改</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">apache</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">配置文件</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">httpd.conf</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">，让其解析</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">php</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">文件（</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">AddType</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">）</span></span></p><p><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">#vim /usr/local/httpd/conf/httpd.conf</span></span></p><p><img src=\"http://www.lixiaohui.com/resources/org/ueditor/themes/default/images/spacer.gif\" alt=\"graphic\" height=\"121\" width=\"692\"/></p><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">代码：</span></span><span style=\"color:#FF0000;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\"><strong>AddType application/x-httpd-php .php</strong></span></span></p><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">第三步：给站点目录加上一个默认文档声明，让其自动去解析</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">index.php</span></span></p><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">配置项：</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\"><strong>DirectoryIndex</strong></span></span></p><p><img src=\"http://www.lixiaohui.com/resources/org/ueditor/themes/default/images/spacer.gif\" alt=\"graphic\" height=\"104\" width=\"656\"/></p><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\"><strong>③重启</strong></span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\"><strong>Apache</strong></span></span></p><p><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">#/usr/local/http2/bin/apachectl restart </span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">【如果重启一次不好用，可以重启</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">2</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">次】</span></span></p><p><img src=\"http://www.lixiaohui.com/resources/org/ueditor/themes/default/images/spacer.gif\" alt=\"graphic\" height=\"69\" width=\"687\"/></p><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\"><strong>④测试</strong></span></span></p><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">在</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">apache</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">的默认站点中放一个</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">php</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">文件，里面编写</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">php</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">代码即可：</span></span></p><p><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">Apache</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">的默认站点：</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">/usr/local/http2/htdocs</span></span></p><p><img src=\"http://www.lixiaohui.com/resources/org/ueditor/themes/default/images/spacer.gif\" alt=\"graphic\" height=\"141\" width=\"426\"/></p><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">通过</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">windows</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">的浏览器来输入地址</span></span><a href=\"http://192.168.64.142/php54.php\"><span style=\"color:#0563C1;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\"><span style=\"text-decoration:underline;\">http://192.168.64.142/php54.php</span></span></span></a></p><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\"><strong>⑤解决警告</strong></span></span></p><p><img src=\"http://www.lixiaohui.com/resources/org/ueditor/themes/default/images/spacer.gif\" alt=\"graphic\" height=\"133\" width=\"687\"/></p><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">设置时区需要去修改</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">php</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">的配置文件：</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">/usr/local/php/lib/php.ini</span></span></p><p><img src=\"http://www.lixiaohui.com/resources/org/ueditor/themes/default/images/spacer.gif\" alt=\"graphic\" height=\"164\" width=\"674\"/></p><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">重启</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">apache</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">：</span></span></p><p><img src=\"http://www.lixiaohui.com/resources/org/ueditor/themes/default/images/spacer.gif\" alt=\"graphic\" height=\"83\" width=\"688\"/></p><p><img src=\"http://www.lixiaohui.com/resources/org/ueditor/themes/default/images/spacer.gif\" alt=\"graphic\" height=\"112\" width=\"686\"/></p><h2><span style=\"color:#010101;font-family:���� Light;font-size:18px\"><span style=\"font-size:16pt\"><strong>5、安装mysql</strong></span></span></h2><p><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">Mysql</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">从</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">5.5</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">之后编译不再使用</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">gcc</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">进行编译，而是用</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">cmake</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">进行编译（</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">cmake</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">也是一款</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">c</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">语言编译器，和</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">gcc</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">类似），并且在安装</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">mysql</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">的时候要求</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">cmake</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">最低版本是</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">2.8</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">。</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">mysql</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">同时还需要</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">ncurses-devel</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">的支持。</span></span></p><p><img src=\"http://www.lixiaohui.com/resources/org/ueditor/themes/default/images/spacer.gif\" alt=\"graphic\" height=\"486\" width=\"692\"/></p><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\"><strong>脚本文件名：</strong></span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\"><strong>install_mysql.sh</strong></span></span></p><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\"><strong>①安装</strong></span></span></p><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">执行脚本文件</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">install_mysql.sh</span></span></p><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">完整的安装完成之后看到的界面：</span></span></p><p><img src=\"http://www.lixiaohui.com/resources/org/ueditor/themes/default/images/spacer.gif\" alt=\"graphic\" height=\"111\" width=\"692\"/></p><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\"><strong>②配置</strong></span></span></p><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">生成配置文件：</span></span></p><p><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">#cp /usr/local/src/tar/mysql-5.5.17/support-files/my-medium.cnf /etc/my.cnf</span></span></p><p><img src=\"http://www.lixiaohui.com/resources/org/ueditor/themes/default/images/spacer.gif\" alt=\"graphic\" height=\"66\" width=\"691\"/></p><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">创建</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">mysql</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">用户以及用户组：</span></span></p><p><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">#useradd mysql</span></span></p><p><img src=\"http://www.lixiaohui.com/resources/org/ueditor/themes/default/images/spacer.gif\" alt=\"graphic\" height=\"51\" width=\"691\"/></p><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">使用命令</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">#vim /etc/passwd</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">查看是否创建用户成功</span></span></p><p><img src=\"http://www.lixiaohui.com/resources/org/ueditor/themes/default/images/spacer.gif\" alt=\"graphic\" height=\"58\" width=\"685\"/></p><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">使用命令</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">#vim /etc/group</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">查看是否创建用户组成功</span></span></p><p><img src=\"http://www.lixiaohui.com/resources/org/ueditor/themes/default/images/spacer.gif\" alt=\"graphic\" height=\"63\" width=\"326\"/></p><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">赋予</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">mysql</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">目录可执行权限：</span></span></p><p><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">#chmod +x /usr/local/mysql</span></span></p><p><img src=\"http://www.lixiaohui.com/resources/org/ueditor/themes/default/images/spacer.gif\" alt=\"graphic\" height=\"38\" width=\"691\"/></p><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">数据库初始化（创建测试数据库等），</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">&</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">表示在后台运行：</span></span></p><p><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">#</span><span style=\"font-size:10pt\"><strong>/usr/local/mysql/scripts/mysql_install_db \\</strong></span></span></p><p><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\"><strong>--user=mysql \\</strong></span></span></p><p><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\"><strong>--basedir=/usr/local/mysql \\</strong></span></span></p><p><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\"><strong>--datadir=/usr/local/mysql/data &</strong></span></span></p><p><span style=\"color:#FF0000;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">执行成功之后得看到</span></span><span style=\"color:#FF0000;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">2</span></span><span style=\"color:#FF0000;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">个“</span></span><span style=\"color:#FF0000;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">OK</span></span><span style=\"color:#FF0000;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">”</span></span></p><p><img src=\"http://www.lixiaohui.com/resources/org/ueditor/themes/default/images/spacer.gif\" alt=\"graphic\" height=\"195\" width=\"684\"/></p><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">如果卡屏则按下回车即可。</span></span></p><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">把</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">mysql</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">安装文件</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">(</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">除了</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">data)</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">的所有者都改为</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">root</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">，避免数据库恢复为出厂设置：</span></span></p><p><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">#chown -R root /usr/local/mysql</span></span></p><p><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">#chown -R mysql /usr/local/mysql/data</span></span></p><p><img src=\"http://www.lixiaohui.com/resources/org/ueditor/themes/default/images/spacer.gif\" alt=\"graphic\" height=\"89\" width=\"654\"/></p><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">后台运行</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">mysql</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">服务（启动</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">mysql</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">）：</span></span></p><p><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\"><strong>#/usr/local/mysql/bin/mysqld_safe --user=mysql &</strong></span></span></p><p><img src=\"http://www.lixiaohui.com/resources/org/ueditor/themes/default/images/spacer.gif\" alt=\"graphic\" height=\"114\" width=\"689\"/></p><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">卡屏的时候按下回车</span></span></p><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">查看</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">mysql</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">是否有启动：</span></span></p><p><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">#ps -A|grep mysql </span></span></p><p><img src=\"http://www.lixiaohui.com/resources/org/ueditor/themes/default/images/spacer.gif\" alt=\"graphic\" height=\"110\" width=\"686\"/></p><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">如果看到有</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">2</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">个进程则说明</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">mysql</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">成功启动。</span></span></p><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">测试数据库：</span></span></p><p><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">#/usr/local/mysql/bin/mysql -u root</span></span></p><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">由于</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">mysql</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">在安装之后默认</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">root</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">用户是没有密码的，所以不需要加上“</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">-p</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">”参数：</span></span></p><p><img src=\"http://www.lixiaohui.com/resources/org/ueditor/themes/default/images/spacer.gif\" alt=\"graphic\" height=\"245\" width=\"686\"/></p><p><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">mysql>show databases; </span></span></p><p><img src=\"http://www.lixiaohui.com/resources/org/ueditor/themes/default/images/spacer.gif\" alt=\"graphic\" height=\"288\" width=\"557\"/></p><p><span style=\"color:#FF0000;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\"><strong>建设性操作，为了安全：</strong></span></span></p><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">删除匿名用户：</span></span></p><p><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">mysql>delete from mysql.user where User='';</span></span></p><p><img src=\"http://www.lixiaohui.com/resources/org/ueditor/themes/default/images/spacer.gif\" alt=\"graphic\" height=\"74\" width=\"688\"/></p><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">接上步，修改</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">mysql</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">密码</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">(</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">可不做此步，默认无密码</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">)</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">：</span></span></p><p><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">mysql>UPDATE mysql.user SET Password=password('123456') WHERE user='root';</span></span></p><p><img src=\"http://www.lixiaohui.com/resources/org/ueditor/themes/default/images/spacer.gif\" alt=\"graphic\" height=\"64\" width=\"690\"/></p><p><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">mysql>flush privileges;</span></span></p><p><img src=\"http://www.lixiaohui.com/resources/org/ueditor/themes/default/images/spacer.gif\" alt=\"graphic\" height=\"70\" width=\"597\"/></p><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\"><strong>③测试</strong></span></span></p><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">测试语句：</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">mysql>select version();</span></span></p><p><img src=\"http://www.lixiaohui.com/resources/org/ueditor/themes/default/images/spacer.gif\" alt=\"graphic\" height=\"196\" width=\"630\"/></p><h1><span style=\"color:#010101;font-family:宋体;font-size:24px\"><span style=\"font-size:22pt\"><strong>三、</strong></span></span><span style=\"color:#010101;font-family:Calibri;font-size:24px\"><span style=\"font-size:22pt\"><strong>lnmp</strong></span></span><span style=\"color:#010101;font-family:宋体;font-size:24px\"><span style=\"font-size:22pt\"><strong>环境安装</strong></span></span><span style=\"color:#010101;font-family:Calibri;font-size:24px\"><span style=\"font-size:22pt\"><strong> </strong></span></span></h1><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">在开发的时候常见的架构：</span></span></p><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">①</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">LAMP</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">：</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">linux + apache + mysql/mariadb + php</span></span></p><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">②</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">LNMP</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">：</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">linux + nginx + mysql/maridb + php-fpm</span></span></p><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt; background:#ffff00\"><strong>面试题：</strong></span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt; background:#ffff00\"><strong>lamp</strong></span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt; background:#ffff00\"><strong>和</strong></span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt; background:#ffff00\"><strong>lnmp</strong></span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt; background:#ffff00\"><strong>有什么区别？</strong></span></span></p><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">答：①底层架构上是不一样，在性能上</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">apche</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">不如</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">nginx</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">效果好，</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">nginx</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">处理静态页效率非常高，</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">apache</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">处理动态页面效果稍微好点；在安全性上，</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">apache</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">要比</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">nginx</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">稍微好点；</span></span></p><p><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\"> </span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">②两个架构的</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">php</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">运行方式不一样。在</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">lamp</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">下，这个架构</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">php</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">都是以</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">php5</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">模块的方式进行运行的（由于是</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">apache</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">载入的</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">php</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">模块，所以每次修改</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">php</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">配置文件之后都需要去重启</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">apache</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">）；</span></span><span style=\"color:#FF0000;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\"><strong>而在</strong></span></span><span style=\"color:#FF0000;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\"><strong>lnmp</strong></span></span><span style=\"color:#FF0000;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\"><strong>下其</strong></span></span><span style=\"color:#FF0000;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\"><strong>php</strong></span></span><span style=\"color:#FF0000;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\"><strong>的运行方式是使用的</strong></span></span><span style=\"color:#FF0000;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\"><strong>fastCGI</strong></span></span><span style=\"color:#FF0000;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\"><strong>模式，而这个模式是让</strong></span></span><span style=\"color:#FF0000;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\"><strong>php</strong></span></span><span style=\"color:#FF0000;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\"><strong>（特指</strong></span></span><span style=\"color:#FF0000;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\"><strong>php-fpm</strong></span></span><span style=\"color:#FF0000;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\"><strong>）以单独的进程去运行的，如果有</strong></span></span><span style=\"color:#FF0000;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\"><strong>php</strong></span></span><span style=\"color:#FF0000;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\"><strong>请求，则</strong></span></span><span style=\"color:#FF0000;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\"><strong>nginx</strong></span></span><span style=\"color:#FF0000;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\"><strong>将请求转发给</strong></span></span><span style=\"color:#FF0000;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\"><strong>php-fpm</strong></span></span><span style=\"color:#FF0000;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\"><strong>处理（有单独的端口，默认是</strong></span></span><span style=\"color:#FF0000;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\"><strong>9000</strong></span></span><span style=\"color:#FF0000;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\"><strong>），所以在</strong></span></span><span style=\"color:#FF0000;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\"><strong>lnmp</strong></span></span><span style=\"color:#FF0000;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\"><strong>下，如果</strong></span></span><span style=\"color:#FF0000;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\"><strong>php</strong></span></span><span style=\"color:#FF0000;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\"><strong>配置文件发生修改，则不需要重启</strong></span></span><span style=\"color:#FF0000;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\"><strong>nginx</strong></span></span><span style=\"color:#FF0000;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\"><strong>，直接重启</strong></span></span><span style=\"color:#FF0000;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\"><strong>php</strong></span></span><span style=\"color:#FF0000;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\"><strong>即可</strong></span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">。</span></span></p><p><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\"> </span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">具体的两种运行方式的差异，可以参考资料“</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">PHP</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">的几种常见的运行模式</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">.png</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">”。</span></span></p><h2><span style=\"color:#010101;font-family:���� Light;font-size:18px\"><span style=\"font-size:16pt\"><strong>1、准备工作</strong></span></span></h2><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">克隆新的主机，这个时候</span></span><span style=\"color:#FF0000;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\"><strong>复制克隆的是刚才的</strong></span></span><span style=\"color:#FF0000;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\"><strong>lamp</strong></span></span><span style=\"color:#FF0000;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\"><strong>环境的服务器</strong></span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">。</span></span></p><p><img src=\"http://www.lixiaohui.com/resources/org/ueditor/themes/default/images/spacer.gif\" alt=\"graphic\" height=\"206\" width=\"610\"/></p><h3><span style=\"color:#010101;font-family:Calibri;font-size:18px\"><span style=\"font-size:16pt\"><strong>1.1</strong></span></span><span style=\"color:#010101;font-family:宋体;font-size:18px\"><span style=\"font-size:16pt\"><strong>、介绍</strong></span></span></h3><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">服务器组合</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">1</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">：</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">lamp</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">：</span></span></p><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">服务器组合</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">2</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">：</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">lnmp</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">：</span></span></p><h3><span style=\"color:#010101;font-family:Calibri;font-size:18px\"><span style=\"font-size:16pt\"><strong>1.2</strong></span></span><span style=\"color:#010101;font-family:宋体;font-size:18px\"><span style=\"font-size:16pt\"><strong>、系统克隆备份</strong></span></span></h3><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">克隆的是</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">lamp</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">环境主机（得先关闭虚拟机），克隆完成之后再获取新的主机的</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">ip</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">地址使用</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">putty</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">连接：</span></span></p><p><img src=\"http://www.lixiaohui.com/resources/org/ueditor/themes/default/images/spacer.gif\" alt=\"graphic\" height=\"148\" width=\"604\"/></p><h2><span style=\"color:#010101;font-family:���� Light;font-size:18px\"><span style=\"font-size:16pt\"><strong>2、安装nginx</strong></span></span></h2><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">脚本文件名：</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">install_nginx.sh</span></span></p><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\"><strong>①安装</strong></span></span></p><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">执行目录切换，将当前工作目录切换到软件包的目录：</span></span></p><p><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">#cd /usr/local/src/tar</span></span></p><p><img src=\"http://www.lixiaohui.com/resources/org/ueditor/themes/default/images/spacer.gif\" alt=\"graphic\" height=\"84\" width=\"686\"/></p><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">执行脚本文件：</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">install_nginx.sh</span></span></p><p><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">#./install_nginx.sh</span></span></p><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">执行完成之后的界面：</span></span></p><p><img src=\"http://www.lixiaohui.com/resources/org/ueditor/themes/default/images/spacer.gif\" alt=\"graphic\" height=\"81\" width=\"690\"/></p><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\"><strong>②软件目录介绍</strong></span></span></p><p><img src=\"http://www.lixiaohui.com/resources/org/ueditor/themes/default/images/spacer.gif\" alt=\"graphic\" height=\"72\" width=\"686\"/></p><p><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">Conf</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">目录：配置文件存放目录，</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">nginx</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">主配置文件名叫做</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">nginx.conf</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">；</span></span></p><p><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">Html</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">目录：</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">nginx</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">默认站点目录，和</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">apache</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">的</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">htdocs</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">目录一样的作用；</span></span></p><p><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">Logs</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">目录：是</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">nginx</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">运行时候的日志文件存放目录；</span></span></p><p><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">Sbin</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">目录：是</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">nginx</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">的二进制文件存放目录，相当于</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">apache</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">的</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">bin</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">目录；</span></span></p><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\"><strong>③配置</strong></span></span></p><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">目前不需要配置</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">nginx</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">，后续需要配置的时候再配置</span></span></p><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">配置文件</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">nginx.conf</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">，</span></span><span style=\"color:#FF0000;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\"><strong>位置：</strong></span></span><span style=\"color:#FF0000;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\"><strong>/usr/local/nginx/conf/nginx.conf</strong></span></span></p><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\"><strong>④启动</strong></span></span></p><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">二进制文件位置：</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">/usr/local/nginx/sbin/nginx</span></span></p><p><span style=\"color:#FF0000;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\"><strong>注意：</strong></span></span><span style=\"color:#FF0000;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\"><strong>nginx</strong></span></span><span style=\"color:#FF0000;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\"><strong>不像</strong></span></span><span style=\"color:#FF0000;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\"><strong>apache</strong></span></span><span style=\"color:#FF0000;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\"><strong>一样，</strong></span></span><span style=\"color:#FF0000;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\"><strong>nginx</strong></span></span><span style=\"color:#FF0000;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\"><strong>没有像</strong></span></span><span style=\"color:#FF0000;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\"><strong>apache</strong></span></span><span style=\"color:#FF0000;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\"><strong>的</strong></span></span><span style=\"color:#FF0000;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\"><strong>start/stop/restart</strong></span></span><span style=\"color:#FF0000;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\"><strong>这个参数的支持。</strong></span></span></p><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">启动可以直接输入二进制的文件路径即可（直接运行二进制文件）。</span></span></p><p><span style=\"color:#FF0000;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\"><strong>注意：运行</strong></span></span><span style=\"color:#FF0000;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\"><strong>nginx</strong></span></span><span style=\"color:#FF0000;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\"><strong>的时候得保证之前的</strong></span></span><span style=\"color:#FF0000;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\"><strong>apache</strong></span></span><span style=\"color:#FF0000;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\"><strong>没有被运行</strong></span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">。</span></span></p><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\"><strong>④测试</strong></span></span></p><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">通过在客户机（</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">windows</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">）输入</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">linux</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">的</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">ip</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">地址来进行测试：</span></span></p><p><img src=\"http://www.lixiaohui.com/resources/org/ueditor/themes/default/images/spacer.gif\" alt=\"graphic\" height=\"204\" width=\"687\"/></p><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">还可以通过</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">header</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">头来查看：</span></span></p><p><img src=\"http://www.lixiaohui.com/resources/org/ueditor/themes/default/images/spacer.gif\" alt=\"graphic\" height=\"181\" width=\"615\"/></p><h2><span style=\"color:#010101;font-family:���� Light;font-size:18px\"><span style=\"font-size:16pt\"><strong>3、安装php-fpm</strong></span></span></h2><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">脚本文件名：</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">install_php-nginx.sh</span></span></p><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\"><strong>①卸载之前安装的</strong></span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\"><strong>php</strong></span></span></p><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">由于</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">php</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">目前由于是编译安装，所以其其实相当于是</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">windows</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">下的“绿色软件”。可以直接删除其安装的目录即可。</span></span></p><p><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">PHP</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">的安装目录：</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">/ usr/local/php</span></span></p><p><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\"><strong>#rm -rf /usr/local/php</strong></span></span></p><p><img src=\"http://www.lixiaohui.com/resources/org/ueditor/themes/default/images/spacer.gif\" alt=\"graphic\" height=\"58\" width=\"687\"/></p><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\"><strong>②安装</strong></span></span></p><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">在脚本目录去执行脚本文件</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">install_php-nginx.sh</span></span></p><p><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">#./install_php-nginx.sh</span></span></p><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">执行结束之后看到的界面：</span></span></p><p><img src=\"http://www.lixiaohui.com/resources/org/ueditor/themes/default/images/spacer.gif\" alt=\"graphic\" height=\"79\" width=\"693\"/></p><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\"><strong>③目录结构</strong></span></span></p><p><img src=\"http://www.lixiaohui.com/resources/org/ueditor/themes/default/images/spacer.gif\" alt=\"graphic\" height=\"91\" width=\"634\"/></p><p><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">Bin</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">目录：二进制文件目录；</span></span></p><p><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">Ect</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">目录：配置文件目录；</span></span></p><p><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">Include</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">目录：包含文件目录，在后期制作第三方扩展的时候生成保存的目录；</span></span></p><p><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">Lib</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">目录：</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">php</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">自身的扩展目录；</span></span></p><p><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">Man</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">目录：</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">manual</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">，说明手册目录；</span></span></p><p><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">Sbin</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">目录：</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">super bin</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">目录，超级二进制文件目录；</span></span></p><p><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">Var</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">目录：日志存放目录；</span></span></p><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\"><strong>③生成配置文件</strong></span></span></p><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">复制生成配置</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">php</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">文件：</span></span></p><p><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">#cp /usr/local/src/tar/php-5.3.6/php.ini-development /usr/local/php/etc/php.ini</span></span></p><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">复制生成</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">php-fpm</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">配置文件：</span></span></p><p><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">#cp /usr/local/php/etc/php-fpm.conf.default /usr/local/php/etc/php-fpm.conf</span></span></p><p><img src=\"http://www.lixiaohui.com/resources/org/ueditor/themes/default/images/spacer.gif\" alt=\"graphic\" height=\"128\" width=\"691\"/></p><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\"><strong>④启动</strong></span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\"><strong>php-fpm</strong></span></span></p><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">其启动方式和</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">nginx</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">一样，没有</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">start/stop/restart</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">选项。【在</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">php5.2</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">之前是有，但是从</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">5.2</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">开始就没有了】</span></span></p><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">直接运行</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">php-fpm</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">文件即可启动。</span></span></p><p><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\"><strong>#/usr/local/php/sbin/php-fpm</strong></span></span></p><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">在启动的时候遇到错误：</span></span></p><p><img src=\"http://www.lixiaohui.com/resources/org/ueditor/themes/default/images/spacer.gif\" alt=\"graphic\" height=\"93\" width=\"683\"/></p><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">去修改</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">php-fpm</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">的配置：</span></span></p><p><img src=\"http://www.lixiaohui.com/resources/org/ueditor/themes/default/images/spacer.gif\" alt=\"graphic\" height=\"489\" width=\"685\"/></p><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">需要在</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">php-fpm</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">配置文件中将上述几个红色框中的配置的注释符给去掉。保存退出，再次启动</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">php-fpm</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">。</span></span></p><p><img src=\"http://www.lixiaohui.com/resources/org/ueditor/themes/default/images/spacer.gif\" alt=\"graphic\" height=\"79\" width=\"692\"/></p><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">通过</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">ps</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">命令来检测</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">php-fpm</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">是否启动成功：</span></span></p><p><img src=\"http://www.lixiaohui.com/resources/org/ueditor/themes/default/images/spacer.gif\" alt=\"graphic\" height=\"189\" width=\"689\"/></p><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\"><strong>⑤修改</strong></span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\"><strong>nginx</strong></span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\"><strong>配置文件，使</strong></span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\"><strong>nginx</strong></span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\"><strong>与</strong></span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\"><strong>php</strong></span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\"><strong>建立联系</strong></span></span></p><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">打开</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">nginx</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">的配置文件，将下面的配置代码放到</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">nginx</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">的配置文件中。配置的时候可以通过</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">sublime</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">来打开，需要借助于</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">filezilla</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">：</span></span></p><p><img src=\"http://www.lixiaohui.com/resources/org/ueditor/themes/default/images/spacer.gif\" alt=\"graphic\" height=\"402\" width=\"464\"/></p><p><img src=\"http://www.lixiaohui.com/resources/org/ueditor/themes/default/images/spacer.gif\" alt=\"graphic\" height=\"309\" width=\"684\"/></p><p><img src=\"http://www.lixiaohui.com/resources/org/ueditor/themes/default/images/spacer.gif\" alt=\"graphic\" height=\"420\" width=\"692\"/></p><p><img src=\"http://www.lixiaohui.com/resources/org/ueditor/themes/default/images/spacer.gif\" alt=\"graphic\" height=\"103\" width=\"684\"/></p><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">相关配置：</span></span></p><p><span style=\"color:#2E74B5;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">location ~ .+\\.php($|/) {</span></span></p><p><span style=\"color:#2E74B5;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\"> set $script $uri;</span></span></p><p><span style=\"color:#2E74B5;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\"> set $path_info "/";</span></span></p><p><span style=\"color:#2E74B5;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\"> if ($uri ~ "^(.+\\.php)(/.+)") {</span></span></p><p><span style=\"color:#2E74B5;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\"> set $script $1;</span></span></p><p><span style=\"color:#2E74B5;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\"> set $path_info $2;</span></span></p><p><span style=\"color:#2E74B5;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\"> }</span></span></p><p><span style=\"color:#2E74B5;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\"> fastcgi_pass 127.0.0.1:9000;</span></span></p><p><span style=\"color:#2E74B5;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\"> </span></span> <span style=\"color:#FF0000;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">fastcgi_index index.php?IF_REWRITE=1;</span></span></p><p><span style=\"color:#2E74B5;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\"> include fastcgi.conf;</span></span></p><p><span style=\"color:#2E74B5;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\"> fastcgi_param PATH_INFO $path_info;</span></span></p><p><span style=\"color:#2E74B5;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\"> fastcgi_param SCRIPT_FILENAME $document_root/$script;</span></span></p><p><span style=\"color:#2E74B5;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\"> fastcgi_param SCRIPT_NAME $script;</span></span></p><p><span style=\"color:#2E74B5;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">}</span></span></p><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">由于</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">nginx</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">本身对</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">pathinfo</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">形式支持不是很好，所以如果要求</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">nginx</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">能够运行</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">ThinkPHP</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">的话，则必须要加上红色行代码。</span></span></p><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">将上述的配置复制到</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">nginx.conf</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">中，放到第一个</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">server</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">段中与其他</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">location</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">配置段平级：</span></span></p><p><img src=\"http://www.lixiaohui.com/resources/org/ueditor/themes/default/images/spacer.gif\" alt=\"graphic\" height=\"413\" width=\"689\"/></p><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">修改文件之后保存，然后</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">filezilla</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">提示文件修改是否上传回服务器，点是：</span></span></p><p><img src=\"http://www.lixiaohui.com/resources/org/ueditor/themes/default/images/spacer.gif\" alt=\"graphic\" height=\"350\" width=\"619\"/></p><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\"><strong>⑥重启</strong></span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\"><strong>nginx</strong></span></span></p><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">由于</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">nginx</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">没有</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">restart</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">的命令，重启方式有</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">2</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">种：</span></span></p><p><span style=\"color:#FF0000;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\"><strong>方式</strong></span></span><span style=\"color:#FF0000;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\"><strong>1</strong></span></span><span style=\"color:#FF0000;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\"><strong>：</strong></span></span><span style=\"color:#FF0000;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\"><strong>#/usr/local/nginx/sbin/nginx -s reload</strong></span><span style=\"font-size:10pt\"> </span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\"> //</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">重新加载配置文件，并不是重启</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">nginx</span></span></p><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\"><strong>方式</strong></span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\"><strong>2</strong></span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\"><strong>：简单粗暴，先将</strong></span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\"><strong>nginx</strong></span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\"><strong>杀死，然后再启动。</strong></span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\"><strong>#killall nginx</strong></span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\"><strong>。</strong></span></span></p><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">一般会优先选择方式</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">1</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">。</span></span></p><p><img src=\"http://www.lixiaohui.com/resources/org/ueditor/themes/default/images/spacer.gif\" alt=\"graphic\" height=\"46\" width=\"692\"/></p><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\"><strong>⑦测试</strong></span></span></p><p><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">通过</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">php</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">文件来测试，在</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">nginx</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">的默认站点目录下创建</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">php</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">文件，编写</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">php</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">代码，通过</span></span><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\">windows</span></span><span style=\"color:#010101;font-family:宋体;font-size:12px\"><span style=\"font-size:10pt\">下的浏览器来测试访问：</span></span></p><p><span style=\"color:#010101;font-family:Calibri;font-size:12px\"><span style=\"font-size:10pt\"><strong>#vim /usr/local/nginx/html/php54.php</strong></span></span></p><p><img src=\"http://www.lixiaohui.com/resources/org/ueditor/themes/default/images/spacer.gif\" alt=\"graphic\" height=\"89\" width=\"301\"/></p><p><img src=\"http://www.lixiaohui.com/resources/org/ueditor/themes/default/images/spacer.gif\" alt=\"graphic\" height=\"294\" width=\"685\"/></p><p><span style=\"font-size: 26px;\"><strong><br/></strong></span></p><p><br/></p>','29');
INSERT INTO `blog_article` VALUES('16','NoSQL类的缓存','NoSQL类的缓存','NoSQL类的缓存NoSQL类的缓存','49','2017-07-14 16:07:03','uploads/20170714160659142.jpg','213123','','30');
INSERT INTO `blog_article` VALUES('17','34567','23456789','345678','75','2017-07-14 23:32:11','uploads/20170714233204222.jpg','问4','<p>威尔与</p>','38');
--
-- 表的结构blog_cate
--
DROP TABLE IF EXISTS `blog_cate`;
CREATE TABLE `blog_cate` (
`cate_id` int(11) NOT NULL AUTO_INCREMENT,
`cate_name` varchar(50) NOT NULL DEFAULT '',
`cate_title` varchar(255) DEFAULT NULL,
`cate_keywords` varchar(255) DEFAULT '',
`cate_discription` varchar(255) DEFAULT '',
`cate_image` varchar(255) DEFAULT '',
`cate_view` int(10) DEFAULT '0',
`cate_order` int(10) DEFAULT NULL,
`cate_pid` int(11) DEFAULT '0',
PRIMARY KEY (`cate_id`)
) ENGINE=MyISAM AUTO_INCREMENT=40 DEFAULT CHARSET=utf8;
--
-- 转存表中的数据 blog_cate
--
INSERT INTO `blog_cate` VALUES('26','PHP','PHP是世界上最好的语言','','','/uploads/cate/cate_20170713152720_5440.jpg','0','1','0');
INSERT INTO `blog_cate` VALUES('27','体育','体育体育体育体育','体育体育体育','体育体育','','0','2','0');
INSERT INTO `blog_cate` VALUES('28','娱乐','娱乐娱乐娱乐','','','','0','3','0');
INSERT INTO `blog_cate` VALUES('29','MYSQL','世界上免费的关系数据库','111','111','/uploads/cate/cate_20170713153416_5866.jpg','0','2','26');
INSERT INTO `blog_cate` VALUES('30','Memcache','非关系行数据库','','','/uploads/cate/cate_20170713153524_6289.jpg','0','1','26');
INSERT INTO `blog_cate` VALUES('31','Linux','世界上免费的服务器系统，稳定好用','2','','/uploads/cate/cate_20170713153623_3807.jpg','0','3','26');
INSERT INTO `blog_cate` VALUES('32','ThinkPHP','国产免费的优秀框架','','','/uploads/cate/cate_20170713153700_5726.jpg','0','4','26');
INSERT INTO `blog_cate` VALUES('36','曹雨薇','123','123','','','0','1','0');
INSERT INTO `blog_cate` VALUES('38','数学','数学数学数学','数学数学数学','数学数学','/uploads/cate/cate_20170714233113_3536.jpg','0','1','36');
INSERT INTO `blog_cate` VALUES('35','543','4444','444','44','/uploads/cate/cate_20170713185802_5673.jpg','0','1','27');
INSERT INTO `blog_cate` VALUES('39','123','134567','26787654','456765','','0','1','0');
--
-- 表的结构blog_comment
--
DROP TABLE IF EXISTS `blog_comment`;
CREATE TABLE `blog_comment` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`art_id` int(11) DEFAULT NULL COMMENT '评论文章id',
`user_id` int(11) DEFAULT NULL,
`comment_date` datetime DEFAULT NULL,
`comment` varchar(255) DEFAULT NULL,
`com_show` int(1) DEFAULT '1',
`com_ip` char(15) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8;
--
-- 转存表中的数据 blog_comment
--
INSERT INTO `blog_comment` VALUES('1','17','1','2017-09-28 00:29:06','好棒','1','::1');
INSERT INTO `blog_comment` VALUES('2','17','1','2017-09-28 00:31:26','不错','1','::1');
INSERT INTO `blog_comment` VALUES('3','17','1','2017-09-28 00:31:48','还行','1','::1');
INSERT INTO `blog_comment` VALUES('4','17','1','2017-09-28 00:33:21','这个我喜欢','1','::1');
INSERT INTO `blog_comment` VALUES('5','16','1','2017-09-28 00:34:02','这个还是不错的','1','::1');
INSERT INTO `blog_comment` VALUES('6','16','1','2017-09-28 00:54:01','这是啥玩意','1','::1');
INSERT INTO `blog_comment` VALUES('7','13','1','2017-09-28 01:06:03','不错的','1','::1');
INSERT INTO `blog_comment` VALUES('8','16','1','2017-09-29 01:27:10','好好好','1','::1');
INSERT INTO `blog_comment` VALUES('9','16','1','2017-09-29 01:27:18','我真的很喜欢','1','::1');
INSERT INTO `blog_comment` VALUES('10','16','1','2017-09-29 01:27:31','这个真不错的','1','::1');
INSERT INTO `blog_comment` VALUES('11','16','1','2017-09-29 01:27:36','哈哈哈哈哈','1','::1');
INSERT INTO `blog_comment` VALUES('12','17','1','2017-09-30 02:00:38','***','1','::1');
INSERT INTO `blog_comment` VALUES('13','17','1','2017-09-30 02:09:26','我是你妈逼的打的费','1','::1');
INSERT INTO `blog_comment` VALUES('14','17','1','2017-09-30 02:13:32','我是你妈逼的打的费','1','::1');
INSERT INTO `blog_comment` VALUES('15','17','1','2017-09-30 02:14:23','我是你妈逼的打的费','1','::1');
INSERT INTO `blog_comment` VALUES('16','17','1','2017-09-30 02:15:48','我是你妈逼的打的费','1','::1');
INSERT INTO `blog_comment` VALUES('17','17','1','2017-09-30 02:42:28','***的，您个啥比 我***的 你就是','1','::1');
INSERT INTO `blog_comment` VALUES('18','17','1','2017-10-11 19:09:27','***','1','127.0.0.1');
INSERT INTO `blog_comment` VALUES('19','17','1','2017-10-11 19:09:46','***你是但hi***s大地方','1','127.0.0.1');
INSERT INTO `blog_comment` VALUES('20','16','1','2017-10-11 19:10:37','***','1','127.0.0.1');
INSERT INTO `blog_comment` VALUES('21','16','1','2017-10-11 19:10:47','傻逼','1','127.0.0.1');
INSERT INTO `blog_comment` VALUES('22','17','1','2017-10-20 23:32:34','***是曹雨薇','1','127.0.0.1');
INSERT INTO `blog_comment` VALUES('23','17','1','2017-10-20 23:33:13','习近 平','1','127.0.0.1');
INSERT INTO `blog_comment` VALUES('24','17','1','2017-10-20 23:33:27','***','1','127.0.0.1');
--
-- 表的结构blog_contact
--
DROP TABLE IF EXISTS `blog_contact`;
CREATE TABLE `blog_contact` (
`con_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`con_name` varchar(50) DEFAULT NULL,
`con_email` varchar(50) DEFAULT NULL,
`con_tel` char(15) DEFAULT NULL,
`con_content` text,
`con_time` datetime DEFAULT NULL,
`con_ip` varchar(20) DEFAULT NULL,
`con_read` tinyint(1) DEFAULT '0',
PRIMARY KEY (`con_id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;
--
-- 转存表中的数据 blog_contact
--
INSERT INTO `blog_contact` VALUES('1','nishi','[email protected]','123456','asdfasdfasdfasdf','2017-09-16 20:51:07','::1','0');
INSERT INTO `blog_contact` VALUES('2','nishi','[email protected]','123456','asdfasdfasdfasdffdniasdf','2017-09-16 21:07:51','::1','1');
INSERT INTO `blog_contact` VALUES('3','zhangsan','[email protected]','18656666643','飞哥是个打几把','2017-09-16 21:08:33','::1','1');
INSERT INTO `blog_contact` VALUES('4','3333','[email protected]','1232341234','1341234214','2017-09-16 21:14:05','1223','1');
INSERT INTO `blog_contact` VALUES('5','3333','[email protected]','1232341234','1341234214','2017-09-16 22:05:24','::1','1');
INSERT INTO `blog_contact` VALUES('6','3333','[email protected]','1232341234','1341234214','2017-09-16 22:05:24','::1','0');
INSERT INTO `blog_contact` VALUES('7','李晓辉','[email protected]','18677777765','这个代码还是不错的的的点点滴滴多多多多多多多多多多多多多多的 这个代码还是不错的的的点点滴滴多','2017-09-17 22:25:11','::1','1');
INSERT INTO `blog_contact` VALUES('8','123123','[email protected]','我去二群翁','去玩儿请问','2017-09-17 22:25:39','::1','1');
INSERT INTO `blog_contact` VALUES('9','李晓辉','[email protected]','18656666643','我觉得这个博客真不怎么样。。。。。哈哈','2017-09-20 14:50:07','127.0.0.1','0');
INSERT INTO `blog_contact` VALUES('10','孟非','[email protected]','130766678998','您好,如果您对我们的博客有什么建议或者意见 , 还是您想让我更新什么内容 , 请您提出宝贵建议!您好,如果您对我们的博客有什么建议或者意见 , 还是您想让我更新什么内容 , 请您提出宝贵建议!您好,如果您对我们的博客有什么建议或者意见 , 还是您想让我更新什么内容 , 请您提出宝贵建议!您好,如果您对我们的博客有什么建议或者意见 , 还是您想让我更新什么内容 , 请您提出宝贵建议!','2017-09-20 23:58:07','::1','1');
--
-- 表的结构blog_keywords
--
DROP TABLE IF EXISTS `blog_keywords`;
CREATE TABLE `blog_keywords` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`keywords` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
--
-- 转存表中的数据 blog_keywords
--
INSERT INTO `blog_keywords` VALUES('1','.你妈逼.操你妈.老傻子.习近平');
--
-- 表的结构blog_stu_class
--
DROP TABLE IF EXISTS `blog_stu_class`;
CREATE TABLE `blog_stu_class` (
`class_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '分类id',
`class_name` varchar(20) DEFAULT NULL COMMENT '分类名称',
`add_user` varchar(20) DEFAULT NULL COMMENT '添加人',
`add_time` datetime DEFAULT NULL COMMENT '添加时间',
`show` int(1) DEFAULT '0' COMMENT '是否添加过',
PRIMARY KEY (`class_id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8;
--
-- 转存表中的数据 blog_stu_class
--
INSERT INTO `blog_stu_class` VALUES('1','PHP59期','李晓辉','2017-10-10 23:12:38','1');
INSERT INTO `blog_stu_class` VALUES('2','全栈2期','李晓辉','2017-10-11 00:58:40','1');
INSERT INTO `blog_stu_class` VALUES('3','黑马4期','李晓辉','2017-10-11 14:54:35','0');
INSERT INTO `blog_stu_class` VALUES('4','黑马5期','李晓辉','2017-10-11 14:54:40','0');
INSERT INTO `blog_stu_class` VALUES('5','黑马6期','李晓辉','2017-10-11 14:54:43','0');
INSERT INTO `blog_stu_class` VALUES('6','黑马7期','李晓辉','2017-10-11 14:54:47','0');
INSERT INTO `blog_stu_class` VALUES('7','黑马8期','李晓辉','2017-10-11 14:54:50','0');
INSERT INTO `blog_stu_class` VALUES('8','php传智61期','李晓辉','2017-10-11 14:55:06','0');
INSERT INTO `blog_stu_class` VALUES('9','php传智62期','李晓辉','2017-10-11 14:55:11','0');
INSERT INTO `blog_stu_class` VALUES('10','php传智63期','李晓辉','2017-10-11 14:55:14','0');
INSERT INTO `blog_stu_class` VALUES('11','php88期','李晓辉','2017-10-18 16:57:40','1');
--
-- 表的结构blog_stu_entry
--
DROP TABLE IF EXISTS `blog_stu_entry`;
CREATE TABLE `blog_stu_entry` (
`en_id` int(11) NOT NULL AUTO_INCREMENT,
`stu_id` int(11) DEFAULT NULL,
`record_user` varchar(10) DEFAULT NULL COMMENT '填写人',
`offer` int(3) DEFAULT NULL COMMENT '共几个offer',
`interview` int(3) DEFAULT NULL COMMENT '面试数量',
`company` varchar(50) DEFAULT NULL COMMENT '入职公司',
`en_time` date DEFAULT NULL COMMENT '入职日期',
`pay` int(6) DEFAULT NULL COMMENT '薪资',
`boon` varchar(20) DEFAULT NULL COMMENT '几险几金待遇',
`city` varchar(10) DEFAULT NULL COMMENT '就业城市',
`add_time` date DEFAULT NULL COMMENT '填写时间',
PRIMARY KEY (`en_id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;
--
-- 转存表中的数据 blog_stu_entry
--
INSERT INTO `blog_stu_entry` VALUES('1','896556','李晓辉','1','12','北京百度有限公司','2017-10-19','10000','五险一金','北京','2017-10-18');
INSERT INTO `blog_stu_entry` VALUES('2','893426','李晓辉','1','11','电商北京有限公司','2017-10-19','11000','五险一金','上海','2017-10-18');
INSERT INTO `blog_stu_entry` VALUES('3','894691','李晓辉','1','23','上门帮电子商务（北京）有限公司','2017-10-29','11000','五险','北京','2017-10-18');
INSERT INTO `blog_stu_entry` VALUES('4','880332','李晓辉','1','12','众享在线北京网络科技有限公司','2017-10-28','20000','五险一金','北京','2017-10-18');
INSERT INTO `blog_stu_entry` VALUES('5','892825','李晓辉','1','12','上门帮电子商务北京有限公司','2017-10-12','10000','五险一金','北京','2017-10-18');
--
-- 表的结构blog_stu_group
--
DROP TABLE IF EXISTS `blog_stu_group`;
CREATE TABLE `blog_stu_group` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user_id` int(11) DEFAULT NULL COMMENT '用户的id',
`stu_ids` varchar(1000) DEFAULT '' COMMENT '用户下的所有id',
`class_id` int(20) DEFAULT NULL COMMENT '分类的id',
`show` int(1) DEFAULT '0' COMMENT '是否显示',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;
--
-- 转存表中的数据 blog_stu_group
--
INSERT INTO `blog_stu_group` VALUES('1','1',',833278,864067,866663,880332,886069,886512,886795,887478,888378,888567,889311,889940,891251,891598,892052,892341,892361,892546,892825,893231,893426,893553,893578,893730,894081,894354,894356,894507,894570,894599,894665,894687,894688,894691,894693,894694,894708,894711,894719,894788,894983,895391,895417,895499,895566,895792,896079,896556,896838','1','0');
INSERT INTO `blog_stu_group` VALUES('2','2',',19196,884550,890347,896984,897055,899740','1','0');
INSERT INTO `blog_stu_group` VALUES('4','1',',100001,100002,100003,100004,100005,100006,100010,100011,100012,100013,100014,100015,100016,100017,100018,100019,100020,100021,100022,100023,100024,100025,100026,100027,100028,100029,100030,100031,100032,100033,100034,100035,100036,100037,100038,100039,100040,100041,100042,100043,100044,100045,100046,100047,100048,100050,100051,100052,100007,100008,100009,100053,100054,100055,100049','2','0');
INSERT INTO `blog_stu_group` VALUES('5','2',',10001','11','0');
--
-- 表的结构blog_stu_record
--
DROP TABLE IF EXISTS `blog_stu_record`;
CREATE TABLE `blog_stu_record` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`stu_id` int(11) DEFAULT NULL COMMENT '学生id',
`record` varchar(300) DEFAULT NULL COMMENT '跟踪内容',
`record_time` datetime DEFAULT NULL COMMENT '跟踪时间',
`record_user` varchar(20) DEFAULT NULL COMMENT '跟踪人',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8;
--
-- 转存表中的数据 blog_stu_record
--
INSERT INTO `blog_stu_record` VALUES('1','893426','真的不错还是可以的','2017-10-12 00:00:00','李晓辉');
INSERT INTO `blog_stu_record` VALUES('2','893426','学生没有投简历，天天在家躺着，和傻子一样','2017-10-12 00:00:00','李晓辉');
INSERT INTO `blog_stu_record` VALUES('3','893426','真不错，今天还投简历了','2017-10-12 00:00:00','李晓辉');
INSERT INTO `blog_stu_record` VALUES('4','893426','今天还不错 ，啥也没干','2017-10-12 00:00:00','李晓辉');
INSERT INTO `blog_stu_record` VALUES('5','893426','挺好的','2017-10-12 00:00:00','李晓辉');
INSERT INTO `blog_stu_record` VALUES('6','893426','阿什顿发斯蒂芬','2017-10-12 00:00:00','李晓辉');
INSERT INTO `blog_stu_record` VALUES('7','893426','而我','2017-10-09 00:00:00','李晓辉');
INSERT INTO `blog_stu_record` VALUES('8','893426','sdf','2017-10-12 00:00:00','李晓辉');
INSERT INTO `blog_stu_record` VALUES('9','896556','这个就是个傻子','2017-10-12 00:00:00','李晓辉');
INSERT INTO `blog_stu_record` VALUES('10','10004','热儿童yuiU','2017-10-03 00:00:00','李晓辉');
INSERT INTO `blog_stu_record` VALUES('11','893553','这就是个傻逼','2017-10-03 00:00:00','李晓辉');
INSERT INTO `blog_stu_record` VALUES('12','893553','这个傻逼擦','2017-10-19 00:00:00','李晓辉');
INSERT INTO `blog_stu_record` VALUES('13','894693','这个傻逼','2017-10-19 00:00:00','李晓辉');
INSERT INTO `blog_stu_record` VALUES('14','100004','但还是比','2017-10-19 00:00:00','李晓辉');
INSERT INTO `blog_stu_record` VALUES('15','894694','a爱的色放静安寺大家发老师看到发','2017-10-19 19:59:26','李晓辉');
INSERT INTO `blog_stu_record` VALUES('16','895391','真的不错','2017-10-19 20:58:07','李晓辉');
INSERT INTO `blog_stu_record` VALUES('17','893553','哈哈不错','2017-10-19 20:58:36','李晓辉');
INSERT INTO `blog_stu_record` VALUES('18','894694','哈哈','2017-10-19 20:58:50','李晓辉');
INSERT INTO `blog_stu_record` VALUES('19','894719','真的不错，该学生不错','2017-10-19 21:07:30','李晓辉');
INSERT INTO `blog_stu_record` VALUES('20','889940','这个就是傻子','2017-10-19 21:08:30','李晓辉');
--
-- 表的结构blog_stu_user
--
DROP TABLE IF EXISTS `blog_stu_user`;
CREATE TABLE `blog_stu_user` (
`user_id` int(11) NOT NULL AUTO_INCREMENT,
`user_name` varchar(30) DEFAULT NULL COMMENT '用户名称',
`user_pwd` varchar(50) DEFAULT NULL,
`user_group` varchar(30) DEFAULT NULL COMMENT '所属用户组',
PRIMARY KEY (`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
--
-- 转存表中的数据 blog_stu_user
--
INSERT INTO `blog_stu_user` VALUES('1','李晓辉','lixiaohui','PHP');
--
-- 表的结构blog_student
--
DROP TABLE IF EXISTS `blog_student`;
CREATE TABLE `blog_student` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '学生id',
`name` varchar(20) DEFAULT NULL COMMENT '姓名',
`sex` varchar(4) DEFAULT NULL COMMENT '性别',
`idcard` char(20) DEFAULT NULL COMMENT '身份证',
`cardAddress` varchar(100) DEFAULT NULL COMMENT '身份证地址',
`address` varchar(100) DEFAULT NULL COMMENT '现住地址',
`qq` varchar(11) DEFAULT NULL,
`tel` char(11) DEFAULT NULL,
`type` varchar(10) DEFAULT NULL COMMENT '类型',
`edu` varchar(10) DEFAULT NULL COMMENT '学历',
`school` varchar(50) DEFAULT NULL COMMENT '学校',
`major` varchar(10) DEFAULT NULL COMMENT '专业',
`consult` varchar(10) DEFAULT NULL COMMENT '咨询归属人',
`graduateTime` date DEFAULT NULL COMMENT '毕业时间',
`age` int(100) DEFAULT NULL COMMENT '年龄',
`class_id` int(10) DEFAULT NULL,
`job_type` int(1) DEFAULT '0' COMMENT '是否工作，0没有，1待入职，2已入职',
PRIMARY KEY (`id`),
KEY `name` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=899741 DEFAULT CHARSET=utf8;
--
-- 转存表中的数据 blog_student
--
INSERT INTO `blog_student` VALUES('10001','路帅','男','130924199511080517','河北省沧州市海兴县高湾镇','北京市顺义区京顺路99号学生公寓2号楼4层437室','974018431','18332619078','转班来','本科','华北理工大学轻工学院','工程造价','宋岩婷','0000-00-00','22','11','0');
INSERT INTO `blog_student` VALUES('10002','李新建','男','410181198102148513','巩义市','北京市顺义区京顺路99号学生公寓2号楼550室','358772182','13672007646','转班来','大专','天津外国语大学','英语','王波','0000-00-00','36','11','0');
INSERT INTO `blog_student` VALUES('10003','余旺','男','429004199401164712','湖北省仙桃市张沟镇新华街19号','北京市顺义区京顺路99号学生公寓2号楼442号','513554911','18086406610','转班来','大专','中国地质大学江城学院','建筑工程技术','赵海燕','2014-06-01','23','11','0');
INSERT INTO `blog_student` VALUES('10004','丁志超','男','220112199012222616','吉林省长春市','北京市顺义区京顺路99号学生公寓5号楼155','790850684','17778018001','升级','本科','通化师范学院','计算机科学与技术','程瑞玲','2013-07-10','27','11','2');
INSERT INTO `blog_student` VALUES('10005','郝琦飞','男','142327199404222276','山西省吕梁市柳林县薛村镇港村','北京市顺义区京顺路99号学生公寓5号楼140','2649321248','17611039626','升级','本科','山西运城学院','网络工程','党梅','2018-07-01','23','11','0');
INSERT INTO `blog_student` VALUES('10006','黄亮','男','510182198307071011','四川省彭州市九尺镇天宝村2组28号','北京市顺义区京顺路99号学生公寓5号楼101','359327865','13882288588','升级','大专','成都广播电视大学','电子商务','钮瑞清','2007-07-01','34','11','0');
INSERT INTO `blog_student` VALUES('10007','王冬','男','13060219880927063X','河北省保定市新市区天威西路2269号2栋3单元502','北京市顺义区京顺路99号学生公寓5栋401','529950624','13733377348','升级','大专','河北科技师范学院','电气自动化','刘冬梅','2015-01-05','29','11','0');
INSERT INTO `blog_student` VALUES('10008','胡杰','男','140521199406127011','山西省沁水县郑村镇半峪村上半峪41号','北京市顺义区京顺路99号学生公寓5号楼155','635382772','18404983401','升级','本科','山西农业大学','生物工程',' 游海华 ','2017-07-01','23','11','0');
INSERT INTO `blog_student` VALUES('10009','杜婷婷','女','412722199611263527','河南省周口市西华县逍遥镇李唐行政村大杜庄村','北京市顺义区京顺路99号学生公寓3号楼230','1649763103','18739906575','升级','大专','河南经贸职业学院','软件技术','崔贵鑫','2017-06-10','21','11','0');
INSERT INTO `blog_student` VALUES('10010','陈莉鑫','女','642222199609091629','宁夏中卫市沙坡头区兴仁镇高庄行政村第四自然村号','北京市顺义区京顺路99号学生公寓3号楼230','1564396203','17888840784','升级','大专','北京邮电大学','计算机科学与技术','高扬','2017-07-16','21','11','0');
INSERT INTO `blog_student` VALUES('10011','袁也','男','211322199209020316','辽宁省建平县铁南街道','北京市顺义区京顺路99号学生宿舍5号楼401','731673334','15524986545','升级','本科','辽宁工业大学','土木工程','赵秀梅','2015-07-01','25','11','0');
INSERT INTO `blog_student` VALUES('10012','杨三峰','男','120223199412182677','天津市静海区静海镇小口子门村亭仁胡同10号','北京市顺义区京顺路99号学生公寓5栋401','384786259','15022604467','升级','本科','河北工业大学','国际经济与贸易','孔德秀','2017-06-16','23','11','0');
INSERT INTO `blog_student` VALUES('10013','周华贞','女','371482199510306029','禹城市','北京市顺义区京顺路99号学生公寓3号楼230室','382938018','17865823013','升级','大专','聊城职业技术学院','软件技术','刘雅','2018-07-07','22','11','0');
INSERT INTO `blog_student` VALUES('10014','李伟','男','142302199301270518','山西省吕梁市离市区安居小区','北京市顺义区京顺路99号学生公寓5号楼101','1421961692','18634777452','升级','本科','中北大学','物联网工程','薛猛','2017-07-01','24','11','0');
INSERT INTO `blog_student` VALUES('10015','张宏伟','男','141102199411270015','山西省吕梁市离石区后瓦街','北京市顺义区京顺路99号学生公寓5号楼101','965126111','18435138514','升级','本科','中北大学','物联网工程','黄成艳','2017-07-01','23','11','0');
INSERT INTO `blog_student` VALUES('10016','黄鹤','女','150403199609050548','内蒙古赤峰市元宝山区元宝山镇三工村3-8-2','北京市顺义区京顺路99号学生公寓3号楼230','1322986884','17338117629','升级','本科','内蒙古科技大学','软件工程','吴昊','2018-07-01','21','11','0');
INSERT INTO `blog_student` VALUES('10017','王丹','女','372922199703150026','山东省菏泽市曹县南关田油坊','北京市顺义区京顺路99号学生公寓3号楼230室','3165414831','18366083556','升级','大专','聊城职业技术学院','软件','刘雅','2018-07-07','20','11','0');
INSERT INTO `blog_student` VALUES('10018','方浩然','男','412825199208112037','河南省上蔡县和店乡方庄村12957号','北京市顺义区京顺路99号学生公寓5栋401','1585853600','15801626453','升级','大专','河南经贸职业学院','计算机网络技术','李晓燕','2018-06-20','25','11','0');
INSERT INTO `blog_student` VALUES('10019','武福厚','男','140621199007256110','山西省朔州市山阴县古城镇4区4排8号','北京市顺义区京顺路99号学生公寓5号楼401','352062112','13994947326','升级','大专','天津机电工艺学院','机械制造及其自动化','刘乐','0000-00-00','27','11','0');
INSERT INTO `blog_student` VALUES('10020','杨念国','男','342222199506043658','安徽省宿州市萧县大屯镇许楼行政村许楼自然村304号','北京市顺义区京顺路99号学生公寓5号楼413','178800748','18865516282','升级','本科','烟台大学','金属材料工程','钮瑞清','2017-06-21','22','11','0');
INSERT INTO `blog_student` VALUES('10021','张光应','男','342222199408123259','安徽省宿州市萧县赵庄镇桃园村','北京市顺义区京顺路99号学生公寓5号楼413室','786781353','13693313072','升级','本科','山东财经大学东方学院','电子商务','赵海燕','2016-07-08','23','11','0');
INSERT INTO `blog_student` VALUES('10022','郭依蒙','女','37132419950710112X','山东省兰陵县刘岗子村138号','北京市顺义区京顺路99号学生公寓5栋135','1073155611','17610976780','升级','本科','鲁东大学','计算机科学与技术','邵孟雪','2017-07-01','22','11','0');
INSERT INTO `blog_student` VALUES('10023','曹东东','男','220122199512304012','吉林省长春市农安县哈拉海镇二道沟村八社','北京市顺义区京顺路99号学生公寓5号楼413','244729028','13601243046','升级','大专','吉林工商学院','计算机科学与技术','高博','2017-06-25','22','11','0');
INSERT INTO `blog_student` VALUES('10024','凤汝鹏','男','340221199302116490','安徽省芜湖市芜湖县陶辛镇四门行政村长村自然村21-1号','北京市顺义区京顺路99号学生公寓5栋104','852311573','15855999468','升级','本科','长沙理工大学','土木工程','郭慧婕','2015-06-05','24','11','0');
INSERT INTO `blog_student` VALUES('10025','靳宏伟','男','140227199311025030','山西省大同县倍加造镇营坊沟村233号','北京市顺义区京顺路99号学生公寓5号楼163','244862516','15822724305','升级','大专','天津机电职业技术学院','机电一体化','王育英','2015-07-07','24','11','0');
INSERT INTO `blog_student` VALUES('10026','贾俊伟','男','141122199611290155','山西省吕梁市交城县永宁路2号3号楼6单元502室','北京市顺义区京顺路99号学生公寓5楼163室','821331897','15799033484','升级','本科','海南大学','计算机科学与技术','李萌','2018-05-30','21','11','0');
INSERT INTO `blog_student` VALUES('10027','韩子烨','男','130185199503133411','河北省石家庄市新华区新华路591号1栋3单元502号','北京市顺义区京顺路99号学生公寓5号楼163','1015090886','13284443519','升级','本科','唐山师范学院','计算机科学与技术','宋婉晴','2018-06-26','22','11','0');
INSERT INTO `blog_student` VALUES('10028','预 陈志文','男','372324199601150033','山东省无棣县北环路9号L排228室','北京市顺义区京顺路99号学生公寓5栋413室','1097262745','13031105687','升级','本科','青岛大学','软件工程','胡珊珊','2018-07-07','21','11','0');
INSERT INTO `blog_student` VALUES('10029','陆金凯','男','370786199501013014','山东省昌邑市卜庄镇大路村475号','北京市顺义区京顺路99号学生公寓5号楼155','441757636','17667427610','升级','本科','青岛科技大学','电气工程及其自动化','刘斯怡','2017-06-26','22','11','0');
INSERT INTO `blog_student` VALUES('10030','王建春','男','130206199001241818','河北省唐山市丰润区18小区203楼2门401','北京市顺义区京顺路99号学生公寓5号楼252','313075603','18632504704','升级','本科','河北北方学院','信息管理与信息系统',' 游海华 ','2013-06-23','27','11','0');
INSERT INTO `blog_student` VALUES('10031','赵风济','男','211121198906041815','辽宁省大洼县平安乡新立村四组4-4','北京市顺义区京顺路99号学生公寓5号楼221室','334851265','15040325089','升级','本科','大连海洋大学应用技术学院','计算机科学与技术','曾春苗','2014-07-01','28','11','0');
INSERT INTO `blog_student` VALUES('10032','校林峰','男','420303199305142814','湖北省十堰市张湾区方山路90号东园小区005栋3单元502号','北京市顺义区京顺路99号学生公寓5号楼412','514910332','18801002449','升级','本科','哈尔滨工业大学（威海）','电子科学与技术','彭小凤','2016-07-01','24','11','0');
INSERT INTO `blog_student` VALUES('10033','许闻杰','男','339005199512088411','杭州市萧山区浦阳镇桃北新村横塘倪8组35号','北京市顺义区京顺路99号学生公寓5#161','1025430126','15168485701','升级','本科','内蒙古科技大学','软件工程','吴昊','2018-07-02','22','11','0');
INSERT INTO `blog_student` VALUES('10034','任宇','男','15282219941127301X','内蒙古巴彦淖尔市五原县复兴镇联丰村二社附002号','北京市顺义区京顺路99号学生公寓5号楼163','1615080638','15044964342','升级','本科','内蒙古科技大学','软件工程',' 游海华 ','2018-06-30','23','11','0');
INSERT INTO `blog_student` VALUES('10035','孙宇','男','150203199606272419','内蒙古包头市昆都仑区少先路三十一号街坊9栋38号','北京市顺义区京顺路99号学生公寓5号楼161','277645013','15124804894','升级','本科','内蒙古科技大学','软件工程','王芮','2018-06-30','21','11','0');
INSERT INTO `blog_student` VALUES('10036','李玉杰','男','411524199403062414','河南省信阳市商城县双椿铺镇郭窑村','北京市顺义区京顺路99号学生公寓5号楼415','851930397','18336816554','升级','本科','河南理工大学','机械设计','武杰','2017-06-21','23','11','0');
INSERT INTO `blog_student` VALUES('10037','张葵','男','140225199211132813','河南省洛阳市学子街八号2013级','北京市顺义区京顺路99号学生公寓2号楼425室','1021653977','18848958698','升级','本科','洛阳理工学院','计算机科学与技术','高扬','2017-07-01','25','11','0');
INSERT INTO `blog_student` VALUES('10038','白泽','男','14112319960910003X','山西省吕梁市兴县蔚汾镇程家沟村','北京市顺义区京顺路99号学生公寓5号楼415室','976705305','15035862673','升级','大专','山西工程职业技术学院','软件技术','石国兰','2018-07-01','21','11','0');
INSERT INTO `blog_student` VALUES('10039','李怡捷','女','140428199512285629','山西省长治市长子县南陈乡苏村','北京市顺义区京顺路99号学生公寓3号楼230','1365135331','18235163028','升级','本科','太原师范学院','计算机科学与技术','高扬','2018-07-01','22','11','0');
INSERT INTO `blog_student` VALUES('10040','孙磊','男','23230319880502041X','黑龙江省肇东市东丽北路','北京顺义区京顺路99号学生公寓5号楼415','3119447583','18801453435','升级','本科','华北科技学院','计算机','胡珊珊','2013-07-07','29','11','0');
INSERT INTO `blog_student` VALUES('10041','赵启明','男','210881199812151958','辽宁省盖州市九寨镇骆驼岭村14号404','北京市顺义区京顺路99号学生公寓5#415','892760828','18842626686','升级','本科','河北经贸大学','软件开发','黄艳','2018-06-15','19','11','0');
INSERT INTO `blog_student` VALUES('10042','马志远','男','150124199610067676','内蒙古清水河县窑沟乡马家也村','北京市顺义区京顺路99号学生公寓5#146','1786878742','15661337514','升级','本科','内蒙古科技大学','软件工程',' 游海华 ','2018-07-02','21','11','0');
INSERT INTO `blog_student` VALUES('10043','周瑞强','男','150102199601166615','内蒙古呼和浩特市新城区保合少乡','北京市顺义区京顺路99号学生公寓5#146','1769824717','18586188646','升级','本科','内蒙古科技大学','软件工程','吴昊','2018-07-01','21','11','0');
INSERT INTO `blog_student` VALUES('10044','王蒙','男','610424199408200418','陕西省咸阳市乾县','北京市顺义区京顺路99号-学生公寓-5#146','572934664','15044968860','升级','本科','内蒙古科技大学','软件工程','韩哪','2018-07-02','23','11','0');
INSERT INTO `blog_student` VALUES('10045','康伟鹏','男','230229199402281755','黑龙江省齐齐哈尔市克山县北兴镇','北京市顺义区京顺路99号学生公寓5#146','1151683175','13224860026','升级','本科','内蒙古科技大学','软件工程','韩哪','2018-07-02','23','11','0');
INSERT INTO `blog_student` VALUES('10046','张培垚','男','130406199605080374','河北省邯郸市峰峰矿区新市区通安街14号1号楼2单元9号','北京市顺义区京顺路99号学生公寓5号楼163','865134635','13932038617','升级','大专','邯郸职业技术学院','网站建设与管理','高扬','2018-07-10','21','11','0');
INSERT INTO `blog_student` VALUES('10047','朱玉龙','男','411326199305171731','内蒙古包头市青山区幸福路甲三号街坊9栋4号','北京市顺义区京顺路99号学生公寓5#146','964803363','15044702310','升级','本科','内蒙古科技大学','软件工程','吴昊','2018-07-01','24','11','0');
INSERT INTO `blog_student` VALUES('10048','吴鑫','男','371523199512116638','山东省茌平县振兴街道办事处赵西村','北京市顺义区京顺路99号学生公寓5号楼146','1521715360','15615050623','升级','本科','内蒙古科技大学','软件工程专业','吴昊','2018-07-01','22','11','0');
INSERT INTO `blog_student` VALUES('10049','杨超','男','372901199504238015','河北省三河市燕郊开发区大街同忆首歌汇福苑3号楼1单元041室','北京市顺义区京顺路99号学生公寓5号楼215','472391841','18603161304','升级','大专','华北理工大学','临床医学','孔德秀','2016-06-17','22','11','0');
INSERT INTO `blog_student` VALUES('10050','任占飞','男','130434199310223118','河北省邯郸市魏县魏城镇紫荆花苑西区12号楼1单元302号','北京市顺义区京顺路99号学生公寓5号楼412室','951255660','15133075551','升级','大专','邯郸大学','经济管理','王卫杰','2015-07-01','24','11','0');
INSERT INTO `blog_student` VALUES('10051','樊传奇','男','413026199309107337','河南省固始县蒋集镇孙岗村湖坝组','北京市顺义区京顺路99号学生公寓5号楼412室','1249130528','13552343692','升级','高中','固始慈济高中','无','刘璐 ','2010-06-10','24','11','0');
INSERT INTO `blog_student` VALUES('10052','张坤朋','男','412726199212062838','河南省郸城县白马镇耐中行政村耐中村107号','北京市顺义区京顺路99号学生公寓5号楼408','2575493792','18848956801','升级','本科','洛阳理工学院','计算机科学与技术','郑丹','2017-06-10','25','11','0');
INSERT INTO `blog_student` VALUES('10053','张鸿','男','211322199311152278','辽宁省朝阳市建平县海棠村','北京市顺义区京顺路99号学生公寓5号楼412室','531897938','13664268853','升级','本科','大连财经学院','会计','王芮','2017-07-09','24','11','0');
INSERT INTO `blog_student` VALUES('10054','张明哲','女','410504199310241521','河南省安阳市殷都区文峰大道570号院','北京市顺义区马坡白各庄如家公寓','404150826','17600327084','新生','本科','湖南邵阳学院','计算机','刘文娟','2017-07-01','24','11','0');
INSERT INTO `blog_student` VALUES('10055','朱凤针','女','411628199212034622','河南省鹿邑县任集乡均朱村','北京市顺义区马坡镇白各庄青年公寓252室','528028799','13311079725','转班来','大专','首钢工学院','计算机应用技术','顾惠','2015-05-31','25','11','0');
INSERT INTO `blog_student` VALUES('19196','朱凤针','女','411628199212034622','河南省鹿邑县任集乡均朱村','北京市顺义区马坡镇白各庄青年公寓252室','528028799','13311079725','转班来','大专','首钢工学院','计算机应用技术','顾惠','2015-05-31','25','1','0');
INSERT INTO `blog_student` VALUES('100001','路帅','男','130924199511080517','河北省沧州市海兴县高湾镇','北京市顺义区京顺路99号学生公寓2号楼4层437室','974018431','18332619078','转班来','本科','华北理工大学轻工学院','工程造价','宋岩婷','0000-00-00','22','2','0');
INSERT INTO `blog_student` VALUES('100002','李新建','男','410181198102148513','巩义市','北京市顺义区京顺路99号学生公寓2号楼550室','358772182','13672007646','转班来','大专','天津外国语大学','英语','王波','0000-00-00','36','2','0');
INSERT INTO `blog_student` VALUES('100003','余旺','男','429004199401164712','湖北省仙桃市张沟镇新华街19号','北京市顺义区京顺路99号学生公寓2号楼442号','513554911','18086406610','转班来','大专','中国地质大学江城学院','建筑工程技术','赵海燕','2014-06-01','23','2','0');
INSERT INTO `blog_student` VALUES('100004','丁志超','男','220112199012222616','吉林省长春市','北京市顺义区京顺路99号学生公寓5号楼155','790850684','17778018001','升级','本科','通化师范学院','计算机科学与技术','程瑞玲','2013-07-10','27','2','0');
INSERT INTO `blog_student` VALUES('100005','郝琦飞','男','142327199404222276','山西省吕梁市柳林县薛村镇港村','北京市顺义区京顺路99号学生公寓5号楼140','2649321248','17611039626','升级','本科','山西运城学院','网络工程','党梅','2018-07-01','23','2','0');
INSERT INTO `blog_student` VALUES('100006','黄亮','男','510182198307071011','四川省彭州市九尺镇天宝村2组28号','北京市顺义区京顺路99号学生公寓5号楼101','359327865','13882288588','升级','大专','成都广播电视大学','电子商务','钮瑞清','2007-07-01','34','2','0');
INSERT INTO `blog_student` VALUES('100007','王冬','男','13060219880927063X','河北省保定市新市区天威西路2269号2栋3单元502','北京市顺义区京顺路99号学生公寓5栋401','529950624','13733377348','升级','大专','河北科技师范学院','电气自动化','刘冬梅','2015-01-05','29','2','0');
INSERT INTO `blog_student` VALUES('100008','胡杰','男','140521199406127011','山西省沁水县郑村镇半峪村上半峪41号','北京市顺义区京顺路99号学生公寓5号楼155','635382772','18404983401','升级','本科','山西农业大学','生物工程',' 游海华 ','2017-07-01','23','2','0');
INSERT INTO `blog_student` VALUES('100009','杜婷婷','女','412722199611263527','河南省周口市西华县逍遥镇李唐行政村大杜庄村','北京市顺义区京顺路99号学生公寓3号楼230','1649763103','18739906575','升级','大专','河南经贸职业学院','软件技术','崔贵鑫','2017-06-10','21','2','0');
INSERT INTO `blog_student` VALUES('100010','陈莉鑫','女','642222199609091629','宁夏中卫市沙坡头区兴仁镇高庄行政村第四自然村号','北京市顺义区京顺路99号学生公寓3号楼230','1564396203','17888840784','升级','大专','北京邮电大学','计算机科学与技术','高扬','2017-07-16','21','2','0');
INSERT INTO `blog_student` VALUES('100011','袁也','男','211322199209020316','辽宁省建平县铁南街道','北京市顺义区京顺路99号学生宿舍5号楼401','731673334','15524986545','升级','本科','辽宁工业大学','土木工程','赵秀梅','2015-07-01','25','2','0');
INSERT INTO `blog_student` VALUES('100012','杨三峰','男','120223199412182677','天津市静海区静海镇小口子门村亭仁胡同10号','北京市顺义区京顺路99号学生公寓5栋401','384786259','15022604467','升级','本科','河北工业大学','国际经济与贸易','孔德秀','2017-06-16','23','2','0');
INSERT INTO `blog_student` VALUES('100013','周华贞','女','371482199510306029','禹城市','北京市顺义区京顺路99号学生公寓3号楼230室','382938018','17865823013','升级','大专','聊城职业技术学院','软件技术','刘雅','2018-07-07','22','2','0');
INSERT INTO `blog_student` VALUES('100014','李伟','男','142302199301270518','山西省吕梁市离市区安居小区','北京市顺义区京顺路99号学生公寓5号楼101','1421961692','18634777452','升级','本科','中北大学','物联网工程','薛猛','2017-07-01','24','2','0');
INSERT INTO `blog_student` VALUES('100015','张宏伟','男','141102199411270015','山西省吕梁市离石区后瓦街','北京市顺义区京顺路99号学生公寓5号楼101','965126111','18435138514','升级','本科','中北大学','物联网工程','黄成艳','2017-07-01','23','2','0');
INSERT INTO `blog_student` VALUES('100016','黄鹤','女','150403199609050548','内蒙古赤峰市元宝山区元宝山镇三工村3-8-2','北京市顺义区京顺路99号学生公寓3号楼230','1322986884','17338117629','升级','本科','内蒙古科技大学','软件工程','吴昊','2018-07-01','21','2','0');
INSERT INTO `blog_student` VALUES('100017','王丹','女','372922199703150026','山东省菏泽市曹县南关田油坊','北京市顺义区京顺路99号学生公寓3号楼230室','3165414831','18366083556','升级','大专','聊城职业技术学院','软件','刘雅','2018-07-07','20','2','0');
INSERT INTO `blog_student` VALUES('100018','方浩然','男','412825199208112037','河南省上蔡县和店乡方庄村12957号','北京市顺义区京顺路99号学生公寓5栋401','1585853600','15801626453','升级','大专','河南经贸职业学院','计算机网络技术','李晓燕','2018-06-20','25','2','0');
INSERT INTO `blog_student` VALUES('100019','武福厚','男','140621199007256110','山西省朔州市山阴县古城镇4区4排8号','北京市顺义区京顺路99号学生公寓5号楼401','352062112','13994947326','升级','大专','天津机电工艺学院','机械制造及其自动化','刘乐','0000-00-00','27','2','0');
INSERT INTO `blog_student` VALUES('100020','杨念国','男','342222199506043658','安徽省宿州市萧县大屯镇许楼行政村许楼自然村304号','北京市顺义区京顺路99号学生公寓5号楼413','178800748','18865516282','升级','本科','烟台大学','金属材料工程','钮瑞清','2017-06-21','22','2','0');
INSERT INTO `blog_student` VALUES('100021','张光应','男','342222199408123259','安徽省宿州市萧县赵庄镇桃园村','北京市顺义区京顺路99号学生公寓5号楼413室','786781353','13693313072','升级','本科','山东财经大学东方学院','电子商务','赵海燕','2016-07-08','23','2','0');
INSERT INTO `blog_student` VALUES('100022','郭依蒙','女','37132419950710112X','山东省兰陵县刘岗子村138号','北京市顺义区京顺路99号学生公寓5栋135','1073155611','17610976780','升级','本科','鲁东大学','计算机科学与技术','邵孟雪','2017-07-01','22','2','0');
INSERT INTO `blog_student` VALUES('100023','曹东东','男','220122199512304012','吉林省长春市农安县哈拉海镇二道沟村八社','北京市顺义区京顺路99号学生公寓5号楼413','244729028','13601243046','升级','大专','吉林工商学院','计算机科学与技术','高博','2017-06-25','22','2','0');
INSERT INTO `blog_student` VALUES('100024','凤汝鹏','男','340221199302116490','安徽省芜湖市芜湖县陶辛镇四门行政村长村自然村21-1号','北京市顺义区京顺路99号学生公寓5栋104','852311573','15855999468','升级','本科','长沙理工大学','土木工程','郭慧婕','2015-06-05','24','2','0');
INSERT INTO `blog_student` VALUES('100025','靳宏伟','男','140227199311025030','山西省大同县倍加造镇营坊沟村233号','北京市顺义区京顺路99号学生公寓5号楼163','244862516','15822724305','升级','大专','天津机电职业技术学院','机电一体化','王育英','2015-07-07','24','2','0');
INSERT INTO `blog_student` VALUES('100026','贾俊伟','男','141122199611290155','山西省吕梁市交城县永宁路2号3号楼6单元502室','北京市顺义区京顺路99号学生公寓5楼163室','821331897','15799033484','升级','本科','海南大学','计算机科学与技术','李萌','2018-05-30','21','2','0');
INSERT INTO `blog_student` VALUES('100027','韩子烨','男','130185199503133411','河北省石家庄市新华区新华路591号1栋3单元502号','北京市顺义区京顺路99号学生公寓5号楼163','1015090886','13284443519','升级','本科','唐山师范学院','计算机科学与技术','宋婉晴','2018-06-26','22','2','0');
INSERT INTO `blog_student` VALUES('100028','预 陈志文','男','372324199601150033','山东省无棣县北环路9号L排228室','北京市顺义区京顺路99号学生公寓5栋413室','1097262745','13031105687','升级','本科','青岛大学','软件工程','胡珊珊','2018-07-07','21','2','0');
INSERT INTO `blog_student` VALUES('100029','陆金凯','男','370786199501013014','山东省昌邑市卜庄镇大路村475号','北京市顺义区京顺路99号学生公寓5号楼155','441757636','17667427610','升级','本科','青岛科技大学','电气工程及其自动化','刘斯怡','2017-06-26','22','2','0');
INSERT INTO `blog_student` VALUES('100030','王建春','男','130206199001241818','河北省唐山市丰润区18小区203楼2门401','北京市顺义区京顺路99号学生公寓5号楼252','313075603','18632504704','升级','本科','河北北方学院','信息管理与信息系统',' 游海华 ','2013-06-23','27','2','0');
INSERT INTO `blog_student` VALUES('100031','赵风济','男','211121198906041815','辽宁省大洼县平安乡新立村四组4-4','北京市顺义区京顺路99号学生公寓5号楼221室','334851265','15040325089','升级','本科','大连海洋大学应用技术学院','计算机科学与技术','曾春苗','2014-07-01','28','2','0');
INSERT INTO `blog_student` VALUES('100032','校林峰','男','420303199305142814','湖北省十堰市张湾区方山路90号东园小区005栋3单元502号','北京市顺义区京顺路99号学生公寓5号楼412','514910332','18801002449','升级','本科','哈尔滨工业大学（威海）','电子科学与技术','彭小凤','2016-07-01','24','2','0');
INSERT INTO `blog_student` VALUES('100033','许闻杰','男','339005199512088411','杭州市萧山区浦阳镇桃北新村横塘倪8组35号','北京市顺义区京顺路99号学生公寓5#161','1025430126','15168485701','升级','本科','内蒙古科技大学','软件工程','吴昊','2018-07-02','22','2','0');
INSERT INTO `blog_student` VALUES('100034','任宇','男','15282219941127301X','内蒙古巴彦淖尔市五原县复兴镇联丰村二社附002号','北京市顺义区京顺路99号学生公寓5号楼163','1615080638','15044964342','升级','本科','内蒙古科技大学','软件工程',' 游海华 ','2018-06-30','23','2','0');
INSERT INTO `blog_student` VALUES('100035','孙宇','男','150203199606272419','内蒙古包头市昆都仑区少先路三十一号街坊9栋38号','北京市顺义区京顺路99号学生公寓5号楼161','277645013','15124804894','升级','本科','内蒙古科技大学','软件工程','王芮','2018-06-30','21','2','0');
INSERT INTO `blog_student` VALUES('100036','李玉杰','男','411524199403062414','河南省信阳市商城县双椿铺镇郭窑村','北京市顺义区京顺路99号学生公寓5号楼415','851930397','18336816554','升级','本科','河南理工大学','机械设计','武杰','2017-06-21','23','2','0');
INSERT INTO `blog_student` VALUES('100037','张葵','男','140225199211132813','河南省洛阳市学子街八号2013级','北京市顺义区京顺路99号学生公寓2号楼425室','1021653977','18848958698','升级','本科','洛阳理工学院','计算机科学与技术','高扬','2017-07-01','25','2','0');
INSERT INTO `blog_student` VALUES('100038','白泽','男','14112319960910003X','山西省吕梁市兴县蔚汾镇程家沟村','北京市顺义区京顺路99号学生公寓5号楼415室','976705305','15035862673','升级','大专','山西工程职业技术学院','软件技术','石国兰','2018-07-01','21','2','0');
INSERT INTO `blog_student` VALUES('100039','李怡捷','女','140428199512285629','山西省长治市长子县南陈乡苏村','北京市顺义区京顺路99号学生公寓3号楼230','1365135331','18235163028','升级','本科','太原师范学院','计算机科学与技术','高扬','2018-07-01','22','2','0');
INSERT INTO `blog_student` VALUES('100040','孙磊','男','23230319880502041X','黑龙江省肇东市东丽北路','北京顺义区京顺路99号学生公寓5号楼415','3119447583','18801453435','升级','本科','华北科技学院','计算机','胡珊珊','2013-07-07','29','2','0');
INSERT INTO `blog_student` VALUES('100041','赵启明','男','210881199812151958','辽宁省盖州市九寨镇骆驼岭村14号404','北京市顺义区京顺路99号学生公寓5#415','892760828','18842626686','升级','本科','河北经贸大学','软件开发','黄艳','2018-06-15','19','2','0');
INSERT INTO `blog_student` VALUES('100042','马志远','男','150124199610067676','内蒙古清水河县窑沟乡马家也村','北京市顺义区京顺路99号学生公寓5#146','1786878742','15661337514','升级','本科','内蒙古科技大学','软件工程',' 游海华 ','2018-07-02','21','2','0');
INSERT INTO `blog_student` VALUES('100043','周瑞强','男','150102199601166615','内蒙古呼和浩特市新城区保合少乡','北京市顺义区京顺路99号学生公寓5#146','1769824717','18586188646','升级','本科','内蒙古科技大学','软件工程','吴昊','2018-07-01','21','2','0');
INSERT INTO `blog_student` VALUES('100044','王蒙','男','610424199408200418','陕西省咸阳市乾县','北京市顺义区京顺路99号-学生公寓-5#146','572934664','15044968860','升级','本科','内蒙古科技大学','软件工程','韩哪','2018-07-02','23','2','0');
INSERT INTO `blog_student` VALUES('100045','康伟鹏','男','230229199402281755','黑龙江省齐齐哈尔市克山县北兴镇','北京市顺义区京顺路99号学生公寓5#146','1151683175','13224860026','升级','本科','内蒙古科技大学','软件工程','韩哪','2018-07-02','23','2','0');
INSERT INTO `blog_student` VALUES('100046','张培垚','男','130406199605080374','河北省邯郸市峰峰矿区新市区通安街14号1号楼2单元9号','北京市顺义区京顺路99号学生公寓5号楼163','865134635','13932038617','升级','大专','邯郸职业技术学院','网站建设与管理','高扬','2018-07-10','21','2','0');
INSERT INTO `blog_student` VALUES('100047','朱玉龙','男','411326199305171731','内蒙古包头市青山区幸福路甲三号街坊9栋4号','北京市顺义区京顺路99号学生公寓5#146','964803363','15044702310','升级','本科','内蒙古科技大学','软件工程','吴昊','2018-07-01','24','2','0');
INSERT INTO `blog_student` VALUES('100048','吴鑫','男','371523199512116638','山东省茌平县振兴街道办事处赵西村','北京市顺义区京顺路99号学生公寓5号楼146','1521715360','15615050623','升级','本科','内蒙古科技大学','软件工程专业','吴昊','2018-07-01','22','2','0');
INSERT INTO `blog_student` VALUES('100049','杨超','男','372901199504238015','河北省三河市燕郊开发区大街同忆首歌汇福苑3号楼1单元041室','北京市顺义区京顺路99号学生公寓5号楼215','472391841','18603161304','升级','大专','华北理工大学','临床医学','孔德秀','2016-06-17','22','2','0');
INSERT INTO `blog_student` VALUES('100050','任占飞','男','130434199310223118','河北省邯郸市魏县魏城镇紫荆花苑西区12号楼1单元302号','北京市顺义区京顺路99号学生公寓5号楼412室','951255660','15133075551','升级','大专','邯郸大学','经济管理','王卫杰','2015-07-01','24','2','0');
INSERT INTO `blog_student` VALUES('100051','樊传奇','男','413026199309107337','河南省固始县蒋集镇孙岗村湖坝组','北京市顺义区京顺路99号学生公寓5号楼412室','1249130528','13552343692','升级','高中','固始慈济高中','无','刘璐 ','2010-06-10','24','2','0');
INSERT INTO `blog_student` VALUES('100052','张坤朋','男','412726199212062838','河南省郸城县白马镇耐中行政村耐中村107号','北京市顺义区京顺路99号学生公寓5号楼408','2575493792','18848956801','升级','本科','洛阳理工学院','计算机科学与技术','郑丹','2017-06-10','25','2','0');
INSERT INTO `blog_student` VALUES('100053','张鸿','男','211322199311152278','辽宁省朝阳市建平县海棠村','北京市顺义区京顺路99号学生公寓5号楼412室','531897938','13664268853','升级','本科','大连财经学院','会计','王芮','2017-07-09','24','2','0');
INSERT INTO `blog_student` VALUES('100054','张明哲','女','410504199310241521','河南省安阳市殷都区文峰大道570号院','北京市顺义区马坡白各庄如家公寓','404150826','17600327084','新生','本科','湖南邵阳学院','计算机','刘文娟','2017-07-01','24','2','0');
INSERT INTO `blog_student` VALUES('100055','朱凤针','女','411628199212034622','河南省鹿邑县任集乡均朱村','北京市顺义区马坡镇白各庄青年公寓252室','528028799','13311079725','转班来','大专','首钢工学院','计算机应用技术','顾惠','2015-05-31','25','2','0');
INSERT INTO `blog_student` VALUES('833278','路帅','男','130924199511080517','河北省沧州市海兴县高湾镇','北京市顺义区京顺路99号学生公寓2号楼4层437室','974018431','18332619078','转班来','本科','华北理工大学轻工学院','工程造价','宋岩婷','0000-00-00','22','1','0');
INSERT INTO `blog_student` VALUES('864067','陆金凯','男','370786199501013014','山东省昌邑市卜庄镇大路村475号','北京市顺义区京顺路99号学生公寓5号楼155','441757636','17667427610','升级','本科','青岛科技大学','电气工程及其自动化','刘斯怡','2017-06-26','22','1','0');
INSERT INTO `blog_student` VALUES('866663','白泽','男','14112319960910003X','山西省吕梁市兴县蔚汾镇程家沟村','北京市顺义区京顺路99号学生公寓5号楼415室','976705305','15035862673','升级','大专','山西工程职业技术学院','软件技术','石国兰','2018-07-01','21','1','0');
INSERT INTO `blog_student` VALUES('880332','余旺','男','429004199401164712','湖北省仙桃市张沟镇新华街19号','北京市顺义区京顺路99号学生公寓2号楼442号','513554911','18086406610','转班来','大专','中国地质大学江城学院','建筑工程技术','赵海燕','2014-06-01','23','1','1');
INSERT INTO `blog_student` VALUES('884550','李新建','男','410181198102148513','巩义市','北京市顺义区京顺路99号学生公寓2号楼550室','358772182','13672007646','转班来','大专','天津外国语大学','英语','王波','0000-00-00','36','1','0');
INSERT INTO `blog_student` VALUES('886069','郭依蒙','女','37132419950710112X','山东省兰陵县刘岗子村138号','北京市顺义区京顺路99号学生公寓5栋135','1073155611','17610976780','升级','本科','鲁东大学','计算机科学与技术','邵孟雪','2017-07-01','22','1','0');
INSERT INTO `blog_student` VALUES('886512','袁也','男','211322199209020316','辽宁省建平县铁南街道','北京市顺义区京顺路99号学生宿舍5号楼401','731673334','15524986545','升级','本科','辽宁工业大学','土木工程','赵秀梅','2015-07-01','25','1','0');
INSERT INTO `blog_student` VALUES('886795','贾俊伟','男','141122199611290155','山西省吕梁市交城县永宁路2号3号楼6单元502室','北京市顺义区京顺路99号学生公寓5楼163室','821331897','15799033484','升级','本科','海南大学','计算机科学与技术','李萌','2018-05-30','21','1','0');
INSERT INTO `blog_student` VALUES('887478','郝琦飞','男','142327199404222276','山西省吕梁市柳林县薛村镇港村','北京市顺义区京顺路99号学生公寓5号楼140','2649321248','17611039626','升级','本科','山西运城学院','网络工程','党梅','2018-07-01','23','1','0');
INSERT INTO `blog_student` VALUES('888378','李怡捷','女','140428199512285629','山西省长治市长子县南陈乡苏村','北京市顺义区京顺路99号学生公寓3号楼230','1365135331','18235163028','升级','本科','太原师范学院','计算机科学与技术','高扬','2018-07-01','22','1','0');
INSERT INTO `blog_student` VALUES('888567','张葵','男','140225199211132813','河南省洛阳市学子街八号2013级','北京市顺义区京顺路99号学生公寓2号楼425室','1021653977','18848958698','升级','本科','洛阳理工学院','计算机科学与技术','高扬','2017-07-01','25','1','0');
INSERT INTO `blog_student` VALUES('889311','预 陈志文','男','372324199601150033','山东省无棣县北环路9号L排228室','北京市顺义区京顺路99号学生公寓5栋413室','1097262745','13031105687','升级','本科','青岛大学','软件工程','胡珊珊','2018-07-07','21','1','0');
INSERT INTO `blog_student` VALUES('889940','张光应','男','342222199408123259','安徽省宿州市萧县赵庄镇桃园村','北京市顺义区京顺路99号学生公寓5号楼413室','786781353','13693313072','升级','本科','山东财经大学东方学院','电子商务','赵海燕','2016-07-08','23','1','0');
INSERT INTO `blog_student` VALUES('890347','靳宏伟','男','140227199311025030','山西省大同县倍加造镇营坊沟村233号','北京市顺义区京顺路99号学生公寓5号楼163','244862516','15822724305','升级','大专','天津机电职业技术学院','机电一体化','王育英','2015-07-07','24','1','0');
INSERT INTO `blog_student` VALUES('891251','张坤朋','男','412726199212062838','河南省郸城县白马镇耐中行政村耐中村107号','北京市顺义区京顺路99号学生公寓5号楼408','2575493792','18848956801','升级','本科','洛阳理工学院','计算机科学与技术','郑丹','2017-06-10','25','1','0');
INSERT INTO `blog_student` VALUES('891598','胡杰','男','140521199406127011','山西省沁水县郑村镇半峪村上半峪41号','北京市顺义区京顺路99号学生公寓5号楼155','635382772','18404983401','升级','本科','山西农业大学','生物工程',' 游海华 ','2017-07-01','23','1','0');
INSERT INTO `blog_student` VALUES('892052','陈莉鑫','女','642222199609091629','宁夏中卫市沙坡头区兴仁镇高庄行政村第四自然村号','北京市顺义区京顺路99号学生公寓3号楼230','1564396203','17888840784','升级','大专','北京邮电大学','计算机科学与技术','高扬','2017-07-16','21','1','0');
INSERT INTO `blog_student` VALUES('892341','李玉杰','男','411524199403062414','河南省信阳市商城县双椿铺镇郭窑村','北京市顺义区京顺路99号学生公寓5号楼415','851930397','18336816554','升级','本科','河南理工大学','机械设计','武杰','2017-06-21','23','1','0');
INSERT INTO `blog_student` VALUES('892361','张培垚','男','130406199605080374','河北省邯郸市峰峰矿区新市区通安街14号1号楼2单元9号','北京市顺义区京顺路99号学生公寓5号楼163','865134635','13932038617','升级','大专','邯郸职业技术学院','网站建设与管理','高扬','2018-07-10','21','1','0');
INSERT INTO `blog_student` VALUES('892546','黄亮','男','510182198307071011','四川省彭州市九尺镇天宝村2组28号','北京市顺义区京顺路99号学生公寓5号楼101','359327865','13882288588','升级','大专','成都广播电视大学','电子商务','钮瑞清','2007-07-01','34','1','0');
INSERT INTO `blog_student` VALUES('892825','凤汝鹏','男','340221199302116490','安徽省芜湖市芜湖县陶辛镇四门行政村长村自然村21-1号','北京市顺义区京顺路99号学生公寓5栋104','852311573','15855999468','升级','本科','长沙理工大学','土木工程','郭慧婕','2015-06-05','24','1','2');
INSERT INTO `blog_student` VALUES('893231','王冬','男','13060219880927063X','河北省保定市新市区天威西路2269号2栋3单元502','北京市顺义区京顺路99号学生公寓5栋401','529950624','13733377348','升级','大专','河北科技师范学院','电气自动化','刘冬梅','2015-01-05','29','1','0');
INSERT INTO `blog_student` VALUES('893426','丁志超','男','220112199012222616','吉林省长春市','北京市顺义区京顺路99号学生公寓5号楼155','790850684','17778018001','1','本科','通化师范学院','计算机科学与技术','程瑞玲','2013-07-10','27','1','2');
INSERT INTO `blog_student` VALUES('893553','周华贞','女','371482199510306029','禹城市','北京市顺义区京顺路99号学生公寓3号楼230室','382938018','17865823013','升级','大专','聊城职业技术学院','软件技术','刘雅','2018-07-07','22','1','0');
INSERT INTO `blog_student` VALUES('893578','王丹','女','372922199703150026','山东省菏泽市曹县南关田油坊','北京市顺义区京顺路99号学生公寓3号楼230室','3165414831','18366083556','升级','大专','聊城职业技术学院','软件','刘雅','2018-07-07','20','1','0');
INSERT INTO `blog_student` VALUES('893730','王建春','男','130206199001241818','河北省唐山市丰润区18小区203楼2门401','北京市顺义区京顺路99号学生公寓5号楼252','313075603','18632504704','升级','本科','河北北方学院','信息管理与信息系统',' 游海华 ','2013-06-23','27','1','0');
INSERT INTO `blog_student` VALUES('894081','校林峰','男','420303199305142814','湖北省十堰市张湾区方山路90号东园小区005栋3单元502号','北京市顺义区京顺路99号学生公寓5号楼412','514910332','18801002449','升级','本科','哈尔滨工业大学（威海）','电子科学与技术','彭小凤','2016-07-01','24','1','0');
INSERT INTO `blog_student` VALUES('894354','张宏伟','男','141102199411270015','山西省吕梁市离石区后瓦街','北京市顺义区京顺路99号学生公寓5号楼101','965126111','18435138514','升级','本科','中北大学','物联网工程','黄成艳','2017-07-01','23','1','0');
INSERT INTO `blog_student` VALUES('894356','李伟','男','142302199301270518','山西省吕梁市离市区安居小区','北京市顺义区京顺路99号学生公寓5号楼101','1421961692','18634777452','升级','本科','中北大学','物联网工程','薛猛','2017-07-01','24','1','0');
INSERT INTO `blog_student` VALUES('894507','杜婷婷','女','412722199611263527','河南省周口市西华县逍遥镇李唐行政村大杜庄村','北京市顺义区京顺路99号学生公寓3号楼230','1649763103','18739906575','升级','大专','河南经贸职业学院','软件技术','崔贵鑫','2017-06-10','21','1','0');
INSERT INTO `blog_student` VALUES('894570','杨念国','男','342222199506043658','安徽省宿州市萧县大屯镇许楼行政村许楼自然村304号','北京市顺义区京顺路99号学生公寓5号楼413','178800748','18865516282','升级','本科','烟台大学','金属材料工程','钮瑞清','2017-06-21','22','1','0');
INSERT INTO `blog_student` VALUES('894599','武福厚','男','140621199007256110','山西省朔州市山阴县古城镇4区4排8号','北京市顺义区京顺路99号学生公寓5号楼401','352062112','13994947326','升级','大专','天津机电工艺学院','机械制造及其自动化','刘乐','0000-00-00','27','1','0');
INSERT INTO `blog_student` VALUES('894665','杨三峰','男','120223199412182677','天津市静海区静海镇小口子门村亭仁胡同10号','北京市顺义区京顺路99号学生公寓5栋401','384786259','15022604467','升级','本科','河北工业大学','国际经济与贸易','孔德秀','2017-06-16','23','1','0');
INSERT INTO `blog_student` VALUES('894687','许闻杰','男','339005199512088411','杭州市萧山区浦阳镇桃北新村横塘倪8组35号','北京市顺义区京顺路99号学生公寓5#161','1025430126','15168485701','升级','本科','内蒙古科技大学','软件工程','吴昊','2018-07-02','22','1','0');
INSERT INTO `blog_student` VALUES('894688','马志远','男','150124199610067676','内蒙古清水河县窑沟乡马家也村','北京市顺义区京顺路99号学生公寓5#146','1786878742','15661337514','升级','本科','内蒙古科技大学','软件工程',' 游海华 ','2018-07-02','21','1','0');
INSERT INTO `blog_student` VALUES('894691','任宇','男','15282219941127301X','内蒙古巴彦淖尔市五原县复兴镇联丰村二社附002号','北京市顺义区京顺路99号学生公寓5号楼163','1615080638','15044964342','升级','本科','内蒙古科技大学','软件工程',' 游海华 ','2018-06-30','23','1','1');
INSERT INTO `blog_student` VALUES('894693','周瑞强','男','150102199601166615','内蒙古呼和浩特市新城区保合少乡','北京市顺义区京顺路99号学生公寓5#146','1769824717','18586188646','升级','本科','内蒙古科技大学','软件工程','吴昊','2018-07-01','21','1','0');
INSERT INTO `blog_student` VALUES('894694','孙宇','男','150203199606272419','内蒙古包头市昆都仑区少先路三十一号街坊9栋38号','北京市顺义区京顺路99号学生公寓5号楼161','277645013','15124804894','升级','本科','内蒙古科技大学','软件工程','王芮','2018-06-30','21','1','0');
INSERT INTO `blog_student` VALUES('894708','王蒙','男','610424199408200418','陕西省咸阳市乾县','北京市顺义区京顺路99号-学生公寓-5#146','572934664','15044968860','升级','本科','内蒙古科技大学','软件工程','韩哪','2018-07-02','23','1','0');
INSERT INTO `blog_student` VALUES('894711','吴鑫','男','371523199512116638','山东省茌平县振兴街道办事处赵西村','北京市顺义区京顺路99号学生公寓5号楼146','1521715360','15615050623','升级','本科','内蒙古科技大学','软件工程专业','吴昊','2018-07-01','22','1','2');
INSERT INTO `blog_student` VALUES('894719','康伟鹏','男','230229199402281755','黑龙江省齐齐哈尔市克山县北兴镇','北京市顺义区京顺路99号学生公寓5#146','1151683175','13224860026','升级','本科','内蒙古科技大学','软件工程','韩哪','2018-07-02','23','1','0');
INSERT INTO `blog_student` VALUES('894788','朱玉龙','男','411326199305171731','内蒙古包头市青山区幸福路甲三号街坊9栋4号','北京市顺义区京顺路99号学生公寓5#146','964803363','15044702310','升级','本科','内蒙古科技大学','软件工程','吴昊','2018-07-01','24','1','0');
INSERT INTO `blog_student` VALUES('894983','黄鹤','女','150403199609050548','内蒙古赤峰市元宝山区元宝山镇三工村3-8-2','北京市顺义区京顺路99号学生公寓3号楼230','1322986884','17338117629','升级','本科','内蒙古科技大学','软件工程','吴昊','2018-07-01','21','1','0');
INSERT INTO `blog_student` VALUES('895391','孙磊','男','23230319880502041X','黑龙江省肇东市东丽北路','北京顺义区京顺路99号学生公寓5号楼415','3119447583','18801453435','升级','本科','华北科技学院','计算机','胡珊珊','2013-07-07','29','1','0');
INSERT INTO `blog_student` VALUES('895417','曹东东','男','220122199512304012','吉林省长春市农安县哈拉海镇二道沟村八社','北京市顺义区京顺路99号学生公寓5号楼413','244729028','13601243046','升级','大专','吉林工商学院','计算机科学与技术','高博','2017-06-25','22','1','0');
INSERT INTO `blog_student` VALUES('895499','方浩然','男','412825199208112037','河南省上蔡县和店乡方庄村12957号','北京市顺义区京顺路99号学生公寓5栋401','1585853600','15801626453','升级','大专','河南经贸职业学院','计算机网络技术','李晓燕','2018-06-20','25','1','0');
INSERT INTO `blog_student` VALUES('895566','赵启明','男','210881199812151958','辽宁省盖州市九寨镇骆驼岭村14号404','北京市顺义区京顺路99号学生公寓5#415','892760828','18842626686','升级','本科','河北经贸大学','软件开发','黄艳','2018-06-15','19','1','0');
INSERT INTO `blog_student` VALUES('895792','韩子烨','男','130185199503133411','河北省石家庄市新华区新华路591号1栋3单元502号','北京市顺义区京顺路99号学生公寓5号楼163','1015090886','13284443519','升级','本科','唐山师范学院','计算机科学与技术','宋婉晴','2018-06-26','22','1','0');
INSERT INTO `blog_student` VALUES('896079','赵风济','男','211121198906041815','辽宁省大洼县平安乡新立村四组4-4','北京市顺义区京顺路99号学生公寓5号楼221室','334851265','15040325089','升级','本科','大连海洋大学应用技术学院','计算机科学与技术','曾春苗','2014-07-01','28','1','0');
INSERT INTO `blog_student` VALUES('896556','任占飞','男','130434199310223118','河北省邯郸市魏县魏城镇紫荆花苑西区12号楼1单元302号','北京市顺义区京顺路99号学生公寓5号楼412室','951255660','15133075551','升级','大专','邯郸大学','经济管理','王卫杰','2015-07-01','24','1','1');
INSERT INTO `blog_student` VALUES('896838','樊传奇','男','413026199309107337','河南省固始县蒋集镇孙岗村湖坝组','北京市顺义区京顺路99号学生公寓5号楼412室','1249130528','13552343692','升级','高中','固始慈济高中','无','刘璐 ','2010-06-10','24','1','0');
INSERT INTO `blog_student` VALUES('896984','杨超','男','372901199504238015','河北省三河市燕郊开发区大街同忆首歌汇福苑3号楼1单元041室','北京市顺义区京顺路99号学生公寓5号楼215','472391841','18603161304','升级','大专','华北理工大学','临床医学','孔德秀','2016-06-17','22','1','0');
INSERT INTO `blog_student` VALUES('897055','张鸿','男','211322199311152278','辽宁省朝阳市建平县海棠村','北京市顺义区京顺路99号学生公寓5号楼412室','531897938','13664268853','升级','本科','大连财经学院','会计','王芮','2017-07-09','24','1','0');
INSERT INTO `blog_student` VALUES('899740','张明哲','女','410504199310241521','河南省安阳市殷都区文峰大道570号院','北京市顺义区马坡白各庄如家公寓','404150826','17600327084','新生','本科','湖南邵阳学院','计算机','刘文娟','2017-07-01','24','1','0');
--
-- 表的结构blog_user
--
DROP TABLE IF EXISTS `blog_user`;
CREATE TABLE `blog_user` (
`user_id` int(11) NOT NULL AUTO_INCREMENT,
`user_name` varchar(40) DEFAULT NULL,
`user_nickname` varchar(40) DEFAULT NULL,
PRIMARY KEY (`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
--
-- 转存表中的数据 blog_user
--
INSERT INTO `blog_user` VALUES('1','[email protected]','冒蓝光的哒哒哒');