I want to integrate google signin, in our existing user registration system. But not sure which approach will be good in terms of data security + user experience (UX) + speed. Even if its a good idea or not in the below scenario, please suggest.

Existing system:

User logs in using username & password.

Registration: Enter email -> send verification link -> click on the link opens registration forms with 30 minutes expiry time.

Registration form:

Choose username, password, pin select country, tick on terms of service done.


Upon successful google authorization and if the user email does not exist in our database. Create new user. Auto-generate username, password, pin, and in a screen show like this. enter image description here
Once the user clicks on the signup button with term tickmark, registration completes and sends a newly generated password, username, pin to the user email.


Same, just-auto generated password & pin will be one-time use only. Once users log in the first time with this credential, prompting the user to change password and pin.


Keep the existing one as usual. Only for So social login, some extra data field will be added to the MySQL user table. Like authorization code. Then same as system 1, just the user will only tick mark the terms of service. Pin and username will be auto-generate. Will send email but the pin will not be sent, the user needs to note down the pin.

Instead of the password will use google authorization system during the time of login?

Please suggest which one use or if there is any better solution then kindly mention.

Thank you in advance.

Note: In MySQL username is not the primary key, UserID which is autogenerated during registration is the primary key.

  • Why are you using both a PIN and a password? Both are typically used as secrets that a user uses to prove their identity, but I can't see a use case for having two secrets for authentication. Commented Aug 10, 2020 at 9:45
  • Actually, during money withdraw we use the pin number as confirmation. In case if a user account get hacked, then without pin number he can't withdraw money.
    – mimi
    Commented Aug 11, 2020 at 1:33


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Browse other questions tagged or ask your own question.