Update content

How to add users to a PostgreSQL or MySQL Database Instance

Reviewed on 24 July 2023Published on 21 September 2019

Users can connect to a database and access its data. Each one has a different set of customizable permissions.

Security & Identity (IAM):

You may need certain IAM permissions to carry out some actions described on this page. This means:

  • you are the Owner of the Scaleway Organization in which the actions will be carried out, or
  • you are an IAM user of the Organization, with a policy granting you the necessary permission sets
  1. Click PostgreSQL and MySQL under Managed Databases on the side menu. A list of your Database Instances displays.

  2. Click the database name or «See more Icon» > More info to access the Database Instance information page.

  3. Go to the Users tab. A list of users displays. If it is the first time you create a user, your list will display the user you set up during the creation of your Database Instance.

  4. Click «Plus Icon» to create a new user, if you wish to.

  5. Click «Toogle Icon» to grant admin rights to the user.


    Admin rights allow a user to create logical databases and users. These right do not override the permissions configured for the logical databases. Logical database permissions must be set up in the Permissions tab.

  6. Enter the Username and Password.


    Optionally, you can configure the appropriate permissions according to the user. Three types of permissions are available:

    • None: No access to the database
    • Read: Allow users to read tables and fields in a database
    • Write: Allow users to write content in databases You can select the permission type in the Permissions tab.
  7. Click Create user to confirm.

    Once the user is created, it is displayed in the user list.

To update the password, the permissions or delete the user, click «See more Icon» to display the respective options.

See Also