go语言交叉编译命令和参数优化（链接静态化、缩小文件体积）
CGO_ENABLED=0 GOOS=linux GOARCH=amd64 ../go/bin/go build -ldflags="-s -w" -trimpath -v -o…
wordpress批量关闭文章的评论功能
mysql> SET sql_mode = 'ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION'; mysql> alter table wp_posts alter…
给 WordPress 配置 Nginx HTTPS 反向代理
给 WordPress 配置 Nginx HTTPS 反向代理后，网站的 CSS、JS 等静态资源链接都变成了 HTTP 协议，导致浏览器报混合内容错误，资源加载异常…
MySQL8 1396错误处理
Last_SQL_Errno: 1396 Last_SQL_Error: Coordinator stopped because there were error(s) in…
MySQL8 2061错误的处理
Last_IO_Errno: 2061 Last_IO_Error: error connecting to master 'repl@210.14.75.1:3306' - retry-time:…
基于php-fpm标准镜像构建gd、mysqli、pdo_mysql模块支持
FROM php:8.3.24RC1-fpm-alpine3.21 WORKDIR /var/www/html RUN sed -i 's|https://dl-cdn.alpinelinux.org/alpine|https://mirrors.aliyun.com/alpine|g' /etc/apk/repositories &&…
基于nginx标准镜像构建ModSecurity+Brotli模块支持
FROM nginx:1.27.5 RUN /bin/rm -f /etc/apt/sources.list.d/debian.sources && \ echo "deb…
mysql 执行sql替换操作
UPDATE wp_posts SET post_content = REPLACE(post_content, '旧字符', '新字符') WHERE post_type…