SingleStore Managed Service

Adding a User

To add a user, use the GRANT command.

Connect to the Admin endpoint and run:

GRANT <grant_options> TO '<user>'@'<host>' IDENTIFIED BY '<password>'

For example:

GRANT SELECT, INSERT ON db.* TO 'username'@'%' IDENTIFIED BY 'password'

See the GRANT documentation for more details.