Joomla!, Wordpress tips for building your site

A Few SQL to rescue you with Wordpress

Published on| October 21st, 2010 | No Comment.

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


Leave a Reply


Recent Posts


Tag Cloud

execute remove フロントページ 投稿ページ トップページ install WIndows Note Convert META generator 日付 donwload file manage multibyte utf-8 unicode shiftjis euc console サイトマップ 問題 ParmaLink Redirect パーマリンク はみ出る pre テンプレート テーマ タグクラウド マルチランゲージ リダイレクト PHP(タグ) タグ table control HTML(タグ) コマンド 国際化(翻訳) SQLite(タグ) MySQL(タグ) qTranslate プラグイン(タグ) Wordpress(タグ)


Site Description

Joomla!, Wordpress as CMS using a site building, site management, software usage to describe the development tips.

  • はてなブックマークへ追加する
  • Facebookでシェアする
  • twitter でつぶやく
  • Google Plusでシェアする
  • Pocketでシェアする