A Few SQL to rescue you with Wordpress

Have you seen that you could not login to WordPress because you have mistaken update ? So, I have seen it.

So, I will show a few following SQL to help foolish anyone like me.

You will be able to use SQL with phpAdmin or SSH command. So you might be happy.

When you have forgotten the password

You will reissue with wordpress if you forgot password. But you might not set mailer. Oh my god !

The following SQL might help you.

UPDATE wp_users SET user_pass = MD5( 'new password' ) WHERE user_login = 'your user name';

When you have been unable to log in because domain was changed

You might be unable to log in WordPress if you changed domain before change URL of wordpress.
If you want change domain , firast you should change URL of wordpress( home-url,site-url ).

The following SQL might help you.

UPDATE wp_options SET option_value = REPLACE(option_value, 'http://www.old-domain.com', 'http://www.new-domain.com') WHERE option_name = 'home' OR option_name = 'siteurl';

When you want change user name of ‘admin’

You should change default management user name = ‘admin’ for security.

The following SQL might help you.

UPDATE wp_users SET user_login = 'new user name' WHERE user_login = 'admin';

You might also like:

• WordPress security check!!
• How to control Multi domain with One WordPress
• Which better subdirectory or subdomain with Blogs ?
• After moving 301 redirects
• WordPress transferred to a subdirectory

Leave a Reply