On a brand new blank install it was an issue because the create table script never runs. I spent 4 days troubleshooting it until someone on the azerothcore discord server helped me manually run it.

Lets say we have a user with password "weawvHAY65". It was hashed with SHA512 and encoded with base64 using above mysql command resulting below string inserted in the db/auth table: 2022-01-31 ...