Documentation Request for How to chanage user email and password via phpMyAdmin

Important Considerations

• Multi-Company Accounts: Users may belong to multiple companies within WorkSuite SaaS, which complicates changing credentials. Ensure you have proper authorization before proceeding.
• Data Security: Changing credentials directly in the database should only be done by a trusted individual. Always ensure backups are made before making any changes.

Changing User Email

1. Access phpMyAdmin: Log in to your phpMyAdmin account.
2. Select the Database: Choose the database associated with your WorkSuite SaaS.
3. Locate the Tables:Navigate to the following tables:
   • user_auths
   • users
4. Edit User Email:
   • In each table, find the record for the user whose email you need to change.
   • Edit the email field and save the changes.

Resetting User Password

1. Locate the Table: Go to the user_auths table.
2. Edit User Record: Find the specific user record whose password you need to reset.
3. Generate New Password Hash:
   • Visit 2ri.cc/tools/bcrypt-generator.
   • Enter the new password and generate the bcrypt hash.
4. Update Password Field:
   • Copy the generated hash.
   • In phpMyAdmin, paste the hash into the password field of the user’s record.
   • Ensure the function dropdown is set to “None.”
5. Save Changes: Submit the form to update the password.