Archive Post

Home / January 2026
zhangyunhao 0 comments

mysql 执行sql替换操作

UPDATE wp_posts SET post_content = REPLACE(post_content, '旧字符', '新字符') WHERE post_type…
Read More
zhangyunhao 0 comments

Protected: docker grabx

This content is password-protected. To view it, please enter the…
Read More
zhangyunhao 0 comments

docker dnsmasq

dnsmasq-20251127.tarDownload
Read More
zhangyunhao 0 comments

nacos密码重置

在线bcrypt密码生成器： https://www.btool.cn/bcrypt https://www.bejson.com/encrypt/bcrpyt_encode 明文字符：nacos 密文字符：$2a$10$AN9MWVtoA6SUFXrtyrH5Q.1I6XNN7nHBsNBMCBJyI.ECtOyDQr0/W 进入数据库： mysql> use nacos_config; 1、新增管理员…
Read More
zhangyunhao 0 comments

docker安装jira+confluence

docker安装jira+confluenceDownload
Read More
zhangyunhao 0 comments

安装nacos

安装nacosDownload
Read More
zhangyunhao 0 comments

nodejs打包项目

1.安装node https://nodejs.org/dist/v18.20.4/node-v18.20.4-x64.msi 2.安装vscode https://vscode.download.prss.microsoft.com/dbazure/download/stable/f1e16e1e6214d7c44d078b1f0607b2388f29d729/VSCodeUserSetup-x64-1.91.1.exe 3.项目目录里空白地方右击 通过Code打开 4.Terminal New Terminal 5.删除node_modules、package-lock.json…
Read More
zhangyunhao 0 comments

MySQL8.0 执行脚本恢复报错@@GLOBAL.GTID_PURGED cannot be changed: the added gtid set must not overlap with @@

从线上 dump 出 sql 脚本，恢复到本地新建数据库报错。 在复制后执行sql导入数据库的时候，报错:@@GLOBAL.GTID_PURGED cannot be changed: the…
Read More
zhangyunhao 0 comments

MySQL中CHANGE REPLICATION FILTER 语句详解

以下列表显示了 CHANGE REPLICATION FILTER 选项及其与 --replicate-* 服务器选项的关系： REPLICATE_DO_DB：根据数据库名包含更新。相当于 --replicate-do-db。 REPLICATE_IGNORE_DB：根据数据库名排除更新。相当于…
Read More
zhangyunhao 0 comments

mysql 8同步问题的解决方案

问题一、 主从复制报错2061：Authentication plugin 'caching_sha2_password' reported error:Authentication require secure connection 原因：在MySQL8.0之前，身份验证的插件是mysql_native_password，在MySQL…
Read More