WordPress mysql数据库修改网站访问地址

Posted onAuthorcnliutz

发布于

#mysql -u root -p
>show databases;
>use database wordpress;
>show tables;
>show columns from 表名(table_name) ;
>desc 表名;
>select * from wp_options where option_id=”1″ ; #option_name=”siteurl”
>select * from wp_options where option_id=”2″; #option_name=”home”
>update wp_options set option_value=”http://cnliutz.wicp.vip” where option_id=”1″; #where option_value=”siteurl”
>update wp_options set option_value=”http://cnliutz.wicp.vip” where option_id=”2″; #where option_value=”home”