Recently I need to upgrade one Joomla 1.0.x installation to the new installation. If you are also dealing with Joomla 1.0 installation to upgrade or maintain and missed the password for admin user.\u00a0 This can also be useful if you need to add new admin user, without disturbing the old user records. Then here are the simple steps to reset the same. It took me some time to find the correct hard way to do it.<\/p>\n
To just reset the password and user name to admin, execute the following query in the phpMyAdmin or MySql command prompt:<\/p>\n
UPDATE `jos_users` SET `password` = MD5( ‘<new_password<\/strong>>’ ) WHERE `jos_users`.`username` = “admin<\/strong>” ;<\/p>\n Do remember to change the table prefix and username to whatever you have in your database. This is quiet easy. But if need to add a completely\u00a0 new user to database without admin access then following steps will help you –<\/p>\n 1. First create a new user record in users table. You can use the insert method of the phpMyAdmin when jos_users table is open. Input following values:<\/strong><\/p>\n Name: admin Then click on Go. This will set the user name and password to “admin”.\u00a0 Note the new Id assigned to the user, you will need that in next step.<\/p>\n 2. Now add a record in the ACL for new user, created above. Open the “jos_core_acl_aro” table and insert a new record:<\/strong><\/p>\n Section Value: users Click on Go button to save the data. Note the ID of new inserted record, this will be needed in next step.<\/p>\n 3. Map the new ACL record to group. Open “jos_core_acl_groups_aro_map” table and insert a new record:<\/strong><\/p>\n Group ID: 25 Click on Go to save the record. That’s it.<\/p>\n Now you should be able to log-in to administration panel by entering User name: admin and Password: admin.<\/strong><\/p>\n <\/p>\n","protected":false},"excerpt":{"rendered":" Recently I need to upgrade one Joomla 1.0.x installation to the new installation. If you are also dealing with Joomla 1.0 installation to upgrade or maintain and missed the password for admin user.\u00a0 This can also be useful if you need to add new admin user, without disturbing the old user records. Then here are […]<\/p>\n","protected":false},"author":17,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"ngg_post_thumbnail":0,"_vp_format_video_url":"","_vp_image_focal_point":[],"footnotes":""},"categories":[26,4],"tags":[],"class_list":["post-390","post","type-post","status-publish","format-standard","hentry","category-quick-fixes","category-web-development"],"_links":{"self":[{"href":"https:\/\/nirvaat.com\/blogs\/wp-json\/wp\/v2\/posts\/390","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/nirvaat.com\/blogs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/nirvaat.com\/blogs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/nirvaat.com\/blogs\/wp-json\/wp\/v2\/users\/17"}],"replies":[{"embeddable":true,"href":"https:\/\/nirvaat.com\/blogs\/wp-json\/wp\/v2\/comments?post=390"}],"version-history":[{"count":3,"href":"https:\/\/nirvaat.com\/blogs\/wp-json\/wp\/v2\/posts\/390\/revisions"}],"predecessor-version":[{"id":393,"href":"https:\/\/nirvaat.com\/blogs\/wp-json\/wp\/v2\/posts\/390\/revisions\/393"}],"wp:attachment":[{"href":"https:\/\/nirvaat.com\/blogs\/wp-json\/wp\/v2\/media?parent=390"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/nirvaat.com\/blogs\/wp-json\/wp\/v2\/categories?post=390"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/nirvaat.com\/blogs\/wp-json\/wp\/v2\/tags?post=390"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
\nUsername: admin
\nEmail: your-email@email.com
\nPassword: af9083d4b82dbc0745b124db3b3cf15d:M0WuLowO4rtRTddG
\nUser Type: Super Administrator<\/p>\n
\nValue: <Generated id of the new user in previous step>
\nOrder Value: 0
\nName: admin<\/p>\n
\nARO ID: <New generated ID from previous step><\/p>\n