Try modifying your snipe-it user similar to this, by running the command as the root MySQL user, to ensure it uses mysql password authentication:
alter user snipe-it identified with mysql_native_password by 'newpassword';
Make sure the password matches what's in your snipe-it docker setup of course.