作者：dongfangwujie

for i in `cd /proc;ls |grep “^[0-9]”|awk ‘ $0 >100’` ;do awk ‘/Swap:/{a=a+$2}END{print ‘”$i”‘,a/1024″M”}’ /proc/$i/smaps ;done |sort -k2nr 

#1、在mysql的安装目录中，新建data目录及my.ini#注意事项my.ini文件必须要用ansi的方式编码

#2、编辑my.ini

[mysqld] 
basedir=D:\mysql-5.7.36-winx64
datadir=D:\mysql-5.7.36-winx64\data
port=3306
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
character-set-server=utf8
character_set_filesystem=utf8

[client]
default-character-set=utf8
[mysql]
default-character-set=utf8

#3、将D:\mysql-5.7.36-winx64\bin路径添加到path中

#4.初始化数据库D:\mysql-5.7.36-winx64\bin>mysqld –initialize –user=mysql –console

2022-03-30T07:44:01.640992Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use –explicit_defaults_for_timestamp server option (see documentation for more details).

2022-03-30T07:44:01.641071Z 0 [Warning] 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release.
2022-03-30T07:44:01.641079Z 0 [Warning] 'NO_AUTO_CREATE_USER' sql mode was not set.
2022-03-30T07:44:02.890183Z 0 [Warning] InnoDB: New log files created, LSN=45790
2022-03-30T07:44:03.350137Z 0 [Warning] InnoDB: Creating foreign key constraint system tables.2022-03-30T07:44:03.496899Z 0 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: 2b9d5b48-affd-11ec-83b7-0250f2000002.
2022-03-30T07:44:03.537576Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2022-03-30T07:44:04.828539Z 0 [Warning] A deprecated TLS version TLSv1 is enabled. Please use TLSv1.2 or higher.
2022-03-30T07:44:04.828830Z 0 [Warning] A deprecated TLS version TLSv1.1 is enabled. Please use TLSv1.2 or higher.
2022-03-30T07:44:04.829738Z 0 [Warning] CA certificate ca.pem is self signed.
2022-03-30T07:44:06.375278Z 1 [Note] A temporary password is generated for root@localhost: V8uZTa!8fk.p

#【注意】记录随机生成密码 或 初始采用这条命令：mysqld initialize insecure –user=mysql –console

#5.启动服务mysql服务net start mysql

【帮助指南】

1、netstat -ano|findstr 3306
2、Windows下Mysql5.7忘记root密码的解决方法

1. 打开第一个cmd窗口执行 net stop mysql57
2. 在第一个cmd窗口执行 mysqld –defaults-file=”C:\ProgramData\MySQL\MySQL Server 5.7\my.ini” –skip-grant-tables —注意以你的路径为准
3. 打开第二个cmd窗口执行 mysql -uroot -p 提示输入密码，直接回车（不用输入密码）
4. 选择数据库：use mysql;
5. 更新root的密码：update user set authentication_string=password(‘新密码’) where user=’root’ and Host=’localhost’;
6. 刷新权限：flush privileges;
7. 退出：quit
8. 重新登录：mysql -uroot -p 提示输入密码，这时输入密码才能登录。完成！！！

【FQA】mysqld: [ERROR] Found option without preceding group in config file D:\mysql-5.7.36-winx64\my.ini at line 1!
 
没有新建库，需要建立一个库  

在紧急情况中，飞行员的首要任务事保持飞机飞行。相比乘客与飞行安全着陆，故障定位和排查是次要目标。

世界本来就浮躁，不影响别人，别人就来影响你；不记住自己的初心，迟早被虚无缥缈的浮躁所吞噬。

#!/usr/bin/env python3
# -*-coding:utf8-*-

import re
import time
import subprocess
from datetime import datetime
from io import StringIO

def main(domain):
    f = StringIO()
    comm = f"curl -Ivs https://{domain} --connect-timeout 10"

    result = subprocess.getstatusoutput(comm)
    f.write(result[1])

    m = re.search('start date: (.*?)\n.*?expire date: (.*?)\n.*?common name: (.*?)\n.*?issuer: CN=(.*?)\n', f.getvalue(), re.S)
    start_date = m.group(1)
    expire_date = m.group(2)
    common_name = m.group(3)
    issuer = m.group(4)

    # time 字符串转时间数组
    start_date = time.strptime(start_date, "%b %d %H:%M:%S %Y GMT")
    start_date_st = time.strftime("%Y-%m-%d %H:%M:%S", start_date)
    # datetime 字符串转时间数组
    expire_date = datetime.strptime(expire_date, "%b %d %H:%M:%S %Y GMT")
    expire_date_st = datetime.strftime(expire_date,"%Y-%m-%d %H:%M:%S")

    # 剩余天数
    remaining = (expire_date-datetime.now()).days

    print('域名:', domain)
    print('通用名:', common_name)
    print('开始时间:', start_date_st)
    print('到期时间:', expire_date_st)
    print(f'剩余时间: {remaining}天')
    print('颁发机构:', issuer)
    print(remaining)
    print('*'*30)

    time.sleep(0.5)

if __name__ == "__main__":

    domains = ['www.baidu.com']

    for domain in domains:
        main(domain)

<!DOCTYPE html><html><head>
    <meta charset="UTF-8">
<script src="/jquery.js"></script>  //注意有/，加载效果失败
<script type="text/javascript">
$(document).ready(function(){
$(".flip").click(function(){
$(".panel").slideToggle("slow");
});
});
</script>
<style type="text/css">
div.panel,p.flip
{
margin:0px;
padding:5px;
text-align:center;
background:#e5eecc;
border:solid 1px #c3c3c3;
}
div.panel
{
height:120px;
display:none;
}
</style>
</head>
<body>
<div class="panel">
<p>学习前端课程</p>
<p>深入浅出前端系列</p>
</div>
<p class="flip">请点击这里</p>
</body>
</html>

<!DOCTYPE html><html><head>
    <meta charset="UTF-8">
<script src="jquery.js"></script>
<script type="text/javascript">
$(document).ready(function(){
$(".flip").click(function(){
$(".panel").slideToggle("slow");
});
});
</script>
<style type="text/css">
div.panel,p.flip
{
margin:0px;
padding:5px;
text-align:center;
background:#e5eecc;
border:solid 1px #c3c3c3;
}
div.panel
{
height:120px;
display:none;
}
</style>
</head>
<body>
<div class="panel">
<p>学习前端课程</p>
<p>深入浅出前端系列</p>
</div>
<p class="flip">请点击这里</p>
</body>
</html>

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <title>New tec</title>
</head>
<body>
    <div id="header">
        <h1>四川省</h1>
    </div>
    <div id="nav">
        成都<br>
        德阳<br>
        绵阳<br>
        遂宁<br>
    </div>
    <div id="section">
    <h1>CD</h1>
    <p>
        成都历史悠久，有“天府之国”、“蜀中江南”、“蜀中苏杭”的美称。据史书记载，大约在公元前5世纪中叶的古蜀国开明王朝九世时将都城从广都樊乡（双流）迁往成都，构筑城池。 关于成都一名的来历，据《太平环宇记》记载，是借用西周建都的历史经过，取周王迁岐“一年而所居成聚，二年成邑，三年成都”而得名成都。蜀语“成都”二字的读音就是蜀都。 “‘成’者‘毕也’‘终也’”，成都的含义“就是蜀国‘终了的都邑’，或者说‘最后的都邑’。五代十国时，后蜀皇帝孟昶偏爱芙蓉花，命百姓在城墙上种植芙蓉树，花开时节， 成都“四十里为锦绣”，故成都又被称为芙蓉城，简称“蓉城”。2001年2月8日出土的金沙遗址，已经将成都建城历史从公元前311年提前到了公元前611年。
    </p>
    <p>

</div>
    <div id="footer">
        Copyright www.tcc.pub
    </div>
</body>
    <style>
        #header {
            background-color:darkblue;
            color:white;
            text-align:center;
            padding:10px;
        }
        #nav {
            line-height:30px;
            background-color:#eeeeee;
            height:400px;
            width:100px;
            float:left;
            padding:20px;
        }
        #section {
            width:350px;
            float:left;
            padding:10px;
        }
        #footer {
            background-color:black;
            color:white;
            clear:both;
            text-align:center;
            padding:5px;
        }
    </style>
</html>

创业者不一定是CEO(首席执行官)，创业者可以是一个产品经理，创业者可以是一个程序员，创业者可以是一个设计师，创业者可以是一个产品经理，只要你拥有这个创业的梦想

勤学，修德，明辨，笃定！！！