Wordpress 常用说明，改域名，忘记密码sql

update wp_users set user_pass=md5("123456") where user_login='admin';

==================问题一======================
换服务器如果没有ssl 注意注释：否则后台登录不了
wp-config.php
//$_SERVER['HTTPS'] = 'on';
//define('FORCE_SSL_LOGIN', true);
//define('FORCE_SSL_ADMIN', true);

==================   换域名后，第一步要先更换数据库配置域名 ======================
网站域名替换
法一（sql修改）：
mysql -uroot -predhat123
use lbbto;
update `wp_options` set `option_value`='http://5.253.29.191/zw/www.lbbto.xyz' where `option_name` ='siteurl';
update `wp_options` set `option_value`='http://5.253.29.191/zw/www.lbbto.xyz' where `option_name` ='home';

update `wp_options` set `option_value`='http://www.jesey.shop' where `option_name` ='siteurl';
update `wp_options` set `option_value`='http://www.jesey.shop' where `option_name` ='home';

UPDATE `wp_users` SET `user_pass`='$P$BWZhQxx/R9UCBgECUhxsV0EKfqfEh31' WHERE `user_login`='admin';
然后使用用户名：admin，密码：admin 登入。

法二（后台修改）：
http://www.jesey.shop/wp-admin/options-general.php

==================   登录后台 ======================

http://www.domain.com/wp-login.php  

http://www.domain.com/wp-admin

==================问题三======================
主题logo显示不出，需更换
后台-外貌-主题（选一个，定制）
http://www.jesey.shop/wp-admin/themes.php
------------
/2021/05/LOGO
update `wp_options` SET `value` = REPLACE( `option_value` , 'lbbto.xyz/wp-content/uploads', 'emmonly' ) WHERE

==================修改货币=====================

http://www.domain.com/wp-admin/admin.php?page=wc-settings&tab=general

==================修改静态=====================

http://www.leirestore.com/wp-admin/options-permalink.php

 

==================修改政策信息=====================

 

 

 

SELECT * FROM wp_posts WHERE post_content LIKE '%你的要替换的文本%'

SELECT * FROM wp_posts WHERE post_content LIKE '%你的要替换的文本%' and post_type = 'page' and post_parent = 0 \G; 

UPDATE wp_posts SET post_content = REPLACE(post_content,'old','new') where  post_type = 'page' and post_parent = 0; 

 

==================修改产品价格=====================

mysql> mysql -uuser -pBB

mysql> use leir

mysql> update wp_postmeta set meta_value = FORMAT(140 + RAND() * (200 - 140),2) where meta_key like '%price%';

mysql>select * from wp_postmeta where meta_key like '%price%';

mysql> update wp_wc_product_meta_lookup set min_price = FORMAT(120 + RAND() * (200 - 140),2);

mysql>update wp_wc_product_meta_lookup set max_price = min_price+20;

mysql>delete from wp_options where option_name like '%_transient_wc_var_prices_%';

--------------------------------------------

https://www.cnblogs.com/eatmore/p/15308900.html

 select * from wp_posts where post_type = 'product' and post_parent = 0 \G;