莫名的很喜欢LD 这两个字母,开个新坑吧,忙完最近的事,在6 7月份的时候完成LD Theme 的主题制作(其实是移植啦。)

LD 扫描器的代码还不知道什么重构完成,就又开坑了。。。。滚去写代码。(手动卖萌)

执行后报错  ERROR 1054(42S22) Unknown column 'password' in ‘field list’

错误的原因是 5.7版本下的mysql数据库下已经没有password这个字段了,password字段改成了authentication_string

所以请使用一下命令:

>mysql -u root -p
Enter password: ********
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 12
Server version: 5.7.18-log MySQL Community Server (GPL)

Copyright (c) 2000, 2017, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> use mysql;
Database changed
mysql> select User from user;  #此处为查询用户命令
+-----------+
| User      |
+-----------+
| *******  |
| mysql.sys |
| root      |
+-----------+
rows in set (0.00 sec)

mysql> update user set password=password("*******") where user="*******";  #修改密码报错
ERROR 1054 (42S22): Unknown column 'password' in 'field list'
mysql> update mysql.user set authentication_string=password('*******') where user='*******';  #修改密码成功
Query OK, 1 row affected, 1 warning (0.00 sec)
Rows matched: 1  Changed: 1  Warnings: 1

mysql> flush privileges;  #立即生效
Query OK, 0 rows affected (0.00 sec)

mysql> quit
Bye

n>mysql -u ******* -p #以该用户登录成功.
Enter password: ********
…………………………
mysql>

  1.以系统管理员身份运行cmd.

  2.查看mysql是否已经启动,如果已经启动,就停止:net stop mysql.

  3.切换到MySQL安装路径下:D:\WAMP\MySQL-5.6.36\bin;如果已经配了环境变量,可以不用切换了。

  4.在命令行输入:mysqld -nt --skip-grant-tables

  5.以管理员身份重新启动一个cmd命令窗口,输入:mysql -uroot -p,Enter进入数据库。

  6.如果不想改密码,只是想看原来的密码的话,可以在命令行执行这个语句

select host,user,password from mysql.user;//即可查看到用户和密码

   7.如果要修改密码的话,在命令行下 依次 执行下面的语句

use mysqlupdate user set password=password("new_pass") where user="root";// 'new_pass' 这里改为你要设置的密码flush privileges;exit

   8.重新启动MYSQL,输入密码登录即可!

基本语法

ExcelFile = xlrd.open_workbook(‘xls.xls’,formatting_info=True) #绑定XLS
vuln = ExcelFile.sheet_by_index(1) #绑定sheet页
nrows = vuln.nrows #行数
vuln.row_values(x) #提取X行

from openpyxl import Workbook
from openpyxl.styles import Font, colors, Alignment

    wb = Workbook()
    ws = wb.active

    ws['A1'] = 'ip'



    for x in cal_path(s):
        for x in xls(s,split_path(x)[1]):
            ws.append(x)


    ws.row_dimensions.height=20 #调整行高
    ws.column_dimensions.width=40 #调整列高

    wb.save(xxxxx.xls)