Authentication Using MySQL Username and Password

For applications requiring integration with MySQL databases, ProcFu supports robust authentication mechanisms using MySQL username and password. Here’s how you can set up this authentication method:

Authentication Setup

• Select MySQL Integration: Begin by choosing the MySQL connection from your list of pre-configured MySQL integrations within ProcFu.
• Configure Authentication Fields:
  • Username Field: Select the appropriate field from your database schema that represents the username. This field will be used to match the username entered by the user during the login process.
  • Password Field: Similarly, select the field that contains the user passwords.
• Specify Additional Conditions: You can add an additional condition to the authentication process to refine the login criteria. This is particularly useful for excluding certain records from the authentication check, such as those marked as deleted. For instance, if your MySQL syncing handles soft deletes, you might include a condition to exclude these records like:

  is_deleted=0

• Select the Key Column: Choose the primary key column of your user table, typically the item_id. This key is crucial as it identifies each user uniquely and can be used to link to subsequent screens or related data within the app. Once authenticated, the primary key of the authenticated user's record will be available as a variable (@[pf_auth_item_id]).