update settings set
value= 'none' where
key= 'members_signup_access';
This will only work in Ghost 4.3 onwards. The UI for this option is currently behind a developer experiments flag and will be made generally available in a future release.
As this is currently in development be aware this setting value may change.