MicroImpact/fix-passwords.sql at main · AviyanshM/MicroImpact · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
USE microimpact;

-- Update all user passwords to bcrypt hash of "microimpact123"
-- This hash below is for: microimpact123
UPDATE users SET password = '$2b$10$N9qo8uLOickgx2ZMRZoMyeIjZAgcfl7p92ldGxad68LPVd0QQSQAY' WHERE email = 'avi@mail.com';
UPDATE users SET password = '$2b$10$N9qo8uLOickgx2ZMRZoMyeIjZAgcfl7p92ldGxad68LPVd0QQSQAY' WHERE email = 'riya@mail.com';
UPDATE users SET password = '$2b$10$N9qo8uLOickgx2ZMRZoMyeIjZAgcfl7p92ldGxad68LPVd0QQSQAY' WHERE email = 'kabir@mail.com';
UPDATE users SET password = '$2b$10$N9qo8uLOickgx2ZMRZoMyeIjZAgcfl7p92ldGxad68LPVd0QQSQAY' WHERE email = 'mehta@mail.com';
UPDATE users SET password = '$2b$10$N9qo8uLOickgx2ZMRZoMyeIjZAgcfl7p92ldGxad68LPVd0QQSQAY' WHERE email = 'nike@mail.com';
UPDATE users SET password = '$2b$10$N9qo8uLOickgx2ZMRZoMyeIjZAgcfl7p92ldGxad68LPVd0QQSQAY' WHERE email = 'adidas@mail.com';
UPDATE users SET password = '$2b$10$N9qo8uLOickgx2ZMRZoMyeIjZAgcfl7p92ldGxad68LPVd0QQSQAY' WHERE email = 'puma@mail.com';
UPDATE users SET password = '$2b$10$N9qo8uLOickgx2ZMRZoMyeIjZAgcfl7p92ldGxad68LPVd0QQSQAY' WHERE email = 'admin@mail.com';

SELECT email, role FROM users;