Did you accidentally change the wordpress site and home url and now cannot access the site.
Well there are a number of scripts that can reset those options and are openly available, but i will be discussing how to directly reset those option in the mysql database and also by this method you can change any wordpress option easily and fastly.
Following are the steps to reset the siteurl and home :
1. Login to mysql wordpress database(i.e the database that you made for wordpress) using your user name and password.
2.Then type the following command to view the siteurl and home page that you setup incorrectly:
SELECT *FROM wp_options where option_name='siteurl' or option_name='home';
3. Having seen what you have entered incorrectly type the following command ( i am assuming your site and home url to be abc.com replace with your own sitename and home page url).
a) //this resets the home url to abc.com
update wp_options set option_value='http://abc.com' where option_name='home'
b) //this resets siteurl to abc.com
update wp_options set option_value='http://abc.com' where option_name='siteurl'
4.This resets the site url and home page url you can view the changes by executing the command aforementioned in the second step.
Note: This process can me made even more naive if you have mysql query browser which is a Gui based utility where by you can directly edit the options without executing a single command (it will do so on its own).
Apr 14, 2009
Subscribe to Feeds
About Me
Google Translate
Connect !
Categories
ADF
(30)
java
(21)
windows
(20)
Counter Strike 1.6
(13)
Android
(11)
Unix/Linux
(10)
ADF security
(8)
Apache Spark
(8)
Scala
(6)
Search engine Optimization
(6)
jdeveloper11g
(6)
rest
(6)
Computer Networking
(5)
Cool Tutorials
(5)
Retrofit
(5)
Security
(5)
Fortress
(4)
OIM11g
(4)
jsf
(4)
oracle 11g
(4)
Big Data
(3)
Hive
(3)
OPSS
(3)
OpenLDAP
(3)
Wordpress
(3)
javascript
(3)
sql
(3)
website on pc
(3)
Google
(2)
Programming Stuff
(2)
Songbird
(2)
Usenet
(2)
php
(2)
search engines
(2)
wallpapers
(2)
webserver
(2)
Dynamic Dns
(1)
ECM
(1)
Impala
(1)
Lucene
(1)
Softwares
(1)
apache
(1)
code coverage
(1)
firefox
(1)
jmeter
(1)
whitepaper
(1)
Total Pageviews
Popular Posts
-
Are you annoyed of motion blur that occurs in Need For Speed Most Wanted when the car goes at higher speeds ? Well if you are then there ...
-
This tutorial provides you with tips on how to get a consistent 100fps or round about that. Prerequisites: a graphics card external b...
-
To change cs 1.6 start-up or menu music , follow these simple steps:- Open the directory where counter strike is installed and navigate to...
-
Rich Faces consists of some really useful components that can be used to make as they say some very "rich web applications". I...