威联通_WORDPRESS_更改映射网址

1.修改数据库内的网站地址

由于原来的威联通固件升级后,myqnapcloud就不太稳定了,域名一直不能用,所以还是用回原来路由器的DDNS比较稳定。但由于更换域名,wordpress网站wp_option表内引用数据库的数据就必须改了。因此先打开数据库

[root@LNMP ~]# mysql -u root -p
Enter password: 
show databases
use DB_NAME
mysql> select option_value FROM wp_options where option_name = 'siteurl';
+-----------------------------------+
| option_value                      |
+-----------------------------------+
| http://wong11.myqnapcloud.cn:3008 |
+-----------------------------------+
1 row in set (0.00 sec)

mysql> select option_value FROM wp_options where option_name = 'home';
+-----------------------------------+
| option_value                      |
+-----------------------------------+
| http://wong11.myqnapcloud.cn:3008 |
+-----------------------------------+
1 row in set (0.00 sec)
mysql> update wp_options SET option_value = 'http://zhao0607.asuscomm.cn:3008' where option_name='siteurl';
Query OK, 1 row affected (0.02 sec)
Rows matched: 1  Changed: 1  Warnings: 0

mysql> update wp_options SET option_value = 'http://zhao0607.asuscomm.cn:3008' where option_name='home';
Query OK, 1 row affected (0.01 sec)
Rows matched: 1  Changed: 1  Warnings: 0

2.重置redis缓存数据

关闭redis

[root@LNMP wp-content]# /etc/init.d/redis_6379 stop
Stopping ...
Redis stopped
[root@LNMP ~]# cd /usr/local/nginx/html/wordpress/wp-content/
[root@LNMP wp-content]# mv object-cache.php object-cache.php.bak

重置redis缓存数据

[root@LNMP ~]# /usr/local/redis/bin/redis-cli -h 127.0.0.1 -p 6379
127.0.0.1:6379> FLUSHDB

启动redis

/etc/init.d/redis_6379 start
cp /wp-content/plugins/redis-cache/includes/object-cache.php /usr/local/nginx/html/wordpress/wp-content/

3.测试网站能否正常登录

image-20231216142632305

插件也能正常使用

image-20231216142836021

发表回复

您的邮箱地址不会被公开。 必填项已用 * 标注