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
-
This tutorial provides you with tips on how to get a consistent 100fps or round about that. Prerequisites: a graphics card external b...
-
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 ...
-
As you all are aware that Google Plus is shutting down in March 2019 and so are all its services. I have had a legacy android app on p...
-
The following are the simple steps that show how you can use telnet to configure your router/modem or to connect to a remote host and how to...