For those of you wondering how to reset your WordPress admin password via MySQL command line, here’s how to do it:
Enter your MySQL command line with something like:
mysql -uroot -p
Then enter your password.
Once inside the MySQL command line do:
show databases;
and then find your database for the WordPress blog that you want to change password.
use mydatabase;
where mydatabase should be “your” database.
Then do:
update wp_users set user_pass =MD5(’typenewpasswordhere’) where id=1;
If you have a website that uses a lot of API requests (such as dealing with Twitter), you can save a lot of server load/costs simply by installing DNS caching to your web server.
Each DNS request (every time you request from any domain name using an API) takes anywhere between 0 to 500 miliseconds. Sometimes, adding DNS caching to your web server can make your website load in 1 second versus 10 seconds.
Anyways, it’s easy to do and here’s how to do it on CentOS/Fedora linux servers: (Ubuntu should be similar, just use apt-get install of yum)
First install
Just Ping is a service that will ping your website from various different locations in the world. If you want to optimize your site and also wonder how fast it would load in other parts of the world, you can use Just Ping to do just that.
Another great feature is that you can also check the IP address being reported by various different points in the world. What this does is helps you check DNS delegation status of your website during a DNS move.
When you change your DNS records, your DNS delegation will usually take more than 12-24 hours on average. This means that during that time, it might be impossible to check your website.
This can be a big problem if you are moving a website to a new server and you can’t check if you’ve moved everything right.
So, how do you check your website on the new server during DNS delegation?
You can easily do this by changing the DNS servers on your computer.
For Windows, you can go into your network adaptor settings, then right-click on your adaptor, then sel
I’ve been upgrading WordPress for almost 4 years now and since I manage about 20 blogs, I have learned to figure out how to upgrade your WordPress faster than ever using SSH and wget command.
For one, you will need a dedicated server/VPS that supports SSH. Otherwise you won’t be able to do it.
Here’s exactly how I do it.
1) I go to my WordPress directory using the command cd. ~ 2 seconds
2) I use
For those of you who are trying to upgrade from PHP 5.2 because your application requires PHP 5.2 or above, you can use this hack to upgrade your web server running CentOS. Since CentOS doesn’t officially support PHP 5.2 officially yet, this could possibly be a great workaround.
Word of caution, this hack has worked fine for me for a new Twitter app site I am making that requires use of PHP 5.2 but if you have non-standard customizations to your server, you might want to test it first.
I’ve also found that JSON library that comes with PHP 5.2 is like 20 times fast
If your website does a lot of queries via domain names such as aggregating RSS feeds or even a Twitter app site that accesses Twitter API, you might benefit from installing DNS cache on your linux web server.
For most, you would benefit from installing DNS cache because it will save you a ton of time for your server to fetch IP addreses. (could be anywhere between 5 to 500ms).
I’ve actually found a great article showing you how to do this on a Linux desktop computer. It actually works fine on web servers too.
For those of you who are getting errors with Simple Tags plugin when upgrading to WordPress 2.9, there’s a simple hack to make it work:
Edit the file simple-tags.php and change the following from this:
if ( strpos($wp_version, ‘2.7′) !== false || strpos($wp_version, ‘2.8′) !== false )
to this:
if ( strpos($wp_version, ‘2.7′) !== false || strpos($wp_version, ‘2.8′) !== false || strpos($wp_version, ‘2.9′) !== false )
I guess it’s because the