If you’ve been using discourse_connect (or most any other such system) just disable it and Discourse will use the local users table. Users will need to go through the forgot password process to set a password (unless you set up social logins like gmail and so on, in which case they can use those if the email address matches the one they signed up with).
At least, that’s probably what will happen. You’d want to do some testing 