Create a database:
db>
create database my_new_project;
OK: CREATE DATABASE
Create a role:
db>
create superuser role project;
OK: CREATE ROLE
Configure passwordless access (such as to a local development database):
db> ... ... ... ... ... ... ...
configure instance insert Auth {
# Human-oriented comment helps figuring out
# what authentication methods have been setup
# and makes it easier to identify them.
comment := 'passwordless access',
priority := 1,
method := (insert Trust),
};
OK: CONFIGURE INSTANCE
Set a password for a role:
db> ...
alter role project
set password := 'super-password';
OK: ALTER ROLE
Configure access that checks password (with a higher priority):
db> ... ... ... ...
configure instance insert Auth {
comment := 'password is required',
priority := 0,
method := (insert SCRAM),
};
OK: CONFIGURE INSTANCE
Remove a specific authentication method:
db> ...
configure instance reset Auth
filter .comment = 'password is required';
OK: CONFIGURE INSTANCE
Run a script from command line:
cat myscript.edgeql | edgedb [connection-option...]