分类默认分类下的文章

如何从零开始搭建 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

ubuntu20.04安装wordpress脚本

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

#/bin/sh

install_dir="/var/www/html"

Creating Random WP Database Credenitals

db_name="wpdate +%s"
db_user=$db_name
db_password=date |md5sum |cut -c '1-12'
sleep 1
mysqlrootpass=date |md5sum |cut -c '1-12'
sleep 1

Install Packages for https and mysql

apt -y install apache2
apt -y install mysql-server

Start http

rm /var/www/html/index.html
systemctl enable apache2
systemctl start apache2

Start mysql and set root password

systemctl enable mysql
systemctl start mysql

/usr/bin/mysql -e "USE mysql;"
/usr/bin/mysql -e "UPDATE user SET Password=PASSWORD($mysqlrootpass) WHERE user='root';"
/usr/bin/mysql -e "FLUSH PRIVILEGES;"
touch /root/.my.cnf
chmod 640 /root/.my.cnf
echo "[client]">>/root/.my.cnf
echo "user=root">>/root/.my.cnf
echo "password="$mysqlrootpass>>/root/.my.cnf

Install PHP

apt -y install php7.4
apt -y php7.4-mysqli
apt -y php7.4-gd

sed -i '0,/AllowOverride\ None/! {0,/AllowOverride\ None/ s/AllowOverride\ None/AllowOverride\ All/}' /etc/apache2/apache2.conf #Allow htaccess usage

systemctl restart apache2

Download and extract latest WordPress Package

if test -f /tmp/latest.tar.gz
then
echo "WP is already downloaded."
else
echo "Downloading WordPress"
cd /tmp/ && wget "http://wordpress.org/latest.tar.gz";
fi

/bin/tar -C $install_dir -zxf /tmp/latest.tar.gz --strip-components=1
chown www-data: $install_dir -R

Create WP-config and set DB credentials

/bin/mv $install_dir/wp-config-sample.php $install_dir/wp-config.php

/bin/sed -i "s/database_name_here/$db_name/g" $install_dir/wp-config.php
/bin/sed -i "s/username_here/$db_user/g" $install_dir/wp-config.php
/bin/sed -i "s/password_here/$db_password/g" $install_dir/wp-config.php

cat << EOF >> $install_dir/wp-config.php
define('FS_METHOD', 'direct');
EOF

cat << EOF >> $install_dir/.htaccess

BEGIN WordPress

RewriteEngine On
RewriteBase /
RewriteRule ^index.php$ – [L]
RewriteCond %{REQUEST_FILENAME} !-f
RewriteCond %{REQUEST_FILENAME} !-d
RewriteRule . /index.php [L]

END WordPress

EOF

chown www-data: $install_dir -R

Set WP Salts

grep -A50 'table_prefix' $install_dir/wp-config.php > /tmp/wp-tmp-config
/bin/sed -i '/**#@/,/$p/d' $install_dir/wp-config.php
/usr/bin/lynx --dump -width 200 https://api.wordpress.org/secret-key/1.1/salt/ >> $install_dir/wp-config.php
/bin/cat /tmp/wp-tmp-config >> $install_dir/wp-config.php && rm /tmp/wp-tmp-config -f
/usr/bin/mysql -u root -e "CREATE DATABASE $db_name"
/usr/bin/mysql -u root -e "CREATE USER '$db_name'@'localhost' IDENTIFIED WITH mysql_native_password BY '$db_password';"
/usr/bin/mysql -u root -e "GRANT ALL PRIVILEGES ON $db_name.* TO '$db_user'@'localhost';"

Display generated passwords to log file.

echo "Database Name: " $db_name
echo "Database User: " $db_user
echo "Database Password: " $db_password
echo "Mysql root password: " $mysqlrootpass

WordPress加载速度慢,禁用Google字体可以解决

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

WordPress加载速度慢，是因为浏览器一直在等待页面中嵌入的谷歌网络字体(google fonts)链接fonts.googleapis.com，要知道中文网站是很难使用谷歌提供的英文网络字体，何况Google字体对WordPress来说毫无作用。

WordPress系统有两个地方使用了谷歌字体，分别是主题和后台管理界面。要想提升WordPress加载速度，只能去掉或替换页面中嵌入的fonts.googleapis.com引用链接，或禁止使用谷歌字体。

最简单直接的方法就是安装插件，后台搜索“Disable Google Fonts”插件，并安装启用，这个插件就是禁用Google字体的，没有其他多余功能。

分类默认分类下的文章

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

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

eve-ng add user

mount --bind使用

修改端口 3389 windows

夸克

建立wordpress多站点

/bin/sh

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

pve 创建vm cloud-init 模板文件

ubuntu20.04安装wordpress脚本

Creating Random WP Database Credenitals

Install Packages for https and mysql

Start http

Start mysql and set root password

Install PHP

Download and extract latest WordPress Package

Create WP-config and set DB credentials

BEGIN WordPress

END WordPress

Set WP Salts

Display generated passwords to log file.

WordPress加载速度慢,禁用Google字体可以解决

最新文章

分类

归档

分类 默认分类 下的文章

/bin/sh

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

Creating Random WP Database Credenitals

Install Packages for https and mysql

Start http

Start mysql and set root password

Install PHP

Download and extract latest WordPress Package

Create WP-config and set DB credentials

BEGIN WordPress

END WordPress

Set WP Salts

Display generated passwords to log file.

最新文章

分类

归档

分类默认分类下的文章