User management
The community edition of Memgraph enables creating users that can access the database with or without a password.
To create a user, execute the following command:
CREATE USER user_name [IDENTIFIED BY 'password'];
Setting up a password is optional. If the password is not set, the user can log in using any password, or none, provided that they enter the correct username.
To set or change a user's password, use the following command:
SET PASSWORD FOR user_name TO 'new_password';
To remove a user's password, set it to null:
SET PASSWORD FOR user_name TO null;
To delete a user use:
DROP USER user_name;
Authorisation
- Docker
- Linux
memgraph-platform image
If you are using Docker and memgraph-platform image, you should pass the
username and password environmental variables when starting Memgraph:
docker run -it -p 7687:7687 -p 3000:3000 -e MGCONSOLE="--username <username> --password <password>" memgraph/memgraph-platform
Example:
docker run -it -p 7687:7687 -p 3000:3000 -e MGCONSOLE="--username vlasta --password vp" memgraph/memgraph-platform
Upon connecting with Memgraph Lab you should select Connect Manually and enter username (and password).
memgraph and memgraph-mage images
If you are using Docker and memgraph or memgraph-mage image enter username
and password when connecting manually to Memgraph Lab.
If you are connecting with mgconsole you should add the username and password
flags to the docker run command:
docker run -it --entrypoint=mgconsole memgraph --host CONTAINER_IP --username=<username> --password=<password>
Example:
docker run -it --entrypoint=mgconsole memgraph --host 172.17.0.2 --username=vlasta --password=vp
If you are using Linux and connecting with Memgraph Lab, select Connect Manually and enter username (and password).
When connecting with mgconsole, set
the --username and --password flags:
./mgconsole --host 127.0.0.1 --port 7687 --username <username> --password <password>
Example:
./mgconsole --host 127.0.0.1 --port 7687 --username vlasta --password vp