Entries Tagged 'SQL' ↓

Reset passwords in Wordpress, MediaWiki, Gallery2, Coppermine, PHPNuke, and Joomla

September 11th, 2008 — SQL

Here are some SQL statements to reset passwords in various popular open source web applications.

Reset Coppermine user password:

UPDATE `cpg_users` SET `user_password` = MD5( 'newpassword' ) WHERE `cpg_users`.`user_name` = "tehusername";

Change Gallery2 user email address:

UPDATE `g2_User` SET `g_email` = 'new_email' WHERE `g2_User`.`g_userName` = 'tehusername' LIMIT 1 ;

Reset PHPNuke user password:

UPDATE `nuke_users` SET `user_password` = MD5( 'newpassword' ) WHERE `nuke_users`.`username` = "tehusername";

Reset Wordpress user password:

UPDATE `wp_users` SET `user_pass` = MD5( 'newpassword' ) WHERE `wp_users`.`user_login` = "tehusername";

Reset Drupal administrator password:

UPDATE `users` SET `pass` = MD5('newpassword') WHERE `uid` =1 LIMIT 1;

Reset Joomla administrator password:

UPDATE mos_users SET password = MD5( ‘newspassword‘ ) WHERE username = ‘admin’;

Reset MediaWiki user password:

UPDATE user SET user_password=md5(concat(user_id,'-',md5('newpassword'))) WHERE user_name = "TehUsername";

Reset MediaWiki administrator password:

UPDATE user SET user_password=md5(concat('1-',md5('newpassword'))) WHERE user_id=1;

Create MediaWiki user (usernames must begin with a capital letter):

INSERT INTO user(user_name) VALUES ("TehUsername");
UPDATE user SET user_password=md5(concat(user_id,'-',md5('newpassword'))) WHERE user_name = "TehUsername";

No Comments