🔧 Password Fix Tool

Use this tool to reset passwords and fix login issues.

Option 1: Reset All Passwords

This will set ALL user passwords to admin123

Option 2: Create Test User

Create a new test user with known credentials

Option 3: Manual SQL Fix

Run this SQL in phpMyAdmin if the above doesn't work:

-- Reset all passwords to 'admin123' (MD5 hash)
UPDATE users SET password = MD5('admin123');

-- Or create a new admin user
INSERT INTO users (sacco_id, username, password, full_name, role, status) 
VALUES (1, 'newadmin', MD5('admin123'), 'New Admin', 'sacco_admin', 'active');

-- Check what passwords are stored
SELECT id, username, password, role FROM users;
            

Current Users in Database:

IDUsernameFull NameRolePassword (MD5)
1superadminSuper Adminsuper_admin0192023a7bbd73250516f069df18b500
2adminCity Adminsacco_admin0192023a7bbd73250516f069df18b500
3ruraladminRural Adminsacco_admin0192023a7bbd73250516f069df18b500
4testuserTest Usersacco_admincc03e747a6afbbcbf8be7668acfebee5

Next Steps:

  1. Click "Reset All Passwords to 'admin123'" button above
  2. Try logging in with:
    • superadmin / admin123
    • admin / admin123
    • ruraladmin / admin123
  3. If still not working, Run Database Check

Go to Login Page Check Database