Posts tagged as:

through

How to change WordPress Password through phpMyAdmin

by Mahesh Kukreja on November 5, 2009

Sometimes, it may happen that your WordPress blog gets hacked and the hacker changes your administrator password. He may also change your e-mail address. In this case, you cannot reset your password directly from “Lost Password”.  But don’t worry, I’ll tell you a way to reset your WordPress password and also your e-mail address directly through phpMyAdmin. Resetting WordPress administrator password is very easy through phpMyAdmin.

Following are the steps to change WordPress password through phpMyAdmin:

Step 1: Login to your phpMyAdmin using your SQL Database username and password

phpmyadmin

This can be done through cPanel of your host.

Step 2: Browse to your blog’s database

phpmyadmin

Step 3: Find wp_users:

(Edit the default WordPress table prefix “wp_” if needed)

phpmyadmin

Once you click on browse in your wp_users database, you will be shown the users on this blog. Scroll down to the ID which says user_login as admin(by default). Once there click on edit button, the edit button will appear as a pencil logo.

phpmyadmin

Step 4: Edit the values:

Once clicked on edit, you will be taken to a page that appears as below. Here the third field user_pass will have MD5 hashed password under the value column. This value is not in plain text. WordPress, by default, hashes the password to MD5 salt for security reasons.

phpmyadmin

If you want your WordPress administrator password to be “password“, change the value of user_pass to 5f4dcc3b5aa765d61d8327deb882cf99 and click the Go button and then log in to WordPress using your new password..

If you want your password to be different, you can use online MD5 hash generators to generate hash of your required text. You can search Google for “online MD5 generator”, etc.

Example: http://www.adamek.biz/md5-generator.php

Also, if you want to change e-mail address, you can edit value of user_email row.

If you want to change WordPress username, check this tutorial!

Other posts by

Incoming search terms:

  • 5f4dcc3b5aa765d61d8327deb882cf99
  • how to change wordpress password via phpmyadmin
  • how to change the wordpress password
  • wordpress md5 password generator
  • Mat khau mac dinh wafie
  • reset wordpress salt through phpmyadmin
  • reset wordpress 3 3 password phpmyadmin
  • reset admin password from phpmyadmin in wordpress
  • phpmyadmin value generator
  • phpmyadmin password generator

Related Posts
Related Websites

{ 13 comments }

How to change WordPress username through phpMyAdmin

by Mahesh Kukreja on September 4, 2009

Many of you may be knowing that changing WordPress login username is one of the ways to protect your WordPress blog. After a fresh install of WordPress on your host, you sign in with the default username “admin“. You cannot change this username directly from the Admin panel.

But don’t worry! There’s another way to change this username. It’s through phpMyAdmin. This is not a new hack/method. But, it’s quite useful from security point of view, esp. for WordPress newbies.

Following are the steps to change WordPress username through phpMyAdmin:

Step 1: Login to your phpMyAdmin using your SQL Database username and password

phpmyadmin

This can be done through cPanel of your host.

Step 2: Browse to your blog’s database

phpmyadmin

Step 3: Find wp_users:

(Edit the default WordPress table prefix “wp_” if needed)

phpmyadmin

Once you click on browse in your wp_users database, you will be shown the users on this blog. Scroll down to the ID which says user_login as admin(by default). Once there click on edit button, the edit button will appear as a pencil logo.

phpmyadmin

Step 4: Edit the values:

Once clicked on edit, you will be taken to a page that appears as below. Here the second field user_login will have admin under the value column. Change this from admin to anything you prefer.

phpmyadmin

Once done with the change save and click go on the page.

There we have changed the WordPress user from the default admin to something we prefer. This is one way to ensure your WordPress blog is one step secure than it was before.

Happy Blogging.

Other posts by

Incoming search terms:

  • phpmyadmin
  • wordpress change username phpmyadmin
  • wordpress change admin username phpmyadmin
  • wordpress username
  • how to change wordpress username
  • change wordpress username in database
  • change wordpress username
  • wordpress change username database
  • how to change login code in wordpress
  • wordpress change username

Related Posts
Related Websites

{ 19 comments }

Disable WordPress plugins through phpMyAdmin

by Mahesh Kukreja on June 16, 2009

I recently encountered some problem with my WordPress blog after updating it to version 2.8. Due to this update, the plugins also needed to be updated. So, while doing that, there was some problem and my blog wasn’t ready to open. So, I thought of disabling all the plugins and start over again.

But, my admin page was also not opening. So, I searched for methods that would disable plugins without logging in to WP-Admin.

I found out that the plugins could be disabled through phpMyAdmin.

Here are the steps to disable plugins through phpMyAdmin:

Login to phpMyAdmin:

phpmyadmin
This can be done through cPanel.

Browse to your blog’s database:

phpmyadmin

By default, you will be in Structure tab. Switch on to SQL tab, which is besides Structure tab.

phpmyadmin

Run SQL Query:

Navigate to the “active_plugins” column of the “wp_options” table using the following SQL query (edit the default WordPress table prefix “wp_” if needed):

SELECT * FROM wp_options WHERE option_name = 'active_plugins';

phpmyadmin

Once the active_plugins column appears, click to edit it. You will see something similar to the following, depending on the number and type of plugins you have installed:

phpmyadmin

a:26:{i:0;s:19:"akismet/akismet.php";i:1;s:43:"all-in-one-seo-pack/all_in_one_seo_pack.php";i:2;s:25:"blog-stats/blog-stats.php";i:3;s:14:"copyescape.php";i:4;s:31:"dd-formmailer/dd-formmailer.php";i:5;s:36:"google-sitemap-generator/sitemap.php";i:6;s:32:"login-lockdown/loginlockdown.php";i:7;s:18:"mybloglog_wp_2.php";i:8;s:33:"related-sites/RelatedWebsites.php";i:9;s:21:"sociable/sociable.php";i:10;s:23:"statpress/statpress.php";i:11;s:23:"tweetmeme/tweetmeme.php";i:12;s:27:"tweetmyblog/tweetmyblog.php";i:13;s:37:"twittercounter/ald-twittercounter.php";i:14;s:53:"what-would-seth-godin-do/what_would_seth_godin_do.php";i:15;s:17:"wp-ban/wp-ban.php";i:16;s:29:"wp-dbmanager/wp-dbmanager.php";i:17;s:21:"wp-email/wp-email.php";i:18;s:43:"wp-google-analytics/wp-google-analytics.php";i:19;s:27:"wp-imagefit/wp-imagefit.php";i:20;s:61:"wp-limit-posts-automatically/wp-limit-posts-automatically.php";i:21;s:27:"wp-pagenavi/wp-pagenavi.php";i:22;s:29:"wp-postviews/wp-postviews.php";i:23;s:33:"wp-security-scan/securityscan.php";i:24;s:21:"wp-table/wp-table.php";i:25;s:31:"wp-useronline/wp-useronline.php";}

That entire array of code represents every active plugin on your site. Thus, to quickly disable all plugins without using the WP Admin area, highlight the entire block of code, cut it out, and paste it into a safe, offline text file. After removing the code, click the button to save your changes and that’s it. All WordPress plugins are now deactivated (yet still installed, and with all plugin options intact). This obviously is a huge time-saver that really comes in handy during those mission-critical, time-sensitive situations where every second counts. Once you are ready to re-activate your entire set of plugins, simply cut/copy & paste the preserved code back into the “active_plugins” field. Click save and done. Again, don’t forget to backup your database before editing it ;)

Alternately, here is a one-second query to disable all plugins:

UPDATE wp_options SET option_value = '' WHERE option_name = 'active_plugins';

Upon execution, this query will clear the active_plugins field of all active plugins, effectively disabling (without uninstalling or modifying) the entire set. This method is great if you plan on re-enabling each plugin individually, say, after resolving some heinous server error. Whereas the previous technique makes it easy to re-enable all plugins en masse, this query is perfect for simply “nuking” all active plugins with no remorse. ;)

Other posts by

Incoming search terms:

  • wordpress remove plugin not possible
  • disable plugins wordpress phpmyadmin
  • disable wordpress plugins
  • disable plugins phpmyadmin
  • dissable plugin wordpress
  • wordpress disable plugin phpmyadmin
  • wordpress disable plugin from phpmyadmin
  • disable plugin phpmyadmin
  • wordpress disable plugins phpmyadmin
  • disable plugin wordpress

Related Posts
Related Websites

{ 15 comments }