Joomla!, Wordpress tips for building your site

Joomla!, Wordpress tips for building your site

 Syndicate this site using RSS

A Few SQL to rescue you with Wordpress

Published on| October 21st, 2010 | No Comment.
Categories:Preferences |

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';

Add to your favorites(bookmarks): はてなブックマークへ追加するdel.icio.usLivedoor ClipYahoo!FC2Nifty ClipPOOKMARK. AirlinesBuzzurl（バザール）Choixnewsing

Trackback URL

After Admin approves this comment, it will be shown.


Comments

Leave a Reply





CAPTCHA Image
*