Skip to main content
Version: 2.4.0

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 check all the users created on an instance, use:

SHOW USERS;

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;

Authorization​

memgraph-platform image

If you are using Docker and memgraph-platform image, you should pass the username and password environment variables when starting Memgraph:

docker run -it -p 7687:7687 -p 7444:7444 -p 3000:3000 -e MGCONSOLE="--username <username> --password <password>" memgraph/memgraph-platform

Example:

docker run -it -p 7687:7687 -p 7444:7444 -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/memgraph --host CONTAINER_IP --username=<username> --password=<password>

Example:

docker run -it --entrypoint=mgconsole memgraph/memgraph --host 172.17.0.2 --username=vlasta --password=vp