Use this tool to reset passwords and fix login issues.
This will set ALL user passwords to admin123
Create a new test user with known credentials
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;
| ID | Username | Full Name | Role | Password (MD5) |
|---|---|---|---|---|
| 1 | superadmin | Super Admin | super_admin | 0192023a7bbd73250516f069df18b500 |
| 2 | admin | City Admin | sacco_admin | 0192023a7bbd73250516f069df18b500 |
| 3 | ruraladmin | Rural Admin | sacco_admin | 0192023a7bbd73250516f069df18b500 |
| 4 | testuser | Test User | sacco_admin | cc03e747a6afbbcbf8be7668acfebee5 |