wordpress 修改IP地址后进不去后台的解决方法

1

mysql -uroot -ppassword wordpress

1

update wp_options set option_value = 'http://newip/wordpress' where option_name = 'siteurl' or option_name = 'home';

1

vi setwordpress

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14

#! /bin/bash
# set wordpress admin ip

param=$#

if [ $param -eq 1 ]; then
        echo "update wp_options set option_value = 'http://"$1"/wordpress' where option_name = 'siteurl' or option_name = 'home';" > setwordpress.tmp
        mysql -uroot -ppassword wordpress < setwordpress.tmp
        rm setwordpress.tmp
        echo "OK..."
        exit 0
fi

echo "use: $0 IP Address (127.0.0.1)"

1

update wp_posts set post_content = replace(post_content, 'http://www.old-domain.com', 'http://www.new-domain.com');