全站https

1 操作

运行mariadb monitor:

mysql

选择wordpress的数据库(按实际数据库名替换斜体字部分):

MariaDB [(none)]> use wpadmin;

把博客文章里的http://caibaoz.com替换成https://caibaoz.com(按实际域名替换斜体字部分):

MariaDB [wpadmin]> UPDATE wp_posts SET `post_content` = REPLACE (`post_content`, 'src="http://caibaoz.com', 'src="https://caibaoz.com');

如果网站具有多个站点,需要针对每个站点都运行一次类似命令(把wp_2_posts中的“2”替换为实际的站点ID):

MariaDB [wpadmin]> UPDATE wp_2_posts SET `post_content` = REPLACE (`post_content`, 'src="http://caibaoz.com', 'src="https://caibaoz.com');

2 参考文档

2.1 Replacing Image Links in WordPress After Installing an SSL Certificate

2.2 Error 1046 Mariadb: No database selected

点击量:59

发表评论

电子邮件地址不会被公开。 必填项已用*标注

20 − 2 =