urlencode

作者: 邓老师
时间: 2022-12-20
分类: 默认分类
评论

工作簿1.xlsm.zip

如何从零开始搭建 Woocommerce 在线商城

作者: 邓老师
时间: 2022-12-15
分类: 默认分类
评论

生成删除数据库wordpress_m中以“c1_”开始的所有表

作者: 邓老师
时间: 2022-12-14
分类: 默认分类
评论

生成删除数据库wordpress_m中以“c1_”开始的所有表：

select CONCAT( 'drop table ', table_name, ';' ) from information_schema.tables where table_schema='wordpress_m' and table_name like 'c1\_%'

insert into users (username,name,role,password) values("user2",NULL,"editor","8d969eef6ecad3c29a3a629280e686cf0c3f5d5a86aff3ca12020c923adc6c92");
insert into users (username,name,role,password) values("user3",NULL,"editor","8d969eef6ecad3c29a3a629280e686cf0c3f5d5a86aff3ca12020c923adc6c92");
insert into users (username,name,role,password) values("user4",NULL,"editor","8d969eef6ecad3c29a3a629280e686cf0c3f5d5a86aff3ca12020c923adc6c92");
insert into users (username,name,role,password) values("user5",NULL,"editor","8d969eef6ecad3c29a3a629280e686cf0c3f5d5a86aff3ca12020c923adc6c92");
insert into users (username,name,role,password) values("user6",NULL,"editor","8d969eef6ecad3c29a3a629280e686cf0c3f5d5a86aff3ca12020c923adc6c92");
insert into users (username,name,role,password) values("user7",NULL,"editor","8d969eef6ecad3c29a3a629280e686cf0c3f5d5a86aff3ca12020c923adc6c92");
insert into users (username,name,role,password) values("user8",NULL,"editor","8d969eef6ecad3c29a3a629280e686cf0c3f5d5a86aff3ca12020c923adc6c92");
insert into users (username,name,role,password) values("user9",NULL,"editor","8d969eef6ecad3c29a3a629280e686cf0c3f5d5a86aff3ca12020c923adc6c92");
insert into users (username,name,role,password) values("user10",NULL,"editor","8d969eef6ecad3c29a3a629280e686cf0c3f5d5a86aff3ca12020c923adc6c92");
insert into users (username,name,role,password) values("user11",NULL,"editor","8d969eef6ecad3c29a3a629280e686cf0c3f5d5a86aff3ca12020c923adc6c92");
insert into users (username,name,role,password) values("user12",NULL,"editor","8d969eef6ecad3c29a3a629280e686cf0c3f5d5a86aff3ca12020c923adc6c92");
insert into users (username,name,role,password) values("user13",NULL,"editor","8d969eef6ecad3c29a3a629280e686cf0c3f5d5a86aff3ca12020c923adc6c92");
insert into users (username,name,role,password) values("user14",NULL,"editor","8d969eef6ecad3c29a3a629280e686cf0c3f5d5a86aff3ca12020c923adc6c92");
insert into users (username,name,role,password) values("user15",NULL,"editor","8d969eef6ecad3c29a3a629280e686cf0c3f5d5a86aff3ca12020c923adc6c92");
insert into users (username,name,role,password) values("user16",NULL,"editor","8d969eef6ecad3c29a3a629280e686cf0c3f5d5a86aff3ca12020c923adc6c92");
insert into users (username,name,role,password) values("user17",NULL,"editor","8d969eef6ecad3c29a3a629280e686cf0c3f5d5a86aff3ca12020c923adc6c92");
insert into users (username,name,role,password) values("user18",NULL,"editor","8d969eef6ecad3c29a3a629280e686cf0c3f5d5a86aff3ca12020c923adc6c92");
insert into users (username,name,role,password) values("user19",NULL,"editor","8d969eef6ecad3c29a3a629280e686cf0c3f5d5a86aff3ca12020c923adc6c92");
insert into users (username,name,role,password) values("user20",NULL,"editor","8d969eef6ecad3c29a3a629280e686cf0c3f5d5a86aff3ca12020c923adc6c92");
insert into users (username,name,role,password) values("user21",NULL,"editor","8d969eef6ecad3c29a3a629280e686cf0c3f5d5a86aff3ca12020c923adc6c92");
insert into users (username,name,role,password) values("user22",NULL,"editor","8d969eef6ecad3c29a3a629280e686cf0c3f5d5a86aff3ca12020c923adc6c92");
insert into users (username,name,role,password) values("user23",NULL,"editor","8d969eef6ecad3c29a3a629280e686cf0c3f5d5a86aff3ca12020c923adc6c92");
insert into users (username,name,role,password) values("user24",NULL,"editor","8d969eef6ecad3c29a3a629280e686cf0c3f5d5a86aff3ca12020c923adc6c92");
insert into users (username,name,role,password) values("user25",NULL,"editor","8d969eef6ecad3c29a3a629280e686cf0c3f5d5a86aff3ca12020c923adc6c92");
insert into users (username,name,role,password) values("user26",NULL,"editor","8d969eef6ecad3c29a3a629280e686cf0c3f5d5a86aff3ca12020c923adc6c92");
insert into users (username,name,role,password) values("user27",NULL,"editor","8d969eef6ecad3c29a3a629280e686cf0c3f5d5a86aff3ca12020c923adc6c92");
insert into users (username,name,role,password) values("user28",NULL,"editor","8d969eef6ecad3c29a3a629280e686cf0c3f5d5a86aff3ca12020c923adc6c92");
insert into users (username,name,role,password) values("user29",NULL,"editor","8d969eef6ecad3c29a3a629280e686cf0c3f5d5a86aff3ca12020c923adc6c92");
insert into users (username,name,role,password) values("user30",NULL,"editor","8d969eef6ecad3c29a3a629280e686cf0c3f5d5a86aff3ca12020c923adc6c92");
insert into users (username,name,role,password) values("user31",NULL,"editor","8d969eef6ecad3c29a3a629280e686cf0c3f5d5a86aff3ca12020c923adc6c92");
insert into users (username,name,role,password) values("user32",NULL,"editor","8d969eef6ecad3c29a3a629280e686cf0c3f5d5a86aff3ca12020c923adc6c92");
insert into users (username,name,role,password) values("user33",NULL,"editor","8d969eef6ecad3c29a3a629280e686cf0c3f5d5a86aff3ca12020c923adc6c92");
insert into users (username,name,role,password) values("user34",NULL,"editor","8d969eef6ecad3c29a3a629280e686cf0c3f5d5a86aff3ca12020c923adc6c92");
insert into users (username,name,role,password) values("user35",NULL,"editor","8d969eef6ecad3c29a3a629280e686cf0c3f5d5a86aff3ca12020c923adc6c92");
insert into users (username,name,role,password) values("user36",NULL,"editor","8d969eef6ecad3c29a3a629280e686cf0c3f5d5a86aff3ca12020c923adc6c92");
insert into users (username,name,role,password) values("user37",NULL,"editor","8d969eef6ecad3c29a3a629280e686cf0c3f5d5a86aff3ca12020c923adc6c92");
insert into users (username,name,role,password) values("user38",NULL,"editor","8d969eef6ecad3c29a3a629280e686cf0c3f5d5a86aff3ca12020c923adc6c92");
insert into users (username,name,role,password) values("user39",NULL,"editor","8d969eef6ecad3c29a3a629280e686cf0c3f5d5a86aff3ca12020c923adc6c92");
insert into users (username,name,role,password) values("user40",NULL,"editor","8d969eef6ecad3c29a3a629280e686cf0c3f5d5a86aff3ca12020c923adc6c92");
insert into users (username,name,role,password) values("user41",NULL,"editor","8d969eef6ecad3c29a3a629280e686cf0c3f5d5a86aff3ca12020c923adc6c92");
insert into users (username,name,role,password) values("user42",NULL,"editor","8d969eef6ecad3c29a3a629280e686cf0c3f5d5a86aff3ca12020c923adc6c92");
insert into users (username,name,role,password) values("user43",NULL,"editor","8d969eef6ecad3c29a3a629280e686cf0c3f5d5a86aff3ca12020c923adc6c92");
insert into users (username,name,role,password) values("user44",NULL,"editor","8d969eef6ecad3c29a3a629280e686cf0c3f5d5a86aff3ca12020c923adc6c92");
insert into users (username,name,role,password) values("user45",NULL,"editor","8d969eef6ecad3c29a3a629280e686cf0c3f5d5a86aff3ca12020c923adc6c92");
insert into users (username,name,role,password) values("user46",NULL,"editor","8d969eef6ecad3c29a3a629280e686cf0c3f5d5a86aff3ca12020c923adc6c92");
insert into users (username,name,role,password) values("user47",NULL,"editor","8d969eef6ecad3c29a3a629280e686cf0c3f5d5a86aff3ca12020c923adc6c92");
insert into users (username,name,role,password) values("user48",NULL,"editor","8d969eef6ecad3c29a3a629280e686cf0c3f5d5a86aff3ca12020c923adc6c92");
insert into users (username,name,role,password) values("user49",NULL,"editor","8d969eef6ecad3c29a3a629280e686cf0c3f5d5a86aff3ca12020c923adc6c92");
insert into users (username,name,role,password) values("user50",NULL,"editor","8d969eef6ecad3c29a3a629280e686cf0c3f5d5a86aff3ca12020c923adc6c92");
insert into users (username,name,role,password) values("user51",NULL,"editor","8d969eef6ecad3c29a3a629280e686cf0c3f5d5a86aff3ca12020c923adc6c92");
insert into users (username,name,role,password) values("user52",NULL,"editor","8d969eef6ecad3c29a3a629280e686cf0c3f5d5a86aff3ca12020c923adc6c92");
insert into users (username,name,role,password) values("user53",NULL,"editor","8d969eef6ecad3c29a3a629280e686cf0c3f5d5a86aff3ca12020c923adc6c92");
insert into users (username,name,role,password) values("user54",NULL,"editor","8d969eef6ecad3c29a3a629280e686cf0c3f5d5a86aff3ca12020c923adc6c92");
insert into users (username,name,role,password) values("user55",NULL,"editor","8d969eef6ecad3c29a3a629280e686cf0c3f5d5a86aff3ca12020c923adc6c92");
insert into users (username,name,role,password) values("user56",NULL,"editor","8d969eef6ecad3c29a3a629280e686cf0c3f5d5a86aff3ca12020c923adc6c92");

insert into pods (id,username) values(4,"user3");
insert into pods (id,username) values(5,"user4");
insert into pods (id,username) values(6,"user5");
insert into pods (id,username) values(7,"user6");
insert into pods (id,username) values(8,"user7");
insert into pods (id,username) values(9,"user8");
insert into pods (id,username) values(10,"user9");
insert into pods (id,username) values(11,"user10");
insert into pods (id,username) values(12,"user11");
insert into pods (id,username) values(13,"user12");
insert into pods (id,username) values(14,"user13");
insert into pods (id,username) values(15,"user14");
insert into pods (id,username) values(16,"user15");
insert into pods (id,username) values(17,"user16");
insert into pods (id,username) values(18,"user17");
insert into pods (id,username) values(19,"user18");
insert into pods (id,username) values(20,"user19");
insert into pods (id,username) values(21,"user20");
insert into pods (id,username) values(22,"user21");
insert into pods (id,username) values(23,"user22");
insert into pods (id,username) values(24,"user23");
insert into pods (id,username) values(25,"user24");
insert into pods (id,username) values(26,"user25");
insert into pods (id,username) values(27,"user26");
insert into pods (id,username) values(28,"user27");
insert into pods (id,username) values(29,"user28");
insert into pods (id,username) values(30,"user29");
insert into pods (id,username) values(31,"user30");
insert into pods (id,username) values(32,"user31");
insert into pods (id,username) values(33,"user32");
insert into pods (id,username) values(34,"user33");
insert into pods (id,username) values(35,"user34");
insert into pods (id,username) values(36,"user35");
insert into pods (id,username) values(37,"user36");
insert into pods (id,username) values(38,"user37");
insert into pods (id,username) values(39,"user38");
insert into pods (id,username) values(40,"user39");
insert into pods (id,username) values(41,"user40");
insert into pods (id,username) values(42,"user41");
insert into pods (id,username) values(43,"user42");
insert into pods (id,username) values(44,"user43");
insert into pods (id,username) values(45,"user44");
insert into pods (id,username) values(46,"user45");
insert into pods (id,username) values(47,"user46");
insert into pods (id,username) values(48,"user47");
insert into pods (id,username) values(49,"user48");
insert into pods (id,username) values(50,"user49");
insert into pods (id,username) values(51,"user50");
insert into pods (id,username) values(52,"user51");
insert into pods (id,username) values(53,"user52");
insert into pods (id,username) values(54,"user53");
insert into pods (id,username) values(55,"user54");
insert into pods (id,username) values(56,"user55");
insert into pods (id,username) values(57,"user56");

mount --bind使用

作者: 邓老师
时间: 2022-12-06
分类: 默认分类
评论

示例：
mount --bind /usr/a /home/b

作用解释：
/home/b权限和内容（里面的文件及文件夹）都将和a一模一样，同时b里面的内容（文件及文件夹）将不再出现。

取消挂载：
umount /home/b

mount --bind 的妙用
1，用于vsftp用户加多目录
在用户目录下新建目录www
然后mount --bind /wangzhanpath/www /userpath/www
这样用户就可以访问网站的的www目录了。

2，在固件开发过程中临时替换配置文件
在固件开发过程中为测试某个新功能，必需修改某个系统文件。
而这个文件在只读文件系统上或者是虽然文件可写，但是自己对这个改动没有把握，不愿意直接修改。
这时候mount --bind就是你的好帮手。

假设我们要改的文件是/etc/hosts，可按下面的步骤操作：
1）把新的hosts文件放在/tmp下。
2）mount --bind /tmp/hosts /etc/hosts
测试完成了执行 umount /etc/hosts 断开绑定。

修改端口 3389 windows

作者: 邓老师
时间: 2022-12-04
分类: 默认分类
评论

修改windows 3389端口修改远程桌面端口.rar

夸克

作者: 邓老师
时间: 2022-12-03
分类: 默认分类
评论

我用夸克网盘分享了「221201」，点击链接即可保存。打开「夸克APP」，无需下载在线播放视频，畅享原画5倍速，支持电视投屏。
链接：https://pan.quark.cn/s/2be00a28b1cb
提取码：xe5g

建立wordpress多站点

作者: 邓老师
时间: 2022-12-01
分类: 默认分类
评论

/bin/sh

for i in $(seq 2 55)
do

 #复制apache配置文件
  c="c$i"
 # filename="$c.conf"
 # cp /etc/apache2/sites-enabled/c1.conf  /etc/apache2/sites-enabled/$filename
 # sed -i "s/c1/$c/g"  /etc/apache2/sites-enabled/$filename

 #复制wp文件夹
 #cp -R /var/www/html/c1 /var/www/html/$c
  #修改wp-config.php，设置表的前置名称
  #sed -i "s/C1/$c/g"  /var/www/html/$c/wp-config.php
 #增加hosts解析
 #url="192.168.10.14 $c.wp.cn"
 #echo $url >> /etc/hosts

done;

chown -R www-data:www-data /var/www/html

pve 创建vm cloud-init 模板文件

作者: 邓老师
时间: 2022-12-01
分类: 默认分类
评论

qm create 9000 --memory 2048 --net0 virtio,bridge=vmbr0
qm importdisk 9000 ubuntu-22.10-server-cloudimg-amd64.img local-lvm
qm set 9000 --scsihw virtio-scsi-pci --scsi0 local-lvm:vm-9000-disk-0
qm set 9000 --ide0 local-lvm:cloudinit
qm set 9000 --boot c --bootdisk scsi0
qm set 9000 --serial0 socket --vga serial0
qm template 9000

2022年12月