-
Notifications
You must be signed in to change notification settings - Fork 3
Expand file tree
/
Copy pathnotes.sql
More file actions
141 lines (129 loc) · 99.3 KB
/
notes.sql
File metadata and controls
141 lines (129 loc) · 99.3 KB
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
/*
Navicat MySQL Data Transfer
Source Server : 本地
Source Server Version : 50529
Source Host : localhost:3306
Source Database : notes
Target Server Type : MYSQL
Target Server Version : 50529
File Encoding : 65001
Date: 2024-01-06 15:28:02
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for category
-- ----------------------------
DROP TABLE IF EXISTS `category`;
CREATE TABLE `category` (
`id` int(25) NOT NULL AUTO_INCREMENT,
`name` varchar(30) NOT NULL,
`counts` varchar(10) NOT NULL,
`owner` varchar(50) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=29 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of category
-- ----------------------------
INSERT INTO `category` VALUES ('4', 'c', '4', '');
INSERT INTO `category` VALUES ('5', '', '3', '');
INSERT INTO `category` VALUES ('6', '', '4', '');
INSERT INTO `category` VALUES ('7', '', '5', '');
INSERT INTO `category` VALUES ('8', '', '3', '');
INSERT INTO `category` VALUES ('14', '环境配置', '7', '1126089177@qq.com');
INSERT INTO `category` VALUES ('15', 'PHP开发经验', '10', '1126089177@qq.com');
INSERT INTO `category` VALUES ('17', '加密与解密', '2', '1126089177@qq.com');
INSERT INTO `category` VALUES ('18', 'JavaScript', '2', '1126089177@qq.com');
INSERT INTO `category` VALUES ('19', 'Linux', '5', '1126089177@qq.com');
INSERT INTO `category` VALUES ('20', 'ajax', '1', '1126089177@qq.com');
INSERT INTO `category` VALUES ('22', 'laravel', '1', '1126089177@qq.com');
INSERT INTO `category` VALUES ('23', 'Git', '1', '1126089177@qq.com');
INSERT INTO `category` VALUES ('27', '123123', '1', 'testbugs@vip.qq.com');
INSERT INTO `category` VALUES ('28', '测试分类', '', '11111111@qq.com');
-- ----------------------------
-- Table structure for manager
-- ----------------------------
DROP TABLE IF EXISTS `manager`;
CREATE TABLE `manager` (
`id` int(50) NOT NULL AUTO_INCREMENT,
`name` varchar(15) NOT NULL,
`password` varchar(300) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of manager
-- ----------------------------
INSERT INTO `manager` VALUES ('1', 'root', 'eyJpdiI6InMyVnVsb3lKVUtHQnAydFwvblh5VlNnPT0iLCJ2YWx1ZSI6Im1ybU5jTGI4Tm0rUiszWUhKcXZnNEE9PSIsIm1hYyI6ImFkNTE2OTQ1OGRlY2RlMTIxMDAwMTkyYjhjZTkwYTVkNzYwMzEwMTllMWM5Y2ZlMjFmOGNhYTY4OTIyMjkwOGIifQ==');
-- ----------------------------
-- Table structure for usernotes
-- ----------------------------
DROP TABLE IF EXISTS `usernotes`;
CREATE TABLE `usernotes` (
`id` int(20) NOT NULL AUTO_INCREMENT,
`title` varchar(60) NOT NULL,
`content` text NOT NULL,
`date` varchar(20) NOT NULL,
`class` varchar(15) NOT NULL,
`owner` varchar(60) NOT NULL,
`intrash` varchar(5) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=74 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of usernotes
-- ----------------------------
INSERT INTO `usernotes` VALUES ('2', '学习Java', 'hellolllllll', '1499514580', 'common', '15813246678@163.com', '0');
INSERT INTO `usernotes` VALUES ('30', 'phpexcel不能输出标点符号以及数字开头的字符串问题', '<p style="font-size:14px;">\r\n 用一下这句代码解决：\r\n</p>\r\n<p style="font-size:14px;">\r\n $objSheet-&gt;setCellValueExplicit($zm.$j,$row1[$res[3][$i]],PHPExcel_Cell_DataType::TYPE_STRING);\r\n</p>\r\n<div style="font-size:14px;">\r\n 填充单元格的值以及设置单元格为纯文本格式！\r\n</div>', '1499952689', 'PHP开发经验', '1126089177@qq.com', '0');
INSERT INTO `usernotes` VALUES ('31', 'mysql不支持插入双号解决办法', '<p>\r\n <span style="font-size:16px;">使用htmlspecialchars函数进行转义，需添加第二个参数：</span>\r\n</p>\r\n<p>\r\n <span style="font-size:16px;">htmlspecialchars($htmlData,ENT_QUOTES);</span>\r\n</p>', '1499952746', 'PHP开发经验', '1126089177@qq.com', '0');
INSERT INTO `usernotes` VALUES ('32', 'mysql常用语句', '<p>\n <span style="font-size:14px;">1连接数据库</span> \n</p>\n<p>\n <span style="font-size:14px;">mysql -uroot -p</span> \n</p>\n<p>\n <span style="font-size:14px;">2创建数据库</span> \n</p>\n<p>\n <span style="font-size:14px;">create database mydatabase</span><span style="font-size:14px;">&nbsp;DEFAULT CHARSET utf8 COLLATE utf8_general_ci;</span> \n</p>\n<p>\n <span style="font-size:14px;">3创建表</span> \n</p>\n<p>\n <span style="font-size:14px;">create table `mytable`(`id` int(10) auto_increment primary key,`name` varchar(20) not null)ENGINE=InnoDB CHARACTER SET utf8 COLLATE utf8_general _ci;</span> \n</p>\n<p>\n <span style="font-size:14px;">4备份数据库</span> \n</p>\n<p>\n <span style="font-size:14px;">mysqldump -hlocalhost -uroot -p123456 mydatabase &gt; mydatabase.sql;</span> \n</p>\n<p>\n <span style="font-size:14px;">5导入sql数据</span> \n</p>\n<p>\n <span style="font-size:14px;">use database</span> \n</p>\n<p>\n <span style="font-size:14px;">source mydatabase.sql;</span> \n</p>\n<p>\n <span style="font-size:14px;">6删除表</span> \n</p>\n<p>\n <span style="font-size:14px;">drop mytable;</span> \n</p>\n<p>\n <span style="font-size:14px;">7清空表</span> \n</p>\n<p>\n <span style="font-size:14px;">delete from mytable;</span> \n</p>\n<p>\n 8查看表结构\n</p>\n<p>\n desc mytable\n</p>\n<div>\n <br />\n</div>', '1499952790', 'PHP开发经验', '1126089177@qq.com', '0');
INSERT INTO `usernotes` VALUES ('33', '上传文件时出现空白', '<p>\r\n <span style="font-size:16px;">解决办法：</span>\r\n</p>\r\n<p>\r\n <span style="font-size:16px;">需要在form标签添加enctype="multipart/form-data"</span>\r\n</p>', '1499952893', 'PHP开发经验', '1126089177@qq.com', '0');
INSERT INTO `usernotes` VALUES ('34', 'php出现500错误，但不提示具体错误解决办法', '<p>\n <span style="font-size:16px;">deepin 和debian系统下找到</span><span style="font-size:16px;">/etc/php5/apache2/php.ini文件，然后将相关行修改为</span> \n</p>\n<p>\n <span style="font-size:16px;">error_reporting = E_ALL &amp; ~E_DEPRECATED &amp; ~E_STRICT</span> \n</p>\n<p>\n <span style="font-size:16px;">display_errors = On</span> \n</p>', '1499952937', 'PHP开发经验', '1126089177@qq.com', '0');
INSERT INTO `usernotes` VALUES ('35', 'php分页类', '<span style="font-size:16px;">class Page</span><br />\r\n<p>\r\n <span style="font-size:16px;">{</span>\r\n</p>\r\n<p>\r\n <span style="font-size:16px;">//第一个参数为传入的页码</span>\r\n</p>\r\n<p>\r\n <span style="font-size:16px;">//第二个参数为每页显示的数量</span>\r\n</p>\r\n<p>\r\n <span style="font-size:16px;">//第三个参数为数据的数量</span>\r\n</p>\r\n<span style="font-size:16px;">&nbsp; &nbsp; public function getLimit($page,$pagesize, $datanum)</span><br />\r\n<span style="font-size:16px;">&nbsp; &nbsp; {</span><br />\r\n<span style="font-size:16px;">&nbsp; &nbsp; &nbsp; &nbsp; $page_size = $pagesize;</span><br />\r\n<span style="font-size:16px;">&nbsp; &nbsp; &nbsp; &nbsp; $totalnums = $datanum;</span><br />\r\n<span style="font-size:16px;">&nbsp; &nbsp; &nbsp; &nbsp; if ($page &lt; 1 || !is_numeric($page)) {</span><br />\r\n<span style="font-size:16px;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $page = 1;</span><br />\r\n<span style="font-size:16px;">&nbsp; &nbsp; &nbsp; &nbsp; }</span><br />\r\n<span style="font-size:16px;">&nbsp; &nbsp; &nbsp; &nbsp; if ($totalnums == 0) {</span><br />\r\n<span style="font-size:16px;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $limit = "";</span><br />\r\n<span style="font-size:16px;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $last_page = $page-1;</span><br />\r\n<span style="font-size:16px;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $next_page = $page+1;</span><br />\r\n<span style="font-size:16px;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $totalpages = 0;</span><br />\r\n<span style="font-size:16px;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; return array("limit"=&gt;$limit,"last_page"=&gt;$last_page,"next_page"=&gt;$next_page,"total_pages"=&gt;$totalpages);</span><br />\r\n<span style="font-size:16px;">&nbsp; &nbsp; &nbsp; &nbsp; } else {</span><br />\r\n<span style="font-size:16px;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $totalpages = ceil($totalnums / $page_size);</span><br />\r\n<span style="font-size:16px;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if ($page &gt; $totalpages) {</span><br />\r\n<span style="font-size:16px;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $page = $totalpages;</span><br />\r\n<span style="font-size:16px;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }</span><br />\r\n<span style="font-size:16px;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $startindex = ($page - 1) * $page_size;</span><br />\r\n<span style="font-size:16px;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $limit = "limit {$startindex},$page_size";</span><br />\r\n<span style="font-size:16px;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $last_page = $page-1;</span><br />\r\n<span style="font-size:16px;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $next_page = $page+1;</span><br />\r\n<span style="font-size:16px;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; return array("limit"=&gt;$limit,"last_page"=&gt;$last_page,"next_page"=&gt;$next_page,"total_pages"=&gt;$totalpages);</span><br />\r\n<span style="font-size:16px;">&nbsp; &nbsp; &nbsp; &nbsp; }</span><br />\r\n<span style="font-size:16px;">&nbsp; &nbsp; }</span><br />\r\n<p>\r\n <span style="font-size:16px;">}</span>\r\n</p>\r\n<p>\r\n <span style="font-size:16px;">//调用getlimit()函数将获得查询数据库的limitl,页码的上一页和下一页以及总页数</span>\r\n</p>\r\n<div>\r\n <br />\r\n</div>\r\n<span style="font-size:16px;"></span>', '1499952962', 'PHP开发经验', '1126089177@qq.com', '0');
INSERT INTO `usernotes` VALUES ('36', 'ajax上传文件并实时反馈', '<span style="font-size:16px;font-family:SimSun;">//利用formdata上传文件</span><br />\n<span style="font-size:16px;font-family:SimSun;">function upload() {</span><br />\n<span style="font-size:16px;font-family:SimSun;">&nbsp; &nbsp; //检查是否已经选择文件</span><br />\n<span style="font-size:16px;font-family:SimSun;">&nbsp; &nbsp; var str = document.getElementById(\'file\').value.length;</span><br />\n<span style="font-size:16px;font-family:SimSun;">&nbsp; &nbsp; if(str==0){</span><br />\n<span style="font-size:16px;font-family:SimSun;">&nbsp; &nbsp; &nbsp; &nbsp; alert("您没有选择任何文件,请点击“选择文件”进行选取！");</span><br />\n<span style="font-size:16px;font-family:SimSun;">&nbsp; &nbsp; &nbsp; &nbsp; return false;</span><br />\n<span style="font-size:16px;font-family:SimSun;">&nbsp; &nbsp; }else{</span><br />\n<span style="font-size:16px;font-family:SimSun;">&nbsp; &nbsp; &nbsp; &nbsp; //创建formdata对象</span><br />\n<span style="font-size:16px;font-family:SimSun;">&nbsp; &nbsp; &nbsp; &nbsp; var fd = new FormData();</span><br />\n<span style="font-size:16px;font-family:SimSun;">&nbsp; &nbsp; &nbsp; &nbsp; fd.append("file",$("#file")[0].files[0]);</span><br />\n<span style="font-size:16px;font-family:SimSun;">&nbsp; &nbsp; &nbsp; &nbsp; var xhr = new XMLHttpRequest();</span><br />\n<span style="font-size:16px;font-family:SimSun;">&nbsp; &nbsp; &nbsp; &nbsp; //文件传输时事件</span><br />\n<span style="font-size:16px;font-family:SimSun;">&nbsp; &nbsp; &nbsp; &nbsp; xhr.upload.onprogress = function (event) {</span><br />\n<span style="font-size:16px;font-family:SimSun;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if(event.lengthComputable){</span><br />\n<span style="font-size:16px;font-family:SimSun;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; var percent = Math.round(event.loaded*100 / event.total);</span><br />\n<span style="font-size:16px;font-family:SimSun;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; console.log(\'%d%\',percent);</span><br />\n<span style="font-size:16px;font-family:SimSun;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $("#progress").css("width",percent+"%");</span><br />\n<span style="font-size:16px;font-family:SimSun;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $("#progress").text(percent+"%");</span><br />\n<span style="font-size:16px;font-family:SimSun;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }</span><br />\n<span style="font-size:16px;font-family:SimSun;">&nbsp; &nbsp; &nbsp; &nbsp; };</span><br />\n<span style="font-size:16px;font-family:SimSun;">&nbsp; &nbsp; &nbsp; &nbsp; //文件开始传输时事件</span><br />\n<span style="font-size:16px;font-family:SimSun;">&nbsp; &nbsp; &nbsp; &nbsp; xhr.onloadstart = function (event) {</span><br />\n<span style="font-size:16px;font-family:SimSun;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $(\'#mymodal\').modal("show");</span><br />\n<span style="font-size:16px;font-family:SimSun;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $("#closeprogress").hide();</span><br />\n<span style="font-size:16px;font-family:SimSun;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $("#stop").one("click",function () {</span><br />\n<span style="font-size:16px;font-family:SimSun;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; xhr.abort();</span><br />\n<span style="font-size:16px;font-family:SimSun;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; })</span><br />\n<span style="font-size:16px;font-family:SimSun;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; loading(false);</span><br />\n<span style="font-size:16px;font-family:SimSun;">&nbsp; &nbsp; &nbsp; &nbsp; };</span><br />\n<span style="font-size:16px;font-family:SimSun;">&nbsp; &nbsp; &nbsp; &nbsp; //文件上传完成时事件</span><br />\n<span style="font-size:16px;font-family:SimSun;">&nbsp; &nbsp; &nbsp; &nbsp; xhr.onload = function (event) {</span><br />\n<span style="font-size:16px;font-family:SimSun;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $(".info").text(xhr.responseText);</span><br />\n<span style="font-size:16px;font-family:SimSun;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $("#closeprogress").show();</span><br />\n<span style="font-size:16px;font-family:SimSun;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $("#stop").hide();</span><br />\n<span style="font-size:16px;font-family:SimSun;">&nbsp; &nbsp; &nbsp; &nbsp; };</span><br />\n<br />\n<span style="font-size:16px;font-family:SimSun;">&nbsp; &nbsp; &nbsp; &nbsp; //发生错误时触发的事件</span><br />\n<span style="font-size:16px;font-family:SimSun;">&nbsp; &nbsp; &nbsp; &nbsp; xhr.onerror = function (event) {</span><br />\n<span style="font-size:16px;font-family:SimSun;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $(".info").text("上传发生错误，请重试！");</span><br />\n<span style="font-size:16px;font-family:SimSun;">&nbsp; &nbsp; &nbsp; &nbsp; }</span><br />\n<span style="font-size:16px;font-family:SimSun;">&nbsp; &nbsp; &nbsp; &nbsp; //ajax被取消时触发的事件</span><br />\n<span style="font-size:16px;font-family:SimSun;">&nbsp; &nbsp; &nbsp; &nbsp; xhr.onabort = function (event) {</span><br />\n<span style="font-size:16px;font-family:SimSun;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $(".info").text("用户已终止");</span><br />\n<span style="font-size:16px;font-family:SimSun;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $("#closeprogress").show();</span><br />\n<span style="font-size:16px;font-family:SimSun;">&nbsp; &nbsp; &nbsp; &nbsp; }</span><br />\n<span style="font-size:16px;font-family:SimSun;">&nbsp; &nbsp; &nbsp; &nbsp; //发送请求</span><br />\n<span style="font-size:16px;font-family:SimSun;">&nbsp; &nbsp; &nbsp; &nbsp; xhr.open("post","receive.php",true);</span><br />\n<span style="font-size:16px;font-family:SimSun;">&nbsp; &nbsp; &nbsp; &nbsp; xhr.send(fd);</span><br />\n<span style="font-size:16px;font-family:SimSun;">&nbsp; &nbsp; }</span><br />\n<span style="font-size:16px;font-family:SimSun;">}</span>', '1499953126', 'PHP开发经验', '1126089177@qq.com', '0');
INSERT INTO `usernotes` VALUES ('37', '使用get方法在url上传递数据需要注意的问题', '<p>\r\n <span style="font-size:14px;">1传输时尽量使用单词和数字，避免使用#$*+等危险符号，这些符号也会被自动转义。</span>\r\n</p>\r\n<p>\r\n <span style="font-size:14px;">2尽量不使用中文，因为中文解密后容易出现乱码。</span>\r\n</p>\r\n<p>\r\n <span style="font-size:14px;">3如果要使用到含中英文的文件名，可以通过传递相关数据的id，然后通过id读出文件名，然后拿来使用。</span>\r\n</p>', '1499953293', 'PHP开发经验', '1126089177@qq.com', '0');
INSERT INTO `usernotes` VALUES ('38', 'edusoho网校系统在winserver2008安装时提示某个文件缺失问题', '<p>\r\n <span style="font-size:16px;">原因：window server2008压缩软件版本太久，解压之后导致某些文件缺失。</span>\r\n</p>\r\n<p>\r\n <span style="font-size:16px;">解决办法：更新压缩工具或者更换压缩工具进行解压。</span>\r\n</p>', '1499953323', 'PHP开发经验', '1126089177@qq.com', '0');
INSERT INTO `usernotes` VALUES ('39', 'Centos6.5配置php+mysql+php过程', '<p>\r\n <br />\r\n</p>\r\n<p style="color:#333333;font-family:tahoma, 宋体;font-size:14px;text-align:justify;background-color:#FAFAFC;">\r\n <strong><span style="background-color:#FFFFFF;">centos 6.5系统安装配置LAMP(Apache+PHP5+MySQL)服务器环境</span></strong>\r\n</p>\r\n<p style="color:#333333;font-family:tahoma, 宋体;font-size:14px;text-align:justify;background-color:#FAFAFC;">\r\n <strong><span style="background-color:#FFFFFF;">准备篇：</span></strong>\r\n</p>\r\n<p style="color:#333333;font-family:tahoma, 宋体;font-size:14px;text-align:justify;background-color:#FAFAFC;">\r\n <span style="background-color:#FFFFFF;">1、配置防火墙，开启80端口、3306端口</span><br />\r\n<span style="background-color:#FFFFFF;">vi /etc/sysconfig/iptables</span><br />\r\n<span style="background-color:#FFFFFF;">-A INPUT -m state --state NEW -m tcp -p tcp --dport 80 -j ACCEPT #允许80端口通过防火墙</span><br />\r\n<span style="background-color:#FFFFFF;">-A INPUT -m state --state NEW -m tcp -p tcp --dport 3306 -j ACCEPT #允许3306端口通过防火墙</span>\r\n</p>\r\n<p style="color:#333333;font-family:tahoma, 宋体;font-size:14px;text-align:justify;background-color:#FAFAFC;">\r\n <span style="background-color:#FFFFFF;">/etc/init.d/iptables restart #重启防火墙使配置生效</span>\r\n</p>\r\n<p style="color:#333333;font-family:tahoma, 宋体;font-size:14px;text-align:justify;background-color:#FAFAFC;">\r\n <span style="background-color:#FFFFFF;">2、关闭SELINUX</span><br />\r\n<span style="background-color:#FFFFFF;">vi /etc/selinux/config</span><br />\r\n<span style="background-color:#FFFFFF;">#SELINUX=enforcing #注释掉</span><br />\r\n<span style="background-color:#FFFFFF;">#SELINUXTYPE=targeted #注释掉</span><br />\r\n<span style="background-color:#FFFFFF;">SELINUX=disabled #增加</span><br />\r\n<span style="background-color:#FFFFFF;">:wq!#保存退出</span><br />\r\n<span style="background-color:#FFFFFF;">shutdown -r now#重启系统</span>\r\n</p>\r\n<p style="color:#333333;font-family:tahoma, 宋体;font-size:14px;text-align:justify;background-color:#FAFAFC;">\r\n <strong><span style="background-color:#FFFFFF;">安装篇：</span></strong>\r\n</p>\r\n<p style="color:#333333;font-family:tahoma, 宋体;font-size:14px;text-align:justify;background-color:#FAFAFC;">\r\n <span style="background-color:#FFFFFF;">一、安装Apache</span><br />\r\n<span style="background-color:#FFFFFF;">yum install httpd #根据提示，输入Y安装即可成功安装</span><br />\r\n<span style="background-color:#FFFFFF;">/etc/init.d/httpd start#启动Apache</span><br />\r\n<span style="background-color:#FFFFFF;">备注：Apache启动之后会提示错误：</span><br />\r\n<span style="background-color:#FFFFFF;">正在启动 httpd:httpd: Could not reliably determine the server's fully qualif domain name, using ::1 for ServerName</span><br />\r\n<strong><span style="background-color:#FFFFFF;">解决办法：</span></strong><br />\r\n<span style="background-color:#FFFFFF;">vi /etc/httpd/conf/httpd.conf #编辑</span><br />\r\n<span style="background-color:#FFFFFF;">找到 #ServerName www.example.com:80</span><br />\r\n<span style="background-color:#FFFFFF;">修改为 ServerName www.jbaobao.net:80 #这里设置为你自己的域名，如果没有域名，可以设置为localhost</span><br />\r\n<span style="background-color:#FFFFFF;">:wq! #保存退出</span><br />\r\n<span style="background-color:#FFFFFF;">chkconfig httpd on #设为开机启动</span><br />\r\n<span style="background-color:#FFFFFF;">/etc/init.d/httpd restart #重启Apache</span>\r\n</p>\r\n<p style="color:#333333;font-family:tahoma, 宋体;font-size:14px;text-align:justify;background-color:#FAFAFC;">\r\n <span style="background-color:#FFFFFF;">二、安装MySQL</span>\r\n</p>\r\n<p style="color:#333333;font-family:tahoma, 宋体;font-size:14px;text-align:justify;background-color:#FAFAFC;">\r\n <span style="background-color:#FFFFFF;">1、安装MySQL</span><br />\r\n<span style="background-color:#FFFFFF;">yum install&nbsp;mysql&nbsp;mysql-server #询问是否要安装，输入Y即可自动安装,直到安装完成</span><br />\r\n<span style="background-color:#FFFFFF;">/etc/init.d/mysqld start #启动MySQL</span><br />\r\n<span style="background-color:#FFFFFF;">chkconfig mysqld on #设为开机启动</span><br />\r\n<span style="background-color:#FFFFFF;">cp /usr/share/mysql/my-medium.cnf /etc/my.cnf #拷贝配置文件（注意：如果/etc目录下面默认有一个my.cnf，直接覆盖即可）</span>\r\n</p>\r\n<p style="color:#333333;font-family:tahoma, 宋体;font-size:14px;text-align:justify;background-color:#FAFAFC;">\r\n <span style="background-color:#FFFFFF;">2、为root账户设置密码</span><br />\r\n<span style="background-color:#FFFFFF;">mysql_secure_installation</span><br />\r\n<span style="background-color:#FFFFFF;">回车，根据提示输入Y</span><br />\r\n<span style="background-color:#FFFFFF;">输入2次密码，回车</span><br />\r\n<span style="background-color:#FFFFFF;">根据提示一路输入Y</span><br />\r\n<span style="background-color:#FFFFFF;">最后出现：Thanks for using MySQL!</span><br />\r\n<span style="background-color:#FFFFFF;">MySql密码设置完成，重新启动 MySQL：</span><br />\r\n<span style="background-color:#FFFFFF;">/etc/init.d/mysqld restart #重启</span><br />\r\n<span style="background-color:#FFFFFF;">/etc/init.d/mysqld stop #停止</span><br />\r\n<span style="background-color:#FFFFFF;">/etc/init.d/mysqld start #启动</span>\r\n</p>\r\n<p style="color:#333333;font-family:tahoma, 宋体;font-size:14px;text-align:justify;background-color:#FAFAFC;">\r\n <span style="background-color:#FFFFFF;">三、安装PHP5</span>\r\n</p>\r\n<p style="color:#333333;font-family:tahoma, 宋体;font-size:14px;text-align:justify;background-color:#FAFAFC;">\r\n <span style="background-color:#FFFFFF;">1、安装PHP5</span>\r\n</p>\r\n<p style="color:#333333;font-family:tahoma, 宋体;font-size:14px;text-align:justify;background-color:#FAFAFC;">\r\n <span style="background-color:#FFFFFF;">系统运维 温馨提醒：qihang01原创内容版权所有,转载请注明出处及原文链接</span><br />\r\n<span style="background-color:#FFFFFF;">yum install php #根据提示输入Y直到安装完成</span>\r\n</p>\r\n<p style="color:#333333;font-family:tahoma, 宋体;font-size:14px;text-align:justify;background-color:#FAFAFC;">\r\n <span style="background-color:#FFFFFF;">2、安装PHP组件，使 PHP5 支持 MySQL</span><br />\r\n<span style="background-color:#FFFFFF;">yum install php-mysql php-gd libjpeg* php-imap php-ldap php-odbc php-pear php-xml php-xmlrpc php-mbstring php-mcrypt php-bcmath php-mhash libmcrypt #这里选择以上安装包进行安装，根据提示输入Y回车</span><br />\r\n<span style="background-color:#FFFFFF;">/etc/init.d/mysqld restart #重启MySql</span><br />\r\n<span style="background-color:#FFFFFF;">/etc/init.d/httpd restart #重启Apche</span>\r\n</p>\r\n<p style="color:#333333;font-family:tahoma, 宋体;font-size:14px;text-align:justify;background-color:#FAFAFC;">\r\n <strong><span style="background-color:#FFFFFF;">配置篇</span></strong>\r\n</p>\r\n<p style="color:#333333;font-family:tahoma, 宋体;font-size:14px;text-align:justify;background-color:#FAFAFC;">\r\n <span style="background-color:#FFFFFF;">一、Apache配置</span><br />\r\n<span style="background-color:#FFFFFF;">vi /etc/httpd/conf/httpd.conf #编辑文件</span><br />\r\n<span style="background-color:#FFFFFF;">ServerTokens OS #在44行 修改为：ServerTokens Prod （在出现错误页的时候不显示服务器操作系统的名称）</span><br />\r\n<span style="background-color:#FFFFFF;">ServerSignature On #在536行 修改为：ServerSignature Off （在错误页中不显示Apache的版本）</span><br />\r\n<span style="background-color:#FFFFFF;">Options Indexes FollowSymLinks #在331行 修改为：Options Includes ExecCGI FollowSymLinks（允许服务器执行CGI及SSI，禁止列出目录）</span><br />\r\n<span style="background-color:#FFFFFF;">#AddHandler cgi-script .cgi #在796行 修改为：AddHandler cgi-script .cgi .pl （允许扩展名为.pl的CGI脚本运行）</span><br />\r\n<span style="background-color:#FFFFFF;">AllowOverride None #在338行 修改为：AllowOverride All （允许.htaccess）</span><br />\r\n<span style="background-color:#FFFFFF;">AddDefaultCharset UTF-8 #在759行 修改为：AddDefaultCharset GB2312 （添加GB2312为默认编码）</span><br />\r\n<span style="background-color:#FFFFFF;"> Options Indexes MultiViews FollowSymLinks #在554行 修改为 Options MultiViews FollowSymLinks（不在浏览器上显示树状目录结构）</span><br />\r\n<span style="background-color:#FFFFFF;">DirectoryIndex index.html index.html.var #在402行 修改为：DirectoryIndex index.html index.htm Default.html Default.htm index.php Default.php index.html.var （设置默认首页文件，增加index.php）</span><br />\r\n<span style="background-color:#FFFFFF;">KeepAlive Off #在76行 修改为：KeepAlive On （允许程序性联机）</span><br />\r\n<span style="background-color:#FFFFFF;">MaxKeepAliveRequests 100 #在83行 修改为：MaxKeepAliveRequests 1000 （增加同时连接数）</span><br />\r\n<span style="background-color:#FFFFFF;">:wq! #保存退出</span><br />\r\n<span style="background-color:#FFFFFF;">/etc/init.d/httpd restart#重启</span><br />\r\n<span style="background-color:#FFFFFF;">系统运维 温馨提醒：qihang01原创内容版权所有,转载请注明出处及原文链接</span><br />\r\n<span style="background-color:#FFFFFF;">rm -f /etc/httpd/conf.d/welcome.conf /var/www/error/noindex.html #删除默认测试页</span>\r\n</p>\r\n<p style="color:#333333;font-family:tahoma, 宋体;font-size:14px;text-align:justify;background-color:#FAFAFC;">\r\n <span style="background-color:#FFFFFF;">二、php配置</span><br />\r\n<span style="background-color:#FFFFFF;">vi /etc/php.ini #编辑</span><br />\r\n<span style="background-color:#FFFFFF;">date.timezone = PRC #在946行 把前面的分号去掉，改为date.timezone = PRC</span><br />\r\n<span style="background-color:#FFFFFF;">disable_functions = passthru,exec,system,chroot,scandir,chgrp,chown,shell_exec,proc_open,proc_get_status,ini_alter,ini_alter,ini_restore,dl,openlog,syslog,readlink,symlink,popepassthru,stream_socket_server,escapeshellcmd,dll,popen,disk_free_space,checkdnsrr,checkdnsrr,getservbyname,getservbyport,disk_total_space,posix_ctermid,posix_get_last_error,posix_getcwd, posix_getegid,posix_geteuid,posix_getgid, posix_getgrgid,posix_getgrnam,posix_getgroups,posix_getlogin,posix_getpgid,posix_getpgrp,posix_getpid, posix_getppid,posix_getpwnam,posix_getpwuid, posix_getrlimit, posix_getsid,posix_getuid,posix_isatty, posix_kill,posix_mkfifo,posix_setegid,posix_seteuid,posix_setgid, posix_setpgid,posix_setsid,posix_setuid,posix_strerror,posix_times,posix_ttyname,posix_uname</span><br />\r\n<span style="background-color:#FFFFFF;">#在386行 列出PHP可以禁用的函数，如果某些程序需要用到这个函数，可以删除，取消禁用。</span><br />\r\n<span style="background-color:#FFFFFF;">expose_php = Off #在432行 禁止显示php版本的信息</span><br />\r\n<span style="background-color:#FFFFFF;">magic_quotes_gpc = On #在745行 打开magic_quotes_gpc来防止SQL注入</span><br />\r\n<span style="background-color:#FFFFFF;">short_open_tag = ON #在229行支持php短标签</span><br />\r\n<span style="background-color:#FFFFFF;">open_basedir = .:/tmp/ #在380行 设置表示允许访问当前目录(即PHP脚本文件所在之目录)和/tmp/目录,可以防止php木马跨站,如果改了之后安装程序有问题，可以注销此行，或者直接写上程序的目录/data/www.osyunwei.com/:/tmp/</span><br />\r\n<span style="background-color:#FFFFFF;">:wq! #保存退出</span><br />\r\n<span style="background-color:#FFFFFF;">/etc/init.d/mysqld restart #重启MySql</span><br />\r\n<span style="background-color:#FFFFFF;">/etc/init.d/httpd restart #重启Apche</span>\r\n</p>\r\n<p style="color:#333333;font-family:tahoma, 宋体;font-size:14px;text-align:justify;background-color:#FAFAFC;">\r\n <strong><span style="background-color:#FFFFFF;">测试篇</span></strong><br />\r\n<span style="background-color:#FFFFFF;">cd /var/www/html</span><br />\r\n<span style="background-color:#FFFFFF;">vi index.php #编辑输入下面内容</span><br />\r\n<span style="background-color:#FFFFFF;">&lt;?php</span><br />\r\n<span style="background-color:#FFFFFF;">phpinfo();</span><br />\r\n<span style="background-color:#FFFFFF;">?&gt;</span><br />\r\n<span style="background-color:#FFFFFF;">:wq! #保存退出</span><br />\r\n<span style="background-color:#FFFFFF;">在客户端浏览器输入服务器IP地址，可以看到相关的配置信息！</span>\r\n</p>\r\n<p style="color:#333333;font-family:tahoma, 宋体;font-size:14px;text-align:justify;background-color:#FAFAFC;">\r\n <span style="background-color:#FFFFFF;">&nbsp;</span>\r\n</p>\r\n<p style="color:#333333;font-family:tahoma, 宋体;font-size:14px;text-align:justify;background-color:#FAFAFC;">\r\n <strong><span style="background-color:#FFFFFF;">phpMyAdmin常见问题</span><br />\r\n</strong><span style="background-color:#FFFFFF;">1. phpmyadmin提示未开启php-mcrypt,这是因为没有安装php-mrcrpt扩展。在官方源没有php-mrcrpt扩展，请安装epel源后再yum install php-mcrypt</span>\r\n</p>\r\n<p style="color:#333333;font-family:tahoma, 宋体;font-size:14px;text-align:justify;background-color:#FAFAFC;">\r\n <span style="background-color:#FFFFFF;">2. phpmyadmin无法访问</span>\r\n</p>\r\n<p style="color:#333333;font-family:tahoma, 宋体;font-size:14px;text-align:justify;background-color:#FAFAFC;">\r\n <span style="background-color:#FFFFFF;">phpmyadmin默认只能使用http://localhost/phpmyadmin来访问，可以修改/etc/httpd/conf.d/phpmyadmin.conf中对应部分为</span><br />\r\n<span style="background-color:#FFFFFF;">&lt;Directory "/usr/share/phpmyadmin"&gt;</span><br />\r\n<span style="background-color:#FFFFFF;">Order Deny,Allow</span><br />\r\n<span style="background-color:#FFFFFF;"># Deny from all</span><br />\r\n<span style="background-color:#FFFFFF;">Allow from All</span><br />\r\n<span style="background-color:#FFFFFF;">&lt;/Directory&gt;</span><br />\r\n<span style="background-color:#FFFFFF;">不过强烈不支持这么做的，把phpmyadmin暴露了不安全</span>\r\n</p>\r\n<p style="color:#333333;font-family:tahoma, 宋体;font-size:14px;text-align:justify;background-color:#FAFAFC;">\r\n <strong><span style="background-color:#FFFFFF;">注意：</span><br />\r\n</strong><span style="background-color:#FFFFFF;">apache解析php，修改httpd.conf文件，添加</span><br />\r\n<span style="background-color:#FFFFFF;">Addtype application/x-httpd-php .php .phtml</span><br />\r\n<span style="background-color:#FFFFFF;">Addtype application/x-httpd-php-source .phps</span>\r\n</p>\r\n<p style="color:#333333;font-family:tahoma, 宋体;font-size:14px;text-align:justify;background-color:#FAFAFC;">\r\n <span style="background-color:#FFFFFF;">myql可以远程登录</span><br />\r\n<strong><span style="background-color:#FFFFFF;">设置mysql密码</span><br />\r\n</strong><span style="background-color:#FFFFFF;">mysql&gt;; USE mysql;</span><br />\r\n<span style="background-color:#FFFFFF;">mysql&gt;; UPDATE user SET Password=PASSWORD('newpassword') WHERE user='root';</span><br />\r\n<span style="background-color:#FFFFFF;">mysql&gt;; FLUSH PRIVILEGES;</span><br />\r\n<strong><span style="background-color:#FFFFFF;">1.2.3 允许远程登录</span><br />\r\n</strong><span style="background-color:#FFFFFF;">mysql -u root -p</span><br />\r\n<span style="background-color:#FFFFFF;">Enter Password: &lt;your new password&gt;</span><br />\r\n<span style="background-color:#FFFFFF;">mysql&gt;GRANT ALL PRIVILEGES ON *.* TO '用户名'@'%' IDENTIFIED BY '密码' WITH GRANT OPTION;</span><br />\r\n<span style="background-color:#FFFFFF;">完成后就能用mysql-front远程管理mysql了。</span><br />\r\n<span style="background-color:#FFFFFF;">设为开机启动</span><br />\r\n<span style="background-color:#FFFFFF;">chkconfig mysqld on</span>\r\n</p>', '1499953398', '环境配置', '1126089177@qq.com', '0');
INSERT INTO `usernotes` VALUES ('40', 'wampserver修改mysql密码', '<div style="font-size:14px;">\n <span style="font-size:16px;">2、进入控制台后，提示输入密码(不用输入任何密码，因为密码为空)，按回车键进入;</span> \n</div>\n<div style="font-size:14px;">\n <span style="font-size:16px;"> 3、输入“USE mysql;”然后回车，意思是选择mysql数据库;</span> \n</div>\n<div style="font-size:14px;">\n <span style="font-size:16px;"> 4、输入“update user set password=password("4370292301erplove") where user=\'root\';”然后回车;返回信息：</span> \n</div>\n<div style="font-size:14px;">\n <span style="font-size:16px;"> Query OK, 0 rows affected (0.00 sec)</span> \n</div>\n<div style="font-size:14px;">\n <span style="font-size:16px;"> Rows matched: 2 Changed: 0 Warnings: 0</span> \n</div>\n<div style="font-size:14px;">\n <span style="font-size:16px;"> 5、输入quit退出控制台;</span> \n</div>\n<div style="font-size:14px;">\n <span style="font-size:16px;"> 6、重启mysql服务;</span> \n</div>\n<div style="font-size:14px;">\n <span style="font-size:16px;"> 7、输入用户名、你设置定的密码，登录成功。</span> \n</div>\n<div style="font-size:14px;">\n <span style="font-size:16px;"> 这样mysql登录与密码是没问题了，但是使用phpmyadmin登录不了，提醒密码无效了，这个因为我们还有一步这完成</span> \n</div>\n<div style="font-size:14px;">\n <span style="font-size:16px;"> 这样仅仅是修改了mysql的密码，如果访问phpmyadmin，会提示你权限问题之类。找到phpmyadmin安装目录，一般是在wamp/apps/phpmyadmin/这个位置，打开config.inc.php，编辑如下几行：</span> \n</div>\n<div style="font-size:14px;">\n <span style="font-size:16px;">代码如下</span> \n</div>\n<div style="font-size:14px;">\n <span style="font-size:16px;">$cfg[\'Servers\'][$i][\'auth_type\'] = \'http\';//由config修改为http</span> \n</div>\n<div style="font-size:14px;">\n <span style="font-size:16px;">$cfg[\'Servers\'][$i][\'user\'] = \'root\';</span> \n</div>\n<div style="font-size:14px;">\n <span style="font-size:16px;">$cfg[\'Servers\'][$i][\'password\'] = \'newpassword\';</span> \n</div>\n<div style="font-size:14px;">\n <span style="font-size:16px;">$cfg[\'Servers\'][$i][\'AllowNoPassword\'] = false;</span> \n</div>', '1499953611', '环境配置', '1126089177@qq.com', '0');
INSERT INTO `usernotes` VALUES ('41', 'debian8.2安装apache2+php5.6+mysql环境', '<p>\n <span style="font-size:16px;">1安装apache2</span> \n</p>\n<p>\n <span style="font-size:16px;">apt-get install apache2</span> \n</p>\n<p>\n <span style="font-size:16px;">设置开机</span><span style="font-size:16px;">启动：s</span><span style="font-size:16px;">ystemct</span><span style="font-size:16px;">l enable apache2</span> \n</p>\n<p>\n <span style="font-size:16px;">2</span><span style="font-size:16px;">安装php5.6</span><span style="font-size:16px;">，debian8.2</span><span style="font-size:16px;">默认手动安装的</span><span style="font-size:16px;">是php5.6版本</span> \n</p>\n<p>\n <span style="font-size:16px;">apt</span><span style="font-size:16px;">-get i</span><span style="font-size:16px;">nstall&nbsp;</span><span style="font-size:16px;">php5</span> \n</p>\n<p>\n <span style="font-size:16px;">apt-get install&nbsp;<span style="color:#333333;font-family:&quot;font-size:14px;background-color:#FFFFFF;">libapache2-mod-php5</span></span>\n</p>\n<p>\n <span style="font-size:16px;">3安装mysql</span> \n</p>\n<p>\n <span style="font-size:16px;">apt-get install mysql-server</span> \n</p>\n<p>\n <span style="font-size:16px;">在弹出的界面中输入需要设置的密码</span> \n</p>\n<p>\n <span style="font-size:16px;">设置开机启动：systemctl enable mysql</span> \n</p>\n<p>\n <span style="font-size:16px;">4安装php5-mysql php5-curl扩展</span> \n</p>\n<p>\n <span style="font-size:16px;">apt-get install php5-mysql</span> \n</p>\n<p>\n <span style="font-size:16px;">apt-get install php5-curl</span> \n</p>\n<p>\n <span style="font-size:16px;">最后重启apache2进行测试是否配置成功</span> \n</p>', '1500032700', '环境配置', '1126089177@qq.com', '0');
INSERT INTO `usernotes` VALUES ('42', 'centos6.5下apache配置https', '<p>\r\n <span style="font-size:16px;">1安装ssl_mod</span>\r\n</p>\r\n<p>\r\n <span style="font-size:16px;">默认不开启ssl扩展,需要输入命令yum install -y ssl_mod 来安装</span>\r\n</p>\r\n<p>\r\n <span style="font-size:16px;">2申请ssl证书,以腾讯云为例</span>\r\n</p>\r\n<p>\r\n <span style="font-size:16px;">将申请到的三个文件:1_root_bundle.crt&nbsp; 2_www.aibasil.cn.crt&nbsp; 3_www.aibasil.cn.key复制到/var/www/ssl目录</span>\r\n</p>\r\n<p>\r\n <span style="font-size:16px;">3编辑/etc/httpd/conf.d/ssl.conf文件,将相应的行修改为如下所示</span>\r\n</p>\r\n<p>\r\n <span style="font-size:16px;">&lt;VirtualHost _default_:443&gt;</span><br />\r\n<span style="background-color:#FFE500;"></span><span style="font-size:16px;">DocumentRoot "/var/www/html"</span><br />\r\n<strong><span style="background-color:#FFE500;"></span></strong><span style="font-size:16px;">ServerName www.aibasil.cn</span><br />\r\n<span style="font-size:16px;">SSLCertificateFile&nbsp;</span><span style="background-color:#FFE500;font-size:16px;">/var/www/ssl/2_www.aibasil.cn.crt</span><br />\r\n<span style="font-size:16px;">SSLCertificateKeyFile&nbsp;</span><span style="background-color:#FFE500;font-size:16px;">/var/www/ssl/3_www.aibasil.cn.key</span>\r\n</p>\r\n<p>\r\n <span style="background-color:#FFE500;"><span style="background-color:#FFFFFF;font-size:16px;">SSLCertificateChainFile</span><span style="font-size:16px;">&nbsp;/var/www/ssl/1_root_bundle.crt</span></span>\r\n</p>\r\n<p>\r\n <span style="background-color:#FFE500;"><span style="background-color:#FFFFFF;font-size:16px;">&lt;/VirtualHost&gt;</span><br />\r\n<span style="font-size:16px;">重启apache</span><br />\r\n</span>\r\n</p>', '1500032726', '环境配置', '1126089177@qq.com', '0');
INSERT INTO `usernotes` VALUES ('43', 'apache2 开启rewrite功能', '<p>\r\n <span style="font-size:16px;">在配置laravel时,发现直接输入域名访问(不带index.php后缀)时,url函数失效,原因是没有开启apache2 的rewrite模块。</span>\r\n</p>\r\n<p>\r\n <span style="font-size:16px;">于是找到了apache2开启该模块的方法，在deepin下，启动终端切换到root模式，然后输入以下命令进行开启：</span>\r\n</p>\r\n<p>\r\n <span style="font-size:16px;">a2enmod rewrite</span>\r\n</p>\r\n<p>\r\n <span style="font-size:16px;">然后重启apache</span>\r\n</p>\r\n<p>\r\n <span style="font-size:16px;">systemctl restart apache2</span>\r\n</p>', '1500032905', '环境配置', '1126089177@qq.com', '0');
INSERT INTO `usernotes` VALUES ('45', '公钥与密钥', '<span style="font-size:14px;"><span style="line-height:2;"></span><span style="line-height:2;">加密和认证</span></span><br />\r\n<span style="font-size:14px;line-height:2;"> 首先我们需要区分加密和认证这两个基本概念。</span><br />\r\n<span style="font-size:14px;line-height:2;"> 加密是将数据资料加密，使得非法用户即使取得加密过的资料，也无法获取正确的资料内容，所以数据加密可以保护数据，防止监听攻击。其重点在于数据的安全 性。身份认证是用来判断某个身份的真实性，确认身份后，系统才可以依不同的身份给予不同的权限。其重点在于用户的真实性。两者的侧重点是不同的。</span><br />\r\n<span style="font-size:14px;line-height:2;"> 公钥和私钥</span><br />\r\n<span style="font-size:14px;line-height:2;"> 其次我们还要了解公钥和私钥的概念和作用。</span><br />\r\n<span style="font-size:14px;line-height:2;"> 在现代密码体制中加密和解密是采用不同的密钥（公开密钥），也就是非对称密钥密码系统，每个通信方均需要两个密钥，即公钥和私钥，这两把密钥可以互为加解密。公钥是公开的，不需要保密，而私钥是由个人自己持有，并且必须妥善保管和注意保密。</span><br />\r\n<span style="font-size:14px;line-height:2;"> 公钥私钥的原则：</span><br />\r\n<span style="font-size:14px;line-height:2;">一个公钥对应一个私钥。</span><br />\r\n<span style="font-size:14px;line-height:2;">密钥对中，让大家都知道的是公钥，不告诉大家，只有自己知道的，是私钥。</span><br />\r\n<span style="font-size:14px;line-height:2;">如果用其中一个密钥加密数据，则只有对应的那个密钥才可以解密。</span><br />\r\n<span style="font-size:14px;line-height:2;">如果用其中一个密钥可以进行解密数据，则该数据必然是对应的那个密钥进行的加密。</span><br />\r\n<span style="font-size:14px;line-height:2;"> 非对称密钥密码的主要应用就是公钥加密和公钥认证，而公钥加密的过程和公钥认证的过程是不一样的，下面我就详细讲解一下两者的区别。</span><br />\r\n<span style="font-size:14px;line-height:2;"> 基于公开密钥的加密过程</span><br />\r\n<span style="font-size:14px;line-height:2;"> 比如有两个用户Alice和Bob，Alice想把一段明文通过双钥加密的技术发送给Bob，Bob有一对公钥和私钥，那么加密解密的过程如下：</span><br />\r\n<span style="font-size:14px;line-height:2;">Bob将他的公开密钥传送给Alice。</span><br />\r\n<span style="font-size:14px;line-height:2;">Alice用Bob的公开密钥加密她的消息，然后传送给Bob。</span><br />\r\n<span style="font-size:14px;line-height:2;">Bob用他的私人密钥解密Alice的消息。</span><br />\r\n<span style="font-size:14px;line-height:2;"> 上面的过程可以用下图表示，Alice使用Bob的公钥进行加密，Bob用自己的私钥进行解密。</span><br />\r\n<span style="font-size:14px;line-height:2;"> 基于公开密钥的认证过程</span><br />\r\n<span style="font-size:14px;line-height:2;"> 身份认证和加密就不同了，主要用户鉴别用户的真伪。这里我们只要能够鉴别一个用户的私钥是正确的，就可以鉴别这个用户的真伪。</span><br />\r\n<span style="font-size:14px;line-height:2;"> 还是Alice和Bob这两个用户，Alice想让Bob知道自己是真实的Alice，而不是假冒的，因此Alice只要使用私钥对文件签名发送 给Bob，Bob使用Alice的公钥对文件进行解密，如果可以解密成功，则证明Alice的私钥是正确的，因而就完成了对Alice的身份鉴别。整个身 份认证的过程如下：</span><br />\r\n<span style="font-size:14px;line-height:2;">Alice用她的私人密钥对文件加密，从而对文件签名。</span><br />\r\n<span style="font-size:14px;line-height:2;">Alice将签名的文件传送给Bob。</span><br />\r\n<span style="font-size:14px;line-height:2;">Bob用Alice的公钥解密文件，从而验证签名。</span>', '1500032979', '加密与解密', '1126089177@qq.com', '0');
INSERT INTO `usernotes` VALUES ('46', '利用clipboard.js插件实现复制内容到粘贴板', '<p>\r\n <span style="font-size:14px;">首先下载</span><span style="background-color:#E4E4FF;color:#008000;font-weight:bold;font-size:14px;">clipboard.js</span><span style="font-size:14px;">&nbsp;插件，然后<span style="background-color:#FFE500;">在html文件引入</span>，具体实现如下：</span>\r\n</p>\r\n<p>\r\n <span style="font-size:14px;"></span>\r\n</p>\r\n<pre class="prettyprint lang-html">&lt;!DOCTYPE html&gt;\r\n&lt;html lang="en"&gt;\r\n&lt;head&gt;\r\n &lt;meta charset="UTF-8"&gt;\r\n &lt;title&gt;cp&lt;/title&gt;\r\n &lt;script src="public/js/clipboard.min.js"&gt;&lt;/script&gt;\r\n&lt;/head&gt;\r\n\r\n&lt;body&gt;\r\n&lt;button class="btn" data-clipboard-target="#info"&gt;复制&lt;/button&gt;\r\n&lt;span id="info"&gt;这里的内容将被复制&lt;/span&gt;\r\n&lt;/body&gt;\r\n&lt;script type="text/javascript"&gt;\r\n //复制分享链接\r\n var clipboard = new Clipboard(".btn");\r\n clipboard.on('success', function(e) {\r\n alert("复制成功！");\r\n });\r\n\r\n clipboard.on('error', function(e) {\r\n alert("复制失败！");\r\n });\r\n&lt;/script&gt;\r\n&lt;/html&gt;</pre>\r\n<br />\r\n<p>\r\n <br />\r\n</p>', '1500033004', 'JavaScript', '1126089177@qq.com', '0');
INSERT INTO `usernotes` VALUES ('47', '利用jqueryui的拖拽和放置功能处理后保存位置的方法', '<span style="font-size:16px;"></span><span style="font-size:16px;">拖放之后利用浏览器的审查元素查看代码，然后复制整个html内容，再新建另外一个html粘贴。</span>', '1500033027', 'JavaScript', '1126089177@qq.com', '0');
INSERT INTO `usernotes` VALUES ('48', 'vim命令详解', '<h1 class="postTitle">\n <a id="cb_post_title_url" class="postTitle2" href="http://www.cnblogs.com/usergaojie/p/4583796.html">vim 命令详解</a> \n</h1>\n<div class="clear" style="font-family:Helvetica, Arial, sans-serif;background-color:#FFFFFF;">\n</div>\n<div class="postBody" style="font-size:14px;color:#444444;font-family:Helvetica, Arial, sans-serif;background-color:#FFFFFF;">\n <div id="cnblogs_post_body">\n <p>\n vi: Visual Interface 可视化接口<br />\nvim: VI iMproved VI增强版\n </p>\n <p>\n 全屏编辑器，模式化编辑器\n </p>\n <p>\n <strong>vim模式：</strong> \n </p>\n <ul>\n <li>\n 编辑模式(命令模式)\n </li>\n <li>\n 输入模式\n </li>\n <li>\n 末行模式\n </li>\n </ul>\n <p>\n <strong>模式转换：</strong> \n </p>\n <p>\n 编辑--&gt;输入：\n </p>\n<pre> i: 在当前光标所在字符的前面，转为输入模式；\n\n a: 在当前光标所在字符的后面，转为输入模式；\n\n o: 在当前光标所在行的下方，新建一行，并转为输入模式；\n\n I：在当前光标所在行的行首，转换为输入模式\n\n A：在当前光标所在行的行尾，转换为输入模式\n\n O：在当前光标所在行的上方，新建一行，并转为输入模式；\n</pre>\n <p>\n 输入--&gt;编辑：\n </p>\n<pre> ESC</pre>\n <p>\n 编辑--&gt;末行：\n </p>\n<pre> :</pre>\n <p>\n 末行--&gt;编辑：\n </p>\n<pre> ESC, ESC</pre>\n <div style="background-color:#DDDDDD;padding:10px;color:red;">\n 注：输入模式和末行模式之间不能直接切换\n </div>\n <h3 style="font-size:16px;">\n 一、打开文件\n </h3>\n<pre> vim +# :打开文件，并定位于第#行\n\n vim +：打开文件，定位至最后一行\n\n vim +/PATTERN : 打开文件，定位至第一次被PATTERN匹配到的行的行首\n</pre>\n <div style="background-color:#DDDDDD;padding:10px;color:red;">\n 注：默认处于编辑模式\n </div>\n <h3 style="font-size:16px;">\n 二、关闭文件\n </h3>\n <p>\n 1、末行模式关闭文件\n </p>\n<pre> :q 退出\n\n :wq 保存并退出\n\n :q! 不保存并退出\n\n :w 保存\n\n :w! 强行保存\n\n :wq --&gt; :x\n</pre>\n <p>\n 2、编辑模式下退出\n </p>\n<pre>ZZ: 保存并退出</pre>\n <h3 style="font-size:16px;">\n 三、移动光标(编辑模式)\n </h3>\n <p>\n 1、逐字符移动：\n </p>\n<pre> h: 左\n\n l: 右\n\n j: 下\n\n k: 上\n\n #h: 移动#个字符\n</pre>\n <p>\n 2、以单词为单位移动\n </p>\n<pre> w: 移至下一个单词的词首\n\n e: 跳至当前或下一个单词的词尾\n\n b: 跳至当前或前一个单词的词首\n\n #w: 移动#个单词\n</pre>\n <p>\n 3、行内跳转：\n </p>\n<pre> 0: 绝对行首\n\n ^: 行首的第一个非空白字符\n\n $: 绝对行尾\n</pre>\n <p>\n 4、行间跳转\n </p>\n<pre> #G：跳转至第#行\n\n gg: 第一行\n\n G：最后一行\n</pre>\n <p>\n 5、末行模式\n </p>\n<pre> .: 表示当前行\n\n $: 最后一行\n\n #：第#行\n\n +#: 向下的#行\n</pre>\n <h3 style="font-size:16px;">\n 四、翻屏\n </h3>\n<pre> Ctrl+f: 向下翻一屏\n \n Ctrl+b: 向上翻一屏\n\n Ctrl+d: 向下翻半屏\n\n Ctrl+u: 向上翻半屏\n</pre>\n <h3 style="font-size:16px;">\n 五、删除单个字符\n </h3>\n<pre> x: 删除光标所在处的单个字符\n\n #x: 删除光标所在处及向后的共#个字符\n</pre>\n <h3 style="font-size:16px;">\n 六、删除命令: d\n </h3>\n <p>\n d命令跟跳转命令组合使用\n </p>\n<pre> #dw, #de, #db</pre>\n <p>\n dd: 删除当前光标所在行<br />\n#dd: 删除包括当前光标所在行在内的#行；\n </p>\n <h3 style="font-size:16px;">\n 七、粘贴命令 p\n </h3>\n<pre> p: 如果删除或复制为整行内容，则粘贴至光标所在行的下方，如果复制或删除的内容为非整行，则粘贴至光标所在字符的后面\n\n P: 如果删除或复制为整行内容，则粘贴至光标所在行的上方，如果复制或删除的内容为非整行，则粘贴至光标所在字符的前面\n</pre>\n <h3 style="font-size:16px;">\n 八、复制命令 y\n </h3>\n<pre> 用法同d命令</pre>\n <h3 style="font-size:16px;">\n 九、修改：先删除内容，再转换为输入模式\n </h3>\n<pre> c: 用法同d命令</pre>\n <h3 style="font-size:16px;">\n 十、替换：\n </h3>\n<pre> r：单字符替换\n\n #r: 光标后#个字符全部替换\n\n R: 替换模式\n</pre>\n <h3 style="font-size:16px;">\n 十一、撤消编辑操作 u\n </h3>\n<pre> u：撤消前一次的编辑操作\n\n #u: 直接撤消最近#次编辑操作\n\n 连续u命令可撤消此前的n次编辑操作\n\n 撤消最近一次撤消操作：Ctrl+r\n</pre>\n <h3 style="font-size:16px;">\n 十二、重复前一次编辑操作\n </h3>\n<pre> .：编辑模式重复前一次编辑操作</pre>\n <h3 style="font-size:16px;">\n 十三、可视化模式\n </h3>\n<pre> v: 按字符选取\n\n V：按矩形选取</pre>\n <h3 style="font-size:16px;">\n 十四、查找\n </h3>\n<pre> /PATTERN\n\n ?PATTERN\n\n n 下一个\n\n N 上一个\n</pre>\n <h3 style="font-size:16px;">\n 十五、查找并替换\n </h3>\n <p>\n 在末行模式下使用s命令\n </p>\n<pre> headline,footlines#PATTERN#string#g\n\n 1,$:表示全文\n\n %：表示全文\n</pre>\n <h3 style="font-size:16px;">\n 十六、使用vim编辑多个文件\n </h3>\n<pre> vim FILE1 FILE2 FILE3\n\n :next 切换至下一个文件\n\n :prev 切换至前一个文件\n\n :last 切换至最后一个文件\n\n :first 切换至第一个文件\n\n :q退出当前文件\n\n :qa 全部退出\n</pre>\n <h3 style="font-size:16px;">\n 十七、分屏显示一个文件\n </h3>\n<pre> Ctrl+w, s: 水平拆分窗口\n\n Ctrl+w, v: 垂直拆分窗口\n</pre>\n <p>\n 在窗口间切换光标：\n </p>\n<pre> Ctrl+w, ARROW(h,j,k,l或方向键) \n\n :qa 关闭所有窗口\n</pre>\n <h3 style="font-size:16px;">\n 十八、分窗口编辑多个文件\n </h3>\n<pre> vim -o : 水平分割显示\n\n vim -O : 垂直分割显示\n</pre>\n <h3 style="font-size:16px;">\n 十九、将当前文件中部分内容另存为另外一个文件\n </h3>\n <p>\n 末行模式下使用w命令\n </p>\n<pre> :ADDR1,ADDR2w /path/to/somewhere</pre>\n <h3 style="font-size:16px;">\n 二十、将另外一个文件的内容填充在当前文件中\n </h3>\n<pre> :r /path/to/somefile\n\n 附加到当前文件光标后</pre>\n <h3 style="font-size:16px;">\n 二十一、跟shell交互\n </h3>\n<pre> :! COMMAND</pre>\n <h3 style="font-size:16px;">\n 二十二、高级话题\n </h3>\n <p>\n 1、显示或取消显示行号\n </p>\n<pre> :set nu\n\n :set nonu\n\n mu = number\n</pre>\n <p>\n 2、显示忽略或区分字符大小写\n </p>\n<pre> :set ic\n\n :set noic\n\n ic = ignorecase\n</pre>\n <p>\n 3、设定自动缩进\n </p>\n<pre> :set ai\n\n :set noai\n\n ai = autoindent\n</pre>\n <p>\n 4、查找到的文本高亮显示或取消\n </p>\n<pre> :set hlsearch\n\n :set nohlsearch\n</pre>\n <p>\n 5、语法高亮\n </p>\n<pre> :syntax on\n\n :syntax off</pre>\n <div style="background-color:#DDDDDD;padding:10px;color:red;">\n 注:特性当前有效，如果想要永久有效需修改配置文件\n </div>\n <h3 style="font-size:16px;">\n 二十三、配置文件\n </h3>\n<pre> /etc/vimrc 针对所有用户\n\n ~/.vimrc 针对当前用户</pre>\n </div>\n</div>', '1500033117', 'Linux', '1126089177@qq.com', '0');
INSERT INTO `usernotes` VALUES ('49', 'debian8.2安装中文支持', '<p>\r\n <span style="font-size:16px;">1、安装loacles</span>\r\n</p>\r\n<p>\r\n <span style="font-size:16px;">#apt-get install locales</span>\r\n</p>\r\n<p>\r\n <span style="font-size:16px;">2、使用空格选择安装的语言</span>\r\n</p>\r\n<p>\r\n <br />\r\n</p>\r\n<div class="crayon-line crayon-striped-line" id="crayon-5917f3c1ccce7280358780-2">\r\n <span class="crayon-v" style="font-size:16px;">#dpkg</span><span class="crayon-o" style="font-size:16px;">-</span><span class="crayon-e" style="font-size:16px;">reconfigure&nbsp;</span><span class="crayon-v" style="font-size:16px;">locales</span>\r\n</div>\r\n<span style="font-size:16px;">3、设置shell输出中文</span><span></span>\r\n<p>\r\n <br />\r\n</p>\r\n<p>\r\n <span style="font-size:16px;">#export LANG="zh_CN.UTF-8"。</span>\r\n</p>', '1500033144', 'Linux', '1126089177@qq.com', '0');
INSERT INTO `usernotes` VALUES ('50', 'Linux与window远程桌面控制', '<p>\n <span style="font-size:16px;">1.安装rdesktop</span> \n</p>\n<p>\n <span style="font-size:16px;">sudo apt-get install rdesktop</span> \n</p>\n<p>\n <span style="font-size:16px;">2.连接window</span> \n</p>\n<p>\n <span style="font-size:16px;">rdesktop</span><span style="font-size:16px;">&nbsp; -g 1024*768&nbsp;<span style="font-size:16px;">&nbsp;ip地址</span><span style="font-size:16px;">&nbsp;</span></span>\n</p>\n<p>\n <span style="font-size:16px;">3.全屏连接：rdesktop -f ip地址（按ctrl+alt+enter退出全屏）</span>\n</p>', '1500033168', 'Linux', '1126089177@qq.com', '0');
INSERT INTO `usernotes` VALUES ('51', 'ajax提交post数据遇到大于小于等特殊符号丢失数据解决办法', '<span style="font-size:16px;"></span><span style="font-size:16px;">用ajax传输数据前先用js的encodeURIComponent()函数进行转义。</span>', '1500033188', 'ajax', '1126089177@qq.com', '0');
INSERT INTO `usernotes` VALUES ('53', '通过ajax发送post请求session失效原因', '<p>\r\n <span style="font-size:16px;">原因是:</span>\r\n</p>\r\n<p>\r\n <span style="font-size:16px;">没有提交_token字段</span>\r\n</p>\r\n<p>\r\n <span style="font-size:16px;">解决办法是:</span>\r\n</p>\r\n<p>\r\n <span style="font-size:16px;">在提交的ajax参数中加入_token字段以及它的值</span>\r\n</p>', '1500033238', 'laravel', '1126089177@qq.com', '0');
INSERT INTO `usernotes` VALUES ('56', '360浏览器显示页面混乱解决办法', '<p>\n <span style="font-size:14px;">在html&lt;head&gt;标签中加入以下这句代码：</span>\n</p>\n<p>\n <span style="font-size:14px;">&lt;meta http-equiv="X-UA-Compatible" content="IE=edge"&gt;</span>\n</p>', '1500432407', 'PHP开发经验', '1126089177@qq.com', '0');
INSERT INTO `usernotes` VALUES ('57', 'git入门教程', '<p>\n <span style="font-family:NSimSun;font-size:16px;"><span style="font-size:14px;font-family:SimHei;"></span><span style="font-size:14px;font-family:SimHei;">一、使用手册</span></span> \n</p>\n<p>\n <span style="font-family:SimHei;font-size:14px;">有一下三种方法获取帮助：</span> \n</p>\n<p>\n <span style="font-family:SimHei;font-size:14px;color:#E53333;">$ git help &lt;verb&gt;</span> \n</p>\n<p>\n <span style="font-family:SimHei;font-size:14px;color:#E53333;">$ git &lt;verb&gt; --help</span> \n</p>\n<p>\n <span style="color:#E53333;font-size:14px;font-family:SimHei;"><span style="font-size:14px;color:#E53333;font-family:SimHei;">$ man git- &lt;verb&gt;</span></span> \n</p>\n<p>\n <span style="font-size:14px;font-family:SimHei;"><span style="font-size:14px;font-family:SimHei;">例如，如果想获取config命令的手册，输入</span></span> \n</p>\n<p>\n <span style="color:#E53333;font-size:14px;font-family:SimHei;"><span style="font-size:14px;color:#E53333;font-family:SimHei;">$ git help config</span></span> \n</p>\n<p>\n <span style="color:#E53333;font-size:14px;font-family:SimHei;"><span style="font-size:14px;color:#E53333;font-family:SimHei;">$ git config --help</span></span> \n</p>\n<p>\n <span style="color:#E53333;font-size:14px;font-family:SimHei;"><span style="font-size:14px;color:#E53333;font-family:SimHei;">$man git-config</span></span> \n</p>\n<p>\n <span style="color:#000000;"><span style="font-size:14px;color:#000000;font-family:SimHei;">二、</span><span style="font-size:14px;color:#E53333;font-family:SimHei;"><span style="color:#000000;font-size:14px;font-family:SimHei;">常用命令</span></span></span> \n</p>\n<p>\n <span style="color:#000000;"><span style="font-size:16px;color:#E53333;"><span style="color:#000000;"><span style="font-size:14px;font-family:SimHei;">1.初始化本地仓库：</span><span style="color:#E53333;font-size:14px;font-family:SimHei;">git init</span></span></span></span> \n</p>\n<p>\n <span style="color:#000000;font-size:14px;font-family:SimHei;"><span style="font-size:14px;color:#E53333;font-family:SimHei;"><span style="color:#000000;font-size:14px;font-family:SimHei;">例如，进入项目地址cd /var/www/html/git，然后输入git init</span></span></span> \n</p>\n<p>\n <span style="color:#000000;"><span style="font-size:16px;color:#E53333;"><span style="color:#000000;"><span style="font-size:14px;font-family:SimHei;">2.创建文件：</span><span style="color:#E53333;font-size:14px;font-family:SimHei;">vim git.test</span></span></span></span> \n</p>\n<p>\n <span style="color:#000000;"><span style="font-size:16px;color:#E53333;"><span style="color:#000000;"><span style="font-size:14px;font-family:SimHei;">3.查看文件状态：</span><span style="color:#E53333;font-size:14px;font-family:SimHei;">git status</span><span style="font-size:14px;font-family:SimHei;">(文件红色：git.test没有加入到git仓库管理中。文件绿色：git.test加入到git暂存区）</span></span></span></span> \n</p>\n<p>\n <span style="color:#000000;"><span style="font-size:16px;color:#E53333;"><span style="color:#000000;"><span style="font-size:14px;font-family:SimHei;">4.添加git.test到git管理中：</span><span style="color:#E53333;font-size:14px;font-family:SimHei;">git add git.test</span></span></span></span> \n</p>\n<p>\n <span style="color:#000000;"><span style="font-size:16px;"><span style="font-size:14px;font-family:SimHei;">5.添加当前目录所有文件到git管理：</span><span style="color:#E53333;"><span style="font-size:14px;font-family:SimHei;">git add .</span><span style="color:#000000;"></span></span></span></span> \n</p>\n<p>\n <span style="font-size:14px;font-family:SimHei;">6.提交到仓库：git commit -m "注释"。</span> \n</p>\n<p>\n <span style="font-size:14px;font-family:SimHei;">三、配置用户名与邮箱</span> \n</p>\n<p>\n <span style="font-size:14px;font-family:SimHei;">1.配置局部用户信息</span> \n</p>\n<p>\n <span style="font-size:14px;font-family:SimHei;">配置用户名</span> \n</p>\n<p>\n <span style="font-size:14px;color:#E53333;font-family:SimHei;">git config user.name "kevin"</span> \n</p>\n<p>\n <span style="font-size:14px;font-family:SimHei;">配置用户邮箱</span> \n</p>\n<p>\n <span style="font-size:14px;color:#E53333;font-family:SimHei;">git config user.email "15813246678@163.com"</span> \n</p>\n<p>\n <span style="font-size:14px;font-family:SimHei;">2.配置全局用户信息</span> \n</p>\n<p>\n <span style="font-size:14px;font-family:SimHei;">配置全局用户名</span> \n</p>\n<p>\n <span style="font-size:14px;color:#E53333;font-family:SimHei;">git config --global user.name "kevin"</span> \n</p>\n<p>\n <span style="font-size:14px;font-family:SimHei;">配置全局用户邮箱</span> \n</p>\n<p>\n <span style="font-size:14px;color:#E53333;font-family:SimHei;">git config --global user.email "15813246678@163.com"</span> \n</p>\n<p>\n <span style="font-size:14px;font-family:SimHei;">四、常用命令的别名</span> \n</p>\n<p>\n <span style="font-size:14px;font-family:SimHei;">配置局部命令别名</span> \n</p>\n<p>\n <span style="font-size:14px;font-family:SimHei;">1.给status命令起别名</span> \n</p>\n<p>\n <span style="font-size:14px;color:#E53333;font-family:SimHei;">git config alias.st "status"</span> \n</p>\n<p>\n <span style="font-size:14px;font-family:SimHei;">说明：alias.后面的st是原来命令status的别名</span> \n</p>\n<p>\n <span style="font-size:14px;font-family:SimHei;">2.给commit起别名</span> \n</p>\n<p>\n <span style="font-size:14px;color:#E53333;font-family:SimHei;">git config alias.ci &nbsp;" commit -m"</span> \n</p>\n<p>\n <span style="font-size:14px;font-family:SimHei;">起别名之后git ci test 相当于命令git commit -m "test"</span> \n</p>\n<p>\n <span style="font-size:14px;font-family:SimHei;">配置全局命令别名</span> \n</p>\n<p>\n <span style="font-size:14px;color:#E53333;font-family:SimHei;">git config --global alias.st "status"</span> \n</p>\n<p>\n <span style="color:#000000;font-size:14px;font-family:SimHei;"><span style="font-size:14px;font-family:SimHei;">五.版本回退</span></span> \n</p>\n<p>\n <span style="color:#000000;"><span style="font-size:16px;"><span style="font-size:14px;font-family:SimHei;">如果文件被commit，使用</span><span style="font-size:14px;font-family:SimHei;">git reset --hard HEAD^&nbsp;</span><span style="font-size:14px;font-family:SimHei;">回退</span></span></span> \n</p>\n<p>\n <span style="color:#000000;"><span style="font-size:16px;"><span style="font-size:14px;font-family:SimHei;">1.版本回退：</span><span style="color:#E53333;font-size:14px;font-family:SimHei;">git reset --hard HEAD^ 一个^代表一个版本</span></span></span> \n</p>\n<p>\n <span style="font-size:14px;font-family:SimHei;">例如退回到上一个版本：git reset --hard HEAD^</span> \n</p>\n<p>\n <span style="font-size:14px;font-family:SimHei;">退回到上两个版本：git reset --hard HEAD^^</span> \n</p>\n<p>\n <span style="font-size:16px;"><span style="font-size:14px;font-family:SimHei;">2.退回到制定版本：</span><span style="color:#E53333;font-size:14px;font-family:SimHei;">git reset --hard 8308f01 后面的"8308f01"为版本号</span></span> \n</p>\n<p>\n <span style="font-size:14px;font-family:SimHei;">如果文件没被commit</span> \n</p>\n<p>\n <span style="font-size:16px;"><span style="font-size:14px;font-family:SimHei;">退回到最高版本号：</span><span style="color:#E53333;font-size:14px;font-family:SimHei;">git reset --hard HEAD</span></span> \n</p>\n<p>\n <span style="font-size:16px;"><span style="font-size:14px;font-family:SimHei;">检出当前分支最高版本：</span><span style="color:#E53333;font-size:14px;font-family:SimHei;">git checkout git.test 其中git.test为文件</span></span> \n</p>\n<p>\n <span style="font-size:14px;font-family:SimHei;">七、查看修改日志</span> \n</p>\n<p>\n <span style="font-size:14px;font-family:SimHei;">如果退回到早期的版本，那么后面的版本号用log命令将不能显示，需要使用</span> \n</p>\n<p>\n <span style="font-size:16px;"><span style="color:#E53333;font-size:14px;font-family:SimHei;">git reflog</span><span style="font-size:14px;font-family:SimHei;">命令查看每一次修改的日志</span></span> \n</p>\n<p>\n <span style="font-size:16px;"><br />\n</span> \n</p>\n<p>\n <br />\n</p>\n<p>\n <br />\n</p>', '1501065976', 'Git', '1126089177@qq.com', '0');
INSERT INTO `usernotes` VALUES ('64', 'Apache2配置虚拟主机', '<p>\n <span style="font-size:14px;">deepin下Apache配置文件的目录位于/etc/apache2</span>\n</p>\n<p>\n <span style="font-size:14px;">首先编辑apache2.conf文件</span>\n</p>\n<p>\n <span style="font-size:14px;">将include model configuration后的两行注释去掉</span>\n</p>\n<p>\n <span style="font-size:14px;">然后打开sites-enabled文件夹，复制一份000-default.conf</span>\n</p>\n<p>\n <span style="font-size:14px;">打开修改如下(黄色部分)</span>\n</p>\n<p>\n <span style="font-size:14px;">&lt;VirtualHost *:80&gt;</span><br />\n<span> </span><span style="font-size:14px;"># The ServerName directive sets the request scheme, hostname and port that</span><br />\n<span> </span><span style="font-size:14px;"># the server uses to identify itself. This is used when creating</span><br />\n<span> </span><span style="font-size:14px;"># redirection URLs. In the context of virtual hosts, the ServerName</span><br />\n<span> </span><span style="font-size:14px;"># specifies what hostname must appear in the request\'s Host: header to</span><br />\n<span> </span><span style="font-size:14px;"># match this virtual host. For the default virtual host (this file) this</span><br />\n<span> </span><span style="font-size:14px;"># value is not decisive as it is used as a last resort host regardless.</span><br />\n<span> </span><span style="font-size:14px;"># However, you must set it for any further virtual host explicitly.</span>\n</p>\n<p>\n <span style="font-size:14px;">#域名</span><br />\n<span> </span><span style="background-color:#FFE500;font-size:14px;">ServerName tp.com</span><br />\n<br />\n<span> </span><span style="font-size:14px;">ServerAdmin webmaster@localhost</span>\n</p>\n<p>\n <span style="font-size:14px;">#运行目录</span><br />\n<span> </span><span style="background-color:#FFE500;font-size:14px;">DocumentRoot /var/www/html/tp/public</span><br />\n<br />\n<span> </span><span style="font-size:14px;"># Available loglevels: trace8, ..., trace1, debug, info, notice, warn,</span><br />\n<span> </span><span style="font-size:14px;"># error, crit, alert, emerg.</span><br />\n<span> </span><span style="font-size:14px;"># It is also possible to configure the loglevel for particular</span><br />\n<span> </span><span style="font-size:14px;"># modules, e.g.</span><br />\n<span> </span><span style="font-size:14px;">#LogLevel info ssl:warn</span><br />\n<br />\n<span> </span><span style="font-size:14px;">ErrorLog ${APACHE_LOG_DIR}/error.log</span><br />\n<span> </span><span style="font-size:14px;">CustomLog ${APACHE_LOG_DIR}/access.log combined</span><br />\n<br />\n<span> </span><span style="font-size:14px;"># For most configuration files from conf-available/, which are</span><br />\n<span> </span><span style="font-size:14px;"># enabled or disabled at a global level, it is possible to</span><br />\n<span> </span><span style="font-size:14px;"># include a line for only one particular virtual host. For example the</span><br />\n<span> </span><span style="font-size:14px;"># following line enables the CGI configuration for this host only</span><br />\n<span> </span><span style="font-size:14px;"># after it has been globally disabled with "a2disconf".</span><br />\n<span> </span><span style="font-size:14px;">#Include conf-available/serve-cgi-bin.conf</span><br />\n<span style="font-size:14px;"> &lt;/VirtualHost&gt;</span><br />\n<br />\n<span style="font-size:14px;"> # vim: syntax=apache ts=4 sw=4 sts=4 sr noet</span>\n</p>\n<p>\n <span style="font-size:14px;">修改保存之后打开/etc/hosts文件</span>\n</p>\n<p>\n <span style="font-size:14px;">添加域名</span>\n</p>\n<p>\n <span style="font-size:14px;">127.0.0.1</span><span> </span><span style="font-size:14px;">localhost</span><br />\n<span style="font-size:14px;"> 127.0.1.1 &nbsp; cxwt-PC</span><br />\n<span style="font-size:14px;"> 127.0.1.1 &nbsp; &nbsp; &nbsp; jy.com</span><br />\n<span style="font-size:14px;"> 0.0.0.0 account.jetbrains.com</span><br />\n<span style="font-size:14px;"> 127.0.0.1 mynote.com</span><br />\n<span style="background-color:#FFE500;font-size:14px;">127.0.0.1 tp.com</span><br />\n<span style="font-size:14px;"> # The following lines are desirable for IPv6 capable hosts</span><br />\n<span style="font-size:14px;"> ::1 &nbsp; &nbsp; ip6-localhost ip6-loopback</span><br />\n<span style="font-size:14px;"> fe00::0 ip6-localnet</span><br />\n<span style="font-size:14px;"> ff00::0 ip6-mcastprefix</span><br />\n<span style="font-size:14px;"> ff02::1 ip6-allnodes</span><br />\n<span style="font-size:14px;"> ff02::2 ip6-allrouters</span>\n</p>\n<div>\n <span style="font-size:14px;">保存修改后重启Apache</span>\n</div>\n<br />\n<div>\n <br />\n</div>\n<p>\n <br />\n</p>', '1502868449', '环境配置', '1126089177@qq.com', '0');
INSERT INTO `usernotes` VALUES ('66', '手机通过万能钥匙破解WiFi密码后查看密码', '<p>\n <span style="font-size:16px;">安卓手机安装WiFi万能钥匙，可以破解已经分享的密码，但是如果手机没有root的话是查看不了密码的。root了之后可能手机就不再保修，再者也不想那么麻烦去安装root工具来root。初次之外还有一种办法，就是通过手机自带的备份工具，选择WiFi备份，备份完之后找到备份文件，然后通过电脑的编辑器分析出WiFi的密码。</span>\n</p>\n<p>\n <span style="font-size:16px;"><br />\n</span>\n</p>', '1503592819', '加密与解密', '1126089177@qq.com', '0');
INSERT INTO `usernotes` VALUES ('68', 'tty进入与退出', '<p>\n <span style="font-size:14px;">1.如果本来在桌面，按</span> \n</p>\n<p>\n <span style="font-size:14px;">Ctrl+alt+F1~F6进入tty1~tty6</span> \n</p>\n<p>\n <span style="font-size:14px;">按Ctrl+alt+F7重新进入桌面</span> \n</p>\n<p>\n <span style="font-size:14px;">2.如果开机进入tty,重启桌面命令：</span> \n</p>\n<p>\n <span style="font-size:16px;"><span style="font-size:14px;">sudo service lightdm restart</span><span style="font-size:14px;"></span></span> \n</p>', '1505404250', 'Linux', '1126089177@qq.com', '0');
INSERT INTO `usernotes` VALUES ('69', 'crontab命令详解', '<p>\n <span style="font-size:14px;"><strong>crontab命令：</strong></span> \n</p>\n<p>\n <span style="font-size:14px;">定时执行操作的命令，每一个用户拥有自己的crontab，配置文件存在/var目录下，不能被直接编辑</span> \n</p>\n<p>\n <span style="font-size:14px;"><strong>参数说明：</strong></span> \n</p>\n<p>\n <span style="font-size:14px;">-e设置定时器</span> \n</p>\n<p>\n <span style="font-size:14px;">-l列出当前计时器的设置</span> \n</p>\n<p>\n <span style="font-size:14px;">-r删除计时器的设置</span> \n</p>\n<p>\n <span style="font-size:14px;">-i交互模式，删除计时器设置时要先询问</span> \n</p>\n<p>\n <span style="font-size:14px;"><strong>书写规则</strong></span> \n</p>\n<p>\n <span style="font-size:14px;">15&nbsp; &nbsp; 9&nbsp; &nbsp; *&nbsp; &nbsp; *&nbsp; &nbsp; 5&nbsp; &nbsp; root&nbsp; &nbsp; service apache2 start</span> \n</p>\n<p>\n <span style="font-size:14px;">第一列表示分钟1~59，每分钟用*或者*/1表示</span> \n</p>\n<p>\n <span style="font-size:14px;">第二列表示小时1~23(0表示0点）</span> \n</p>\n<p>\n <span style="font-size:14px;">第三列表示日期1~31</span> \n</p>\n<p>\n <span style="font-size:14px;">第四列表示月份1~12</span> \n</p>\n<p>\n <span style="font-size:14px;">第五列表示标识号星期几0～6(0表示星期天）</span> \n</p>\n<p>\n <span style="font-size:14px;">第六列表示要运行的命令</span> \n</p>\n<p>\n <span style="font-size:14px;"><strong>crontab书写规则的例子：</strong></span> \n</p>\n<p>\n <span style="font-size:14px;">30&nbsp; &nbsp; 21&nbsp; &nbsp; *&nbsp; &nbsp; *&nbsp; &nbsp; *&nbsp; &nbsp; service apache2 restart&nbsp; &nbsp; ……表示每晚的21:30重启Apache</span> \n</p>\n<p>\n <span style="font-size:14px;">45&nbsp; &nbsp; 4&nbsp; &nbsp; 1&nbsp; &nbsp; 1,10,22&nbsp; &nbsp; *&nbsp; &nbsp; *&nbsp; &nbsp; ……表示每月的1、10、22日的4:45分执行指定操作</span> \n</p>\n<p>\n <span style="font-size:14px;">10&nbsp; &nbsp; 1&nbsp; &nbsp; *&nbsp; &nbsp; *&nbsp; &nbsp; 6,0&nbsp; &nbsp; ……表示每周六、日的1:10执行指定操作</span> \n</p>\n<p>\n <span style="font-size:14px;">0,30&nbsp; &nbsp; 18-23&nbsp; &nbsp; *&nbsp; &nbsp; *&nbsp; &nbsp; *&nbsp; &nbsp; ……表示每天的18:00~23:00之间间隔30分钟执行指定操作</span> \n</p>\n<p>\n <span style="font-size:14px;">0&nbsp; &nbsp; 23&nbsp; &nbsp; *&nbsp; &nbsp; *&nbsp; &nbsp; 6&nbsp; &nbsp; ……表示每个星期六的23点执行指定操作</span> \n</p>\n<p>\n <span style="font-size:14px;">0&nbsp; &nbsp; *&nbsp; &nbsp; *&nbsp; &nbsp; *&nbsp; &nbsp; *&nbsp; &nbsp; ……表示每隔一个小时执行指定操作</span> \n</p>\n<p>\n <span style="font-size:14px;">0&nbsp; &nbsp; 11&nbsp; &nbsp; 4&nbsp; &nbsp; *&nbsp; &nbsp; mon-wed&nbsp; &nbsp; ……每个月的4号与每周一到周三的11点执行指定操作</span> \n</p>\n<p>\n <span style="font-size:14px;">0&nbsp; &nbsp; 4&nbsp; &nbsp; 1&nbsp; &nbsp; jan&nbsp; &nbsp; *&nbsp; &nbsp; ……一月1号的4点执行指定操作</span> \n</p>\n<p>\n <br />\n</p>', '1505459104', 'Linux', '1126089177@qq.com', '0');
INSERT INTO `usernotes` VALUES ('70', 'deepin下mysql重装失败', '<p>\n <span style="font-size:14px;">执行了apt-get autoremove mysql-server后发现只删除了一百七十多K的东西。</span> \n</p>\n<p>\n <span style="font-size:14px;">接着执行apt-get install mysql-server后，也是下载了一百七十多k的东西，安装之后不能启动。</span> \n</p>\n<p>\n <span style="font-size:14px;">后来发现需要在后面加上版本才能安装，于是执行apt-get install mysql-server-5.7</span> \n</p>\n<p>\n <span style="font-size:14px;">结果可以安装，但是配置会出错。</span> \n</p>\n<p>\n <span style="font-size:14px;">最后在网上找到了解决的办法：</span> \n</p>\n<p>\n <span style="font-size:14px;">1.删除指定版本：apt-get autoremove mysql-server-5.7</span> \n</p>\n<p>\n <span style="font-size:14px;">2.删除安装的所有mysql服务：sudo</span><span style="font-size:14px;"> apt-get remove --purge mysql-\\*</span> \n</p>\n<p>\n <span style="font-size:14px;">3.然后重新安装：apt-get install mysql-server-5.7 mysql-client-5.7</span> \n</p>\n<p>\n <span style="font-size:14px;">4.安装完成后重启mysql:service mysql restart</span><br />\n<span id="__kindeditor_bookmark_start_5__"><span style="font-size:14px;"></span><span><span style="font-size:14px;"></span><span style="font-size:14px;"></span></span></span> \n</p>', '1505821100', '环境配置', '1126089177@qq.com', '0');
INSERT INTO `usernotes` VALUES ('71', '12312313', '12313123123', '1506573450', 'common', 'testbugs@vip.qq.com', '0');
INSERT INTO `usernotes` VALUES ('72', '1231233333333333333', '33333333333333333333', '1506574139', '123123', 'testbugs@vip.qq.com', '0');
INSERT INTO `usernotes` VALUES ('73', '测试', '测试', '1704525906', 'common', '11111111@qq.com', '0');
-- ----------------------------
-- Table structure for users
-- ----------------------------
DROP TABLE IF EXISTS `users`;
CREATE TABLE `users` (
`id` int(8) NOT NULL AUTO_INCREMENT,
`email` varchar(50) NOT NULL,
`password` varchar(300) NOT NULL,
`regtime` varchar(20) NOT NULL,
`randomcode` varchar(30) NOT NULL,
`lastrdctime` varchar(20) NOT NULL,
`status` varchar(6) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=21 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of users
-- ----------------------------
INSERT INTO `users` VALUES ('14', '15813246678@163.com', 'eyJpdiI6Imp6VUNNbUtQODJrRGhYTERWdUtJdnc9PSIsInZhbHVlIjoiZ08yS0FtUUU2WTRidmNPTzRwa2dmQT09IiwibWFjIjoiNmIyZDc2MDJhNjU5ZDJmNGZmMzIxZTE1YjM0ZWM0MzIxNWUzZDM4NmI2MWUzNzM2MzNlNmEwMWYxMmMwNWQ0YyJ9', '1499440481', 'awmqpxyqne', '1499441563', 'normal');
INSERT INTO `users` VALUES ('15', '11111111@qq.com', 'eyJpdiI6ImR5aGFBT21KSE9sTWNHT1AwdHB2blE9PSIsInZhbHVlIjoiNVc2Y2pORTNXRGljZGYzbHEybWRxdz09IiwibWFjIjoiZDFhYTI3NDQxMjAyODFkZjQ4NTIxMWJkNTFkN2RhMGIyNmFiMTU2ZGJkY2JkMjMwMGVhMDkwYmRmYzZmNWIzYiJ9', '1499441854', 'ywnzbxrp', '1499441854', 'normal');
INSERT INTO `users` VALUES ('16', '672056018@qq.com', 'eyJpdiI6Im0zbVlobTNvMEx6M0M3ZjJIb3h1VEE9PSIsInZhbHVlIjoiZkVVTmJ0ZktQZVRqQXRJMW95aEN2UT09IiwibWFjIjoiNmE2NTUyNWZhMDRiODVkYThkMjkwNTMxNDZiZGZjY2VkYzAzYTU3ZGQ0ZWFkYTBkMjNkZWE4MGM4NDI4OGM3YiJ9', '1499750091', 'fzjelrplys', '1499750397', 'normal');
INSERT INTO `users` VALUES ('17', 'luorunyao312@163.com', 'eyJpdiI6ImFpZjlMdGFINEtBZ1dYZkp6XC9sVHJBPT0iLCJ2YWx1ZSI6InBQc2FWV2NRSktONU42ZjFZcXVsXC93PT0iLCJtYWMiOiI1NDJiN2U1ZDgyZjZjNWUyZjY2ZTJiZGEyYjg5YmJlZWNiYzZkNDJmYjlhNzliNTAyODUzY2RmYThiNTk3OGU0In0=', '1499953705', 'yvbbjmuy', '1499953705', 'normal');
INSERT INTO `users` VALUES ('18', '244780727@qq.com', 'eyJpdiI6Imp1QzdQYUw3MjN3cXowWXlia0pcL2VBPT0iLCJ2YWx1ZSI6IkYzbU56dTA2cFNMbVhtb0F1K1Ayamc9PSIsIm1hYyI6IjY0Zjg3MTFkYTVjNTAyMjRhNWY2YWQ3YzVmYjVjZWEzZTI3OGI2Yzk4NjM5M2MxZjY2MzFmZGM4ZWY5ZjIxYjAifQ==', '1503200426', 'ncsoudtv', '1503200426', 'normal');
INSERT INTO `users` VALUES ('19', 'cxwt520@aliyun.com', 'eyJpdiI6IlwvRGtBRjlaeUZXOHNFY0srbDRVaHVRPT0iLCJ2YWx1ZSI6IkE0Y2xQMGhTMkY2UDVqeWJDUTk5am5uMm9XNFMwSTRUa0lqOElrT0wyK0U9IiwibWFjIjoiYTJhNTE0MWFlYzAxOWVkOGM5MjcyYzEzYTE2NzkzZGJkZWJmNDc0MDIyZjAwYTM0MmM0YmZhMzhlZTdmMjc5YiJ9', '1505311364', 'hyvpjzqt', '1505311364', 'normal');
INSERT INTO `users` VALUES ('20', 'testbugs@vip.qq.com', 'eyJpdiI6Imt0S1VxSCs4dHdROEttMnJ2dm56RGc9PSIsInZhbHVlIjoidW5OYlhLdXZGUmlxMTFmbnk1aUF2dz09IiwibWFjIjoiNzFiZjg3ZWYyODlmNTkxYWQzMzNkNWNhNmRkMWUyZTVhOGJjYjExYzAxNWFkN2NkMzg5ZmU2ZWI2ZGE1ZWJkMyJ9', '1506573349', 'eouqfrkk', '1506573349', 'normal');