It’s likely that the issue here is not the content of the user database tables.
Maybe there is a problem with creating a session/cookie.
After trying to log in, can you visit other pages of the manager like for example https://yoursite.com/manager/?a=system/settings?
Maybe it’s the same issue as in this thread: