Like the blog? Get the book »

Edit Your Options from the WordPress Admin

Edit Your Options from the WordPress Admin

Ever needed to update an option in your database without having to log into your control panel or phpMyAdmin? WordPress provides you with an easy way to view, edit and update your database options table (wp_options) by simply opening the following URL in your browser:

http://your-blog.com/wp-admin/options.php

Edit the URL with your domain name and hit the “Go” button in your browser to be taken to the “All Settings” page:

The 'All Settings' PageThe WordPress “All Settings” Page

On this super-secret options page, you will find an editable, alphabetized list of all entries in your wp_options table, which is like the brain of your WordPress database that stores all of your blog’s personal settings, plugin options, and just about everything else that has to do with the customization of your site. So needless to say, it is really handy having access to all of these settings from the laid-back comfort of your own private WordPress Admin area.

The only thing that may kinda suck is that any database options that are serialized are “greyed out” and not available for viewing or editing (see the “active_plugins” setting in the screenshot above). Serialized options generally consist of multiple values entered as an array. A good example of this is the list of active plugins. It is more efficient to store such serialized data in a single field than it is to populate a hundred of them with similar values.

Having this options page available is a huge help and very thoughtful of the WordPress developers to include. Now, if we could only get our Post and Page IDs back ;)

11 responses

  1. Wow, Great post.. very nice to know that options.php thingy :)

  2. Chuck Reynolds

    yeah good add by the devs. for the post id’s and stuff look at this mod.

    • That will definitely do the job – will be great to have ID information during theme design and plugin development. Can always disable when not in use. Thanks.

  3. That’s one of the most useful things I’ve learned about WordPress in the past month. They’ve really figured this stuff out well huh?

    Thanks so much!

  4. Doesn’t this give anyone in the world the ability to edit your settings and completely destroy your site?

    • Hi Paul,

      Actually, the WP Options Page described in the post is only accessible to logged in Administrators — anything less than Admin-level accounts do not have access.

  5. Great Tutorial Man, First Time Notice That Trick :) thanks for Sharing

  6. Thanks for sharing this tip + screen cap.

Comments are closed for this post. Contact us with any critical information.
© 2009–2024 Digging Into WordPress Powered by WordPress Monzilla Media shapeSpace