How do you seed a user into the auth schema useing the seed.sql file?

I have tried writing SQL to seed a user into the auth table and it works, but when I try to login it fails, and then why I try to delete the user via the studio I get an API error which says it cant find the user.