迁移域名
-
UPDATE wp_posts SET post_content = replace( post_content, 'blog.old.com','blog.new.cn') ;
-
UPDATE wp_comments SET comment_content = replace(comment_content, 'blog.old.com', 'blog.new.cn') ;
-
UPDATE wp_comments SET comment_author_url = replace(comment_author_url, 'blog.old.com', 'blog.new.cn') ;
-
update wp_options set option_value = replace(option_value, 'blog.old.com', 'blog.new.cn') ;
修改密码
- update wp_users set user_pass = md5('xxx') where user_login='username';
